How to connect to a database on a webserver

[lmtis]

Hi all,

I am trying to use the database connectivity toolkit, and am having no success.  Using .asp to connect to the database I use the following code:

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

dbInstrumentDB.Open "instrumentdb"

On the server, in the ODBC data source administrator, "instrumentdb" is set in the "System DSN" tab to point to an access database.

The error that I get is : "The file provided is not a datalink (UDL) or a file DSN.

Any help would be apreciated.

Jim

[sirfunusa]

Sounds like you need to create a file dsn instead of a system dsn? This
is done in the ODBC Control Panel applet.