Unanswered: Suggestions for a MyODBC connection error.
Hardware and Software
FROM: Windows NT Service Pack 6 Server
TO: Linux Server, SuSE Pro distribution
Database: MySQL - SuSE Pro distribution
MyODBC version: 3.51
[MySQL] [ODBC 3.51 Driver] Lost connection to MySQL server during query
I have downloaded from mysql.com, the MySQL Connector/ODBC 3.51 Installation files (exe). After a successful install, I was able to open the ODBC Data Source Administrator and create a DSN using the MySQL 3.51 driver as a choice. My DSN values are:
Data Source Name: connMysql
Description box: null
Host or Server Name (or IP): 172.16.2.25
Database Name: americaldb
User box: root
Password box: xxxxxxxx
Port box: default ’3306’.
SQL Command: null
Driver Options: no options selected
After I click the "Test Data Source" button, I received the error message as noted above: [MySQL] [ODBC 3.51 Driver] Lost connection to MySQL server during query.
I receive the same error when trying to use a ASP page using VBScript.
I receive the same error with the sample database as well.