Re: Linking a Frontpage 2000 form to an existing Access DB
- From: "Jens Peter Karlsen [FP-MVP]" <jpkarlsen@xxxxxxxx>
- Date: Thu, 06 Oct 2005 08:26:34 +0200
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.
On Wed, 5 Oct 2005 12:18:01 -0700, anoyse
<anoyse@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>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!
.
- Prev by Date: Re: Preventing video clips downloads!
- Next by Date: Re: Slight problem with form
- Previous by thread: Re: Preventing video clips downloads!
- Next by thread: Re: Slight problem with form
- Index(es):
Relevant Pages
|
Loading
