MySQL Bugs: #30740: Could not connect to Mysql

Bug #30740	Could not connect to Mysql
Submitted:	31 Aug 2007 5:43	Modified:	30 May 2013 6:48
Reporter:	Chirag Modi	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	ODBC 3.51	OS:	Windows (windows server 2003 service pack 2)
Assigned to:		CPU Architecture:	Any

Description:
we have project in Net 1.1 Framework and DataBase Mysql
Application Server is window server 2003 sp2 and Database server is Linux.
to connnect with Database using ODBC 3.51 Driver and Mysql server 4.1
Recently when we installed Framework 2.0 and Update .net 1.1 with sp1, then
we are getting following Error

ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 
'-server ip-' (10048)

soon we have removed Net 2.0 framework , but this is not working on.
Project is working fine from Last 3 Years.
Recently we have trouble.

Is there any updated ODBC connector driver that help me to recover site?
Please Help me soon, it is Urgent

How to repeat:
we have project in Net 1.1 Framework and DataBase Mysql
Application Server is window server 2003 sp2 and Database server is Linux.
to connnect with Database using ODBC 3.51 Driver and Mysql server 4.1
Recently when we installed Framework 2.0 and Update .net 1.1 with sp1, then
we are getting following Error

ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 
'-server ip-' (10048)

soon we have removed Net 2.0 framework , but this is not working on.
Project is working fine from Last 3 Years.
Recently we have trouble.

Is there any updated ODBC connector driver that help me to recover site?
Please Help me soon, it is Urgent

Suggested fix:
Suggest me any updated ODBC driver to connect with Mysql

Hi Chiraq and thanks for your report. I do not quite understand it... Lets see:

> we have project in Net 1.1 Framework and DataBase Mysql. Application Server is window server 2003 sp2 and Database server is Linux. to connnect with Database using ODBC 3.51 Driver and Mysql server 4.1. Recently when we installed Framework 2.0 and Update .net 1.1 with sp1, then we are getting following Error

ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on 
'-server ip-' (10048)

Afaik, window server 2003 sp2 comes with NET fw 2.0 so what did you upgrade? Did you first downgrade to 1.1 and then upgrade?

Now, what do you need NET + ODBC? Do you use ODBC class in C# program? I fail to understand the connection from your report.

Please, try to calm down and explain exactly what is going on like this:
 - We use System.Data.ODBC bridge for our SW (or whatever)
 - We work on NET fw x.x and use c/NET x.x and MyODBC 3.51.x
 - The problem is that we can't connect to our server with this connect string: "Exact Connect String, without password of course, here"

From the top of my head, are you using "User=" in connect string? It should be "UID=" as per Microsoft changes.

Hi Tonci,
Thanks for your quick reply
we have project in .Net 1.1 langauge vb.net.
In our project we are using System DSN from Control panel --> Data source(ODBC) as connection string.

To make Connection with DB we are using Following Code in Class

Shared Function getConnection() As OdbcConnection
        Try
            Dim conn As OdbcConnection = New OdbcConnection("DSN=Sampledsn;")
            conn.Open()
            Return conn
        Catch ex As Exception
            LogException(ex, "DBManager.getConnection() ")
        End Try
    End Function

By using above code we are getting Below error

ERROR [HYT00] [MySQL][ODBC 3.51 Driver]Can't connect to MySQL server on '-serverip-' (10048)

Now we have Window server 2003 Service pack 2.

is there any solution for that?

Chiraq, that looks ok to me. Can you please tell me which version of MyODBC are you using? 3.51.19? Does you password contain spaces or any special characters like ?/=  etc?

Is it 64bit system?

HI Tonci,

we are using 

processor Intel(R) Xeon (TM) CPU 2.80 Ghz

Password is just 6 character word.

Odbc Driver details

Driver Name : MySql ODBC 3.51 Driver
Version : 3.51.11

HI Tonci,

we are using 

processor Intel(R) Xeon (TM) CPU 2.80 Ghz

Password is just 6 character word.

Odbc Driver details

Driver Name : MySql ODBC 3.51 Driver
Version : 3.51.11.00
File Name : MYODBC3.dll

Chiraq, that too looks ok to me. Can you please do the following:
 - Attach ODBC trace log (Control Panel / Administrative tools / Data Sources (ODBC) / Tracing / check "Machine wide tracing ..." and click "Start tracing now"
 - Double-click DSN and click "Test" and "Diagnostics" if it fails
 - Check server logs to see if anything got to it (ie. request for connect)

Make sure DSN connects to your server! Make sure there is a logged request for connection from your client in server logs.

Then we will see about upgrading MyODBC. You said 3.51.11 worked so far, I don't see why it shouldn't keep working *if* DSN connects. You can try your DSN from Access or Excel too.
If DSN can't connect (from other programs) at all do following:
 - make sure connect request is reaching server. If it's not reaching server check firewalls and similar
 - if it reaches server and you still can't connect, check username/password
 - if it reaches server and username/password combination is valid, upgrade to MyODBC 3.51.19

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm closing this bug because I can not continue without feedback from the reporter. If you have new info, please reopen the report.