vbscript + odbc

External Since: Jun 02, 2004 Posts: 1

I am interested in finding a method to use vbscriptto create an odbc
connection to an ACCESS.mdb file. (To replace Start/Control
Panel/ODBC/NEW...)

thanks

External Since: Jun 15, 2004 Posts: 4

Hey

Make a rreference to the ADO library then:

Dim objCnn as New ADODB.Connection

objCnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\NorthWind.mdb"
objCnn.Open()

Once you have established a connection, you can then create recordsets, etc
by passing
the connection object (objCnn) into the Recordsets Open Method.

Hope this helps.

Ivan

"Franck" wrote in message

> I am interested in finding a method to use vbscriptto create an odbc
> connection to an ACCESS.mdb file. (To replace Start/Control
> Panel/ODBC/NEW...)
>
> thanks
>
>