MySql So confused

[Dinz]

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..........

[TheMechanic]

Still confused

Am I correct when I use this

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

[Helger]

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