Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Subject: "Can 't connect to MySQL server on 'localhost ' (10061) "

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

2007-09-21       - By Ron Coleman

 Back
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=mysql@(protected)