Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

mysql vb6 Connection String

Comment:

i`m stuck please can someone help!!! this is my connection string at the moment, Set Conn3 = New ADODB.Connection Conn3.CursorLocation = adUseClient Conn3.ConnectionString = "DRIVER={MySQL ODBC 3.51 Driver};" _ & "SERVER=127.0.0.1;" _ & "DATABASE=powercardb;" _ & "UID=root@localhost;" _ & "PWD=monktfat;" _ & "OPTION=" & 1 + 2 + 8 + 32 + 2048 + 16384 'SET ALL PARAMETERS Conn3.Open

Debug code for LEDs

DOS variables

Post Locked

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

Summary: 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};SERV...

Summary: OK im trying to connect my local machine to my local sql database in VB6 but the connection strings i`ve tried dont work, i have set ado 2.7 as a reference ,the sql service is running as server name "...

Summary: Hi there i`m in need of some help with a connection string to an access db on an ftp site that has a usr name and pass word...is this possible??? or does it have to be http? please help. this is what ...