Linking a Frontpage 2000 form to an existing Access DB

[anoyse]

Hello Everyone,

First off please let me tell you that I am a newbie to Frontpage 2000.

I'm trying to link a form in my web to my existing db. I have the db in the
same folder on our shared drive as the web. I've created an odbc connection
and tried to connect but I get the following error.

Server error: Unable to retrieve the list of record sources from a database
using the connection string:

DSN=request;DRIVER={Microsoft Access Driver (*.mdb)}.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------


Source: ADO
Number: -2146824584 (0x800a0e78)

This is going to be a web on a corporate intranet site. What steps am I
missing. Do I need to publish the web? How do I create the correct connection
string?

Any insight would be greatly appreciated.
Thanks!

 

[Jens Peter Karlsen [FP-MVP]]

Using ODBC your connection string should look like this:
"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"

With OleDB:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User
Id=admin;Password=;"

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.