Devart Forums

Hi Forum,

I just downloaded Devart ODBC Driver for MySQL and when i test the connection i am getting the following error message:

[Devart][ODBC][MySQL]
ReceivHeader:Net packets out of order: Received[45], expected[0]

I am able to connect using Putty.exe, but i need to connect via VBScript. When i run the VBScipt i get a different error message: The following is my connection string i have in the script:

ConnString = "DRIVER={Devart ODBC Driver for MySQL}; User ID=root; Password=root; SERVER=79.69.69.30; Port=1900; DATABASE=mysql_DB; " &_
"Use SSH=True; SSH Hostname=79.69.69.30; SSH Port=22; SSH Username=root; SSH Password=root"

'create an instance of the ADO connection and recordset objects
Set Connection = CreateObject("ADODB.Connection")
Set Recordset = CreateObject("ADODB.Recordset")

'Open the connection to the database
Connection.Open ConnString ' *** this is where the error occurs....

The following is the message that i am getting when i run the VBScript:

[Devart][ODBC][MySQL]Cannot connect to server on host '79.69.69.30':
No connection could be made because the target machine actively refused it.
Socket Error Code: 10061($274D)
Code: 80004005
Source: Microsoft OLE DB Provider for ODBC Drivers

Any suggestions on what i am doing wrong ro what do i need to fix this issue.
I can connect using Putty.exe and also using ZOC7 Terminal...

Regards,
Manuel Roman

Hello,

We can't reproduce the issue on our test servers. If you can give us access to your server, we will test this behavior directly on it.

How can we do it...
I can send you a link to connect with me ?
Please Advise...

Regards,
Manuel Roman

Please send us addresses and ports of MySQL and SSH servers, as well as credentials, to alexp*devart*com