dbTalk Databases Forums  

How to connect to MySql database via ODBC?

comp.databases.mysql comp.databases.mysql


Discuss How to connect to MySql database via ODBC? in the comp.databases.mysql forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
hannu
 
Posts: n/a

Default How to connect to MySql database via ODBC? - 07-08-2009 , 02:09 AM






I have a MySql datebase in my computer and I'm trying to connect it
from another computer. Both computer are in AD.
When I give to parameter Server my computers ip-address and my User
and Password are correct, and I'm trying to Test it gives me:

"Connection Failed:[HYOOD][MYSQL][ODBC 5.1 DRIVER]Can't connect to
MYSQL server on 'ip-address'[10060]"

It connect perfect in my own comuputer when I put Localhost into
Server-parameter.

What is wrong?

Hannu

Reply With Quote
  #2  
Old   
Álvaro G. Vicario
 
Posts: n/a

Default Re: How to connect to MySql database via ODBC? - 07-08-2009 , 02:17 AM






hannu escribió:
Quote:
I have a MySql datebase in my computer and I'm trying to connect it
from another computer. Both computer are in AD.
Active Directory should not be relevant.

Quote:
When I give to parameter Server my computers ip-address and my User
and Password are correct, and I'm trying to Test it gives me:

"Connection Failed:[HYOOD][MYSQL][ODBC 5.1 DRIVER]Can't connect to
MYSQL server on 'ip-address'[10060]"

It connect perfect in my own comuputer when I put Localhost into
Server-parameter.
Most likely, there's a firewall blocking connections. You have to open
the MySQL port, which defaults to 3306.

Also:

- Make sure you haven't disabled networking (see the skip_networking
parameter).
- Check you have an user with permission to connect from the other
computer (e.g. john@%)


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

Reply With Quote
  #3  
Old   
hannu
 
Posts: n/a

Default Re: How to connect to MySql database via ODBC? - 07-08-2009 , 03:09 AM



On 8 heinä, 09:17, "Álvaro G. Vicario"
<alvaro.NOSPAMTH... (AT) demogracia (DOT) com.invalid> wrote:
Quote:
hannu escribió:

I have a MySql datebase in my computer and I'm trying to connect it
from another computer. Both computer are in AD.

Active Directory should not be relevant.

When I give to parameter Server my computers ip-address and my User
and Password are correct, and I'm trying to Test it gives me:

"Connection Failed:[HYOOD][MYSQL][ODBC 5.1 DRIVER]Can't connect to
MYSQL server on 'ip-address'[10060]"

It connect perfect in my own comuputer when I put Localhost into
Server-parameter.

Most likely, there's a firewall blocking connections. You have to open
the MySQL port, which defaults to 3306.

Also:

- Make sure you haven't disabled networking (see the skip_networking
parameter).
- Check you have an user with permission to connect from the other
computer (e.g. john@%)

--
--http://alvaro.es- Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web:http://borrame.com
-- Mi web de humor satinado:http://www.demogracia.com
--
Thanks! It was really the Firewall. I allowed port 3306 and now it's
working.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.