Hi:



I have two questions regarding this subject:



1. I tried the connection string below and I got the following error:



ADODB.Connection(0x800aoe7a)

Provider cannot be found.  It may not be properly installed.





 strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

     "Data Source=c:\db1.mdb;" & _

    "User ID=Username;" & _

     "Password=Whatever"



I am using WIN2k and Access2000. Now is this simple becuase I don't the

proper Jet provider? If so, where can I get it?



2. What is the difference between the above connection and this one:



"Driver={Microsoft Access Driver (*.mdb)};

DBQ=C:\inetpub\wwwroot\SuperPlayDemo\SP1.mdb"



Thanks



Stefan

www.Studioweb.com

> I have two questions regarding this subject:

>

> 1. I tried the connection string below and I got the following error:

>

> ADODB.Connection(0x800aoe7a)

> Provider cannot be found.  It may not be properly installed.

>

>  strConnect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _

>      "Data Source=c:\db1.mdb;" & _

>     "User ID=Username;" & _

>      "Password=Whatever"



Are you sure that the path is correct above for your DB? You have a db

called db1.mdb in the root of your c:\ drive? Also, the username and

password are correct? If not, just delete those two lines (and it will use

the default Admin user with no password)





> 2. What is the difference between the above connection and this one:

>

> "Driver={Microsoft Access Driver (*.mdb)};

> DBQ=C:\inetpub\wwwroot\SuperPlayDemo\SP1.mdb"



http://www.adopenstatic.com/faq/whyOLEDB.asp



The first connection string is a native JET OLEDB connection string, the

second uses the OLEDB Provider for ODBC Drivers to connect ADO to the ODBC

Jet Driver, which in turn connects to your database.



Cheers

Ken