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/myodbc?unsub=...ie.nctu.edu.tw