MySQL Forums
Forum List  »  Connector/ODBC

How to get Uid in MySQL
Posted by: Edmund Foong
Date: March 09, 2005 02:49AM

Hi,

i'm new to MySQL,Can anyOne here tell me how to get the MySQL UID?
I wish to connect the MySQL DB to Visual Basic 6.0.
Below is the code:

Dim conn As ADODB.Connection
Set conn = New ADODB.Connection

conn.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _
& "SERVER=127.0.0.1;" _
& "DATABASE=test;" _
& "UID=XXX;" _ <-------------------
& "PWD=;" _
& "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384

conn.CursorLocation = adUseClient
conn.Open

Thanks for help.

Best Regards,
Edmund Foong.

Options: ReplyQuote


Subject
Written By
Posted
How to get Uid in MySQL
March 09, 2005 02:49AM


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.