Heeeeeeellllllppppp!!!!!!!!!!!!!

[J_BEYTIA]

What is wrong with this connection String?

set adoConn = server.CreateObject("ADODB.Connection")
set adoCmd = server.CreateObject("ADODB.Command")

strConnectionString = "PROVIDER=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;DefaultDir=C:\Program Files\Microsoft Office\Office\Samples;Driver={Microsoft Access Driver (*.mdb)};DriverId=281;FIL=MS Access"

adoConn.Open strConnectionString

I get the following Error:

ADODB.Connection error '800a0e7a'

ADO could not find the specified provider.

Can Someone Please Help.
Thanks In Advance!

[Sastraxi]

Why can't you just access it without a provider? Why would you need one?

[J_BEYTIA]

When I make a Data Environment Connection it creates a connection string in globa.asa It puts the provider in there. Is there an easier way of doing this. How about some Code Sample

[kayoca]

Try this provider Microsoft.Jet.OLEDB.4.0.

[jestes]

Public objConn as ADODB.connection
Public objCmd as ADODB.command

Private Sub ADOConnection ()

set objConn = New ADODB.Connection

objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\VB98\people1.mdb;Persist Security Info=False"

objConn.Open

Use this if you're connecting to an Access 2000 db. change your provider to 3.51 if you're using 97.