MySql So confused

Search for this Driver in google.............myodbc-2.50.19-win95.zip if ur OS is win 95/98 else myodbc-2.50.19-NT.zip for NT........I am having the same if u want I can mail it u..........fter installin the driver u can use this con string:

strCnn = "driver={MySQL};Server=ipaddress;" & _
"uid=root;pwd=;database=mydatabase"

hope this will help u..........

Still confused

Am I correct when I use this

VB Code:

Option Explicit
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
Private Sub Form_Load()
Set cnn = New ADODB.Connection
Set rs = New ADODB.Recordset
        strCnn = "driver={MySQL};Server=localhost;" & _
"uid=root;pwd=myPass;database=mydatabase"
        cnn.Open = strCnn
End Sub

The localhost is the MySql Database host name
But it still does nothing

I'm not sure about your connection string. However this line will give you an error

cnn.Open = strCnn

replace with

cnn.open strcnn

or (better) with

cnn.connectionstring = strcnn
cnn.open

to get a working connection string try the following:

in 'mycomputer' open that control panel or whatever it's name is in English.

there you will have 'Data Sources'

Double click and create a new entry (= DNS)
the advantage being that you can test the connection and stuff first. after you found it working simply add a dataenvironment to your project. set up a connection with your newly created dns. copy and paste the dns - text from the DE-connection to your original code and delete the Dateenvironment.
There you go :).

Helger