RE: MyODBC for XP connects Linux MySQL Server - J.R. Bullington - com.mysql.lists.win32

12 messages in com.mysql.lists.win32RE: MyODBC for XP connects Linux MySQ...

From	Sent On	Attachments
Tata Respecia	05 Sep 2005 22:59
Bernard LEFEUVRE	06 Sep 2005 00:16
jbon...@sola.com.au	07 Sep 2005 15:43
Tata Respecia	07 Sep 2005 18:49
J.R. Bullington	07 Sep 2005 19:59
Daniel da Veiga	08 Sep 2005 06:46
Jorge Bastos	08 Sep 2005 07:36
SGr...@unimin.com	08 Sep 2005 07:48
Tata Respecia	08 Sep 2005 16:07
Tata Respecia	08 Sep 2005 16:14
J.R. Bullington	08 Sep 2005 18:13
Jorge Bastos	09 Sep 2005 01:10

Subject:	RE: MyODBC for XP connects Linux MySQL Server
From:	J.R. Bullington (bull...@innovatim.com)
Date:	09/07/2005 07:59:35 PM
List:	com.mysql.lists.win32

The ODBC driver does need to be installed on the server, but it sounds as though this is a permissions problem.

Can you connect to the server via 'root'@'localhost'? If so, try the username and password that want to use with your ODBC. If you cannot connect that way, make sure that either you have 'username'@'10.10.10.50' in your user configs, or use 'username'@'%' to make sure that you can connect for the time being.

If not, you probably don't have the connection permissions with the username and password that you are using. Did you set up a DSN to connect to the server or are you using code?

If the former, can you run the TEST DSN and tell us what you get? (is it a 'connection failed' or is it a 'username/password' error?) If the latter, can you post the code, removing the username and password?

There are lots of reasons that the connection string might not work, but I still think that we need more data to help you out.

Here's some data that we will need: What, if any, programming language are you using (PHP, ASP, ASP.NET, VB.NET, Java, etc.) Is your Linux box a web server or is this a client/server config?

J.R.

-----Original Message----- From: Tata Respecia [mailto:tata...@yahoo.com] Sent: Wednesday, September 07, 2005 9:50 PM To: jbon...@sola.com.au; win...@lists.mysql.com Subject: RE: MyODBC for XP connects Linux MySQL Server

when i test the connection it says:

[MySQL][ODBC 3.51 Driver]Can't connect to MySQL Server on ('10.10.10.50') (10065)

i guess ther must be something that i have to install on on the server. only that i don't know what it is or is it possible.

--- jbon...@sola.com.au wrote:

There are several things that could be wrong. How far do you get? Do you get any error messages when you try to test the connection?

John B.

-----Original Message----- From: Tata Respecia [mailto:tata...@yahoo.com] Sent: Tuesday, 6 September 2005 3:29 PM To: win...@lists.mysql.com Subject: MyODBC for XP connects Linux MySQL Server

hello!

can somebody help me how MyODBC for XP connects to mysql server on linux fedora4? is there something that i need to install on the server side? how to install it? my present MyODBC can only connect to mysql server residing on xp box.

thanks, tatarespecia