ASP / MySQL / Microsoft.Jet.OLEDB.4.0

[yesudoo]

Hello,

I am banging my head against a brick wall with this.

I am using ASP - wanting to connect to a MySQL database using Microsoft.Jet.OLEDB.4.0.

This is the code I have - but am not able to make the connection with the database - what am I missing? Any help greatly appreciated!

--------
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=213.171.200.66;Jet OLEDB:System Database=test;User Id=testadmin;Password=testing17;"

Set Conn = Server.CreateObject("ADODB.Connection")

Conn.Open(sConnection)
--------

 

[ChrisHirst]

Jet is for connecting to Microsoft databases not MySql.


You need to install the MySql ODBC driver

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[yesudoo]

Thanks Chris - I had been mis-advised.