Computing.Net > Forums > Programming > VB6 Mysql remote connection string

Computing.Net: Over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to sign up now, it's free!

VB6 Mysql remote connection string

Reply to Message Icon

Original Message
Name: Anthony Arde
Date: December 5, 2005 at 01:07:23 Pacific
Subject: VB6 Mysql remote connection string
OS: win Xp Pro Sp2
CPU/Ram: 3.2 P4
Comment:

Hi there, please can someone help me out, i`m really having a tough time tring to connect to my remote mysql DB, this is the connection string i`m using :

Conn3 = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=196.68.218.144;PORT=3306;DATABASE=PowerB; USER=admint;PASSWORD=monkfatwhy;OPTION=3;"
Conn3.Open

when i log into the online DB via phpMyAdmin it says mysql running on localhost as admint@localhost , does this mean that this is my server name?? please help thanks Anthony - (ive just made up dummy password and usrname and ip)


Report Offensive Message For Removal








Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home








Do you have your own blog?

Yes
No
I did before
I will soon


View Results

Poll Finishes In 4 Days.
Discuss in The Lounge
Poll History




Data Recovery Software