TMyConnection and LAN Server

[BarryW]

Hi All,

I'm not a newbie but I feel that way right now.

Trying to connect to MySQL Server on Windows Server 2003 SBS from a Windows XP Pro workstation.

Tried every imaginable option to no avail. Read through the posts in this forum and tried them all to no avail.

Keep getting the following error messages:

"Can't connect to MySQL server on 'localserver' (10061)
Socket error on connect. WSAGetLastError return 11001($2AF9)"

"Can't connect to MySQL server on '192.168.0.2' (10061)
Socket error on connect. WSAGetLastError return 10061($274D)"

MySQL Installed Version is 5.1.34
Devart MyDAC is latest version for Delphi 7 - trial mode as I am testing this for a software development project

I have enabled Port 3306 on the Server.

Connection Parameters:

User Name: root
Password: password
Server: I have tried:
192.168.0.2
localserver
sbs.server.local
\sbs\mysql
Port: 3306
Database: datadb

When I use localhost, I am able to connect to my local MySQL Server installation on my workstation. But what I really want is to connect to the installation on the network server.

Any and all feedback will be greatly appreciated.

Barry

[BarryW]

Hi,

My apologies for posting such a simple question to the forum.

I found the solution... by changing the Protocol...

Thanks

Barry

[Dimon]

It is good to see that this problem has been solved. If any other questions come up, please contact me.