Error #2044: Unhandled ioError:. text=Error #2031: Socket Error.

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Used the below code in Flex builder 3.0
2. Run/Debug
3. Error.

What is the expected output? What do you see instead?
Display the records in database.

What version of the product are you using? On what operating system?
Windows XP, Flex builder 3.0

Please provide any additional information below.
//Commented out the username/password in SQL connection.
<?xml version="1.0" encoding="utf-8"?>
<mx:Application xmlns:mx="http://www.adobe.com/2006/mxml" 
    xmlns:assql="com.maclema.mysql.mxml.*" 
    layout="absolute">

    <mx:Script>
    <![CDATA[
            import mx.controls.Alert;
            import com.maclema.mysql.events.MySqlErrorEvent;
            import com.maclema.util.ResultsUtil;

            private function handleConnected(e:Event):void {
                    service.send("select * from error_log;");
            }

            private function handleError(e:MySqlErrorEvent):void {
                    Alert.show(e.text);
            }
    ]]>
    </mx:Script>

    <assql:MySqlService id="service"
            hostname="idc1vsql1003/WEBDEV2008:1433" 
            username="xxxxx"
            password="xxxxx"
            database="error_reporting"
            autoConnect="true"
            connect="handleConnected(event)" 
            sqlError="handleError(event)" />

    <mx:DataGrid id="grid" left="10" right="10" top="10" bottom="10"
            dataProvider="{service.lastResult}"

columns="{ResultsUtil.getDataGridColumns(service.lastResultSet)}" />

</mx:Application>

Original issue reported on code.google.com by arun.bi...@gmail.com on 26 Feb 2009 at 6:21

[GoogleCodeExporter]

I've got this error too... Has anyone solved this issue? or understand the 
reasons of it? Can it be because of the MySQL server's config?

Original comment by dborise...@gmail.com on 15 Jun 2010 at 5:23

[GoogleCodeExporter]

The problem is that you have to specify the port as a diferent parameter of 
MySqlService

<assql:MySqlService id="service"
            port="1433"
            hostname="idc1vsql1003/WEBDEV2008" 
            username="xxxxx"
            password="xxxxx"
            database="error_reporting"
            autoConnect="true"
            connect="handleConnected(event)" 
            sqlError="handleError(event)" />

Original comment by mlekolak...@gmail.com on 19 Mar 2011 at 11:40