ADO connection for NT4

[dukkse]

Hey!!

I have a script that gets info and puts into an accessdatabase through VB script. This works fine on win2000 and w2003 machines, but not on NT4:s.

The string I use to connect (and where I get the error message) looks like:

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordSet = CreateObject("ADODB.Recordset")
objConnection.Open _
"Provider = Microsoft.Jet.OLEDB.4.0; " & _
"Data Source = inventory.vbs"

I'll get the errormessage on line objConnection.Open _

I have MDAC 2.7 installed on the servers.

/Daniel

 

[dilettante]

MDAC no longer contains Jet as part of the package. You can still download it separately and install it however.

See Microsoft Knowledge Base Article - 829558.