"Can't connect to MySQL server on 'localhost' (10061)"

From: Ron Coleman <ron(at)sigmatek.biz>
Date: Thu Sep 20 2007 - 18:18:54 EDT

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:		
	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 
		SQLHANDLE           00000000
		SQLHANDLE *         00079540

odbcad32        14f8-1508	EXIT  SQLAllocHandle  with return code 0

(SQL_SUCCESS)

		SQLSMALLINT                  1 
		SQLHANDLE           00000000
		SQLHANDLE *         0x00079540 ( 0x00ab1540)

odbcad32        14f8-1508	ENTER SQLSetEnvAttr 
		SQLHENV             00AB1540
		SQLINTEGER                 200 
		SQLPOINTER          0x00000003
		SQLINTEGER                   0 

odbcad32        14f8-1508	EXIT  SQLSetEnvAttr  with return code 0

(SQL_SUCCESS)

		SQLHENV             00AB1540
		SQLINTEGER                 200 
		SQLPOINTER          0x00000003 (BADMEM)
		SQLINTEGER                   0 

odbcad32        14f8-1508	ENTER SQLAllocHandle 
		SQLSMALLINT                  2 
		SQLHANDLE           00AB1540
		SQLHANDLE *         0007953C

odbcad32        14f8-1508	EXIT  SQLAllocHandle  with return code 0

(SQL_SUCCESS)

		SQLSMALLINT                  2 
		SQLHANDLE           00AB1540
		SQLHANDLE *         0x0007953C ( 0x00ab15e8)

odbcad32        14f8-1508	ENTER SQLDriverConnectW 
		HDBC                00AB15E8
		HWND                00000000
		WCHAR *             0x74329A38 [      -3] "******\ 0"
		SWORD                       -3 
		WCHAR *             0x74329A38 
Do you need help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:
Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
		SWORD                        2 
		SWORD *             0x00000000
		UWORD                        0 

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 

		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 
Do you need more help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:
Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
		SQLWCHAR *          0x00079284 (NYI) 
 		SQLINTEGER *        0x00079304
		SQLWCHAR *          0x00AB1AE8 (NYI) 
 		SQLSMALLINT                512 
		SQLSMALLINT *       0x000792D0

odbcad32        14f8-1508	ENTER SQLFreeHandle 
		SQLSMALLINT                  2 
		SQLHANDLE           00AB15E8

odbcad32        14f8-1508	EXIT  SQLFreeHandle  with return code 0

(SQL_SUCCESS)

		SQLSMALLINT                  2 
		SQLHANDLE           00AB15E8

odbcad32        14f8-1508	ENTER SQLFreeHandle 
		SQLSMALLINT                  1 
		SQLHANDLE           00AB1540

odbcad32        14f8-1508	EXIT  SQLFreeHandle  with return code 0

(SQL_SUCCESS)

		SQLSMALLINT                  1 
		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=lists@pantek.com

Received on Fri Sep 21 17:40:34 2007