"Can't connect to MySQL server on 'localhost' (10061)"
"Ron Coleman" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <000101c7fbd4$3b87e9f0$b297bdd0$@biz> |
Dear List, When I test the DSN connector that I have configured on the "Connector/ODBC 3.51.20 - Configure Data Source Name" form, I get the following diagnostic message: [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061). I have read everything in the manual concerning ODBC Connections and Section B.1.2.2. "Can't connect to [local] server". I have checked everything that was suggested. The server is running - I see it in the process list. I can connect to the server from SQL Administrator and SQL Query Browser. My settings for the DSN are: LOGIN: Data Source Name: myodbc Description: MySQL ODBC DSN Server: localhost User: ron Password: <rons-correct-password> Database: CONNECT OPTIONS: Port: 3306 Socket mysql ADVANCED: Force Use of Named Pipes checked (note: tried this both ways) Read Options From my.cnf checked (note: tried this both ways, my.cnf was modified as suggested) All others unchecked Below is the trace of a test: odbcad32 14f8-1508 ENTER SQLAllocHandle SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 00000000 SQLHANDLE * 00079540 odbcad32 14f8-1508 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 00000000 SQLHANDLE * 0x00079540 ( 0x00ab1540) odbcad32 14f8-1508 ENTER SQLSetEnvAttr SQLHENV 00AB1540 SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION> SQLPOINTER 0x00000003 SQLINTEGER 0 odbcad32 14f8-1508 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS) SQLHENV 00AB1540 SQLINTEGER 200 <SQL_ATTR_ODBC_VERSION> SQLPOINTER 0x00000003 (BADMEM) SQLINTEGER 0 odbcad32 14f8-1508 ENTER SQLAllocHandle SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 00AB1540 SQLHANDLE * 0007953C odbcad32 14f8-1508 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 00AB1540 SQLHANDLE * 0x0007953C ( 0x00ab15e8) odbcad32 14f8-1508 ENTER SQLDriverConnectW HDBC 00AB15E8 HWND 00000000 WCHAR * 0x74329A38 [ -3] "******\ 0" SWORD -3 WCHAR * 0x74329A38 SWORD 2 SWORD * 0x00000000 UWORD 0 <SQL_DRIVER_NOPROMPT> odbcad32 14f8-1508 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR) HDBC 00AB15E8 HWND 00000000 WCHAR * 0x74329A38 [ -3] "******\ 0" SWORD -3 WCHAR * 0x74329A38 SWORD 2 SWORD * 0x00000000 UWORD 0 <SQL_DRIVER_NOPROMPT> DIAG [HY000] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 'localhost' (10061) (2003) odbcad32 14f8-1508 ENTER SQLGetDiagRecW SQLSMALLINT 2 SQLHANDLE 00AB15E8 SQLSMALLINT 1 SQLWCHAR * 0x00079284 (NYI) SQLINTEGER * 0x00079304 SQLWCHAR * 0x00AB1AE8 (NYI) SQLSMALLINT 512 SQLSMALLINT * 0x000792D0 odbcad32 14f8-1508 EXIT SQLGetDiagRecW with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 SQLHANDLE 00AB15E8 SQLSMALLINT 1 SQLWCHAR * 0x00079284 (NYI) SQLINTEGER * 0x00079304 (2003) SQLWCHAR * 0x00AB1AE8 (NYI) SQLSMALLINT 512 SQLSMALLINT * 0x000792D0 (77) odbcad32 14f8-1508 ENTER SQLGetDiagRecW SQLSMALLINT 2 SQLHANDLE 00AB15E8 SQLSMALLINT 2 SQLWCHAR * 0x00079284 (NYI) SQLINTEGER * 0x00079304 SQLWCHAR * 0x00AB1AE8 (NYI) SQLSMALLINT 512 SQLSMALLINT * 0x000792D0 odbcad32 14f8-1508 EXIT SQLGetDiagRecW with return code 100 (SQL_NO_DATA_FOUND) SQLSMALLINT 2 SQLHANDLE 00AB15E8 SQLSMALLINT 2 SQLWCHAR * 0x00079284 (NYI) SQLINTEGER * 0x00079304 SQLWCHAR * 0x00AB1AE8 (NYI) SQLSMALLINT 512 SQLSMALLINT * 0x000792D0 odbcad32 14f8-1508 ENTER SQLFreeHandle SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 00AB15E8 odbcad32 14f8-1508 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 2 <SQL_HANDLE_DBC> SQLHANDLE 00AB15E8 odbcad32 14f8-1508 ENTER SQLFreeHandle SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 00AB1540 odbcad32 14f8-1508 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS) SQLSMALLINT 1 <SQL_HANDLE_ENV> SQLHANDLE 00AB1540 Do you have any ideas? I'm desperate. I talked my client into to using MySQL instead of MS SQL Server and now I'm stuck. Ron ************************************ Ronald D. Coleman Sigmatek Software Solutions, Inc. 7088 W Elm Brook Drive Boise, ID 83714-6149 (208) 854-1170 ************************************ -- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/[email protected]