MySQL Forums
Forum List  »  Connector/ODBC

Connection Pb - ODBC with ADO/VB
Posted by: xkite
Date: March 13, 2005 06:21AM

Hi,

I'm starting with MySQL (and PHP).

My configuration is :
WIN XP
MySQL Server version 4.1.10-nt-max via TCP/IP
MySQL Client version 5.0.0

I wish to use ADO to connect to my database.
I'm using the connect string below :
"Driver={MySQL ODBC 3.51 Driver};Server=localhost;Port=3306;Option=3;Database=ma_base;Uid=mon_user;Pwd=mon_pwd;"

Whatever are the different connect string (with DNS or not ...), the result is always the same :
Execution Error '-2147467259 (80004005)' :
[MySQL][ODBC 3.51 Driver] Can't connect to MySQL server on 'localhost'(1002)

Nevertheless :
# I connect without problem through :
- MySQL Administrator
- MySQL Query Browser
- CommandLine Client

# When i execute SHOW GRANT FOR 'user'@'localhost'; the result is :
Grant Select, Insert, Update, Delete ON *.* TO 'my_user'@'localhost' IDENTIFIED BY 'my_pwd'

# I have created a DSN ODBC who seems to work correctly :
Param\Conf Panels\Admin Tools\Data Source (ODBC)\Onglet System ou
User
Name : MyODBC-user
Driver : MySQL ODBC 3.50 Driver
Server : localhost
User : my_user
Pwd : my_pwd
DB : my_base
Port 3306
If i push button "test" i get "Success; Connection was made"

I don't knwo what to do more :(

P.S : As i'm working for now with 'localhost', maybe i would better used Named Pipes ? If yes ... how ?

Thanks for your answers

Options: ReplyQuote


Subject
Written By
Posted
Connection Pb - ODBC with ADO/VB
March 13, 2005 06:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.