[thelist] ms access website solution?

Ken Schaefer ken at adOpenStatic.com
Sun May 2 19:53:27 CDT 2004

From: "Robert Teasdale" <robert.teasdale33 at ntlworld.com>
Subject: Re: [thelist] ms access website solution?

: I think I may also be experiencing this loss of database
: connection since MDAC recommended upgrade.
: Win32 Cabinet Self Extractor
: I appear to have lost and cannot create new database connections using
: Office XP Pro with FP2002.

David was talking about not being able to update a database. How is this the
same as not being able to connect to a database?

mdac_typ.exe is the name for all MDAC updates. I think you'd need to be able
to tell us what MDAC you have before, and what you have now. Be aware also
that recent MDACs do not update the Jet ODBC drivers or OLEDB Providers at

: Error Message:
: ---------------------------
: Unable to connect to database from the web server using the connection
: string,
: DRIVER={Microsoft Access

That connection string appears to have a syntax error in it - there's a "-"
character just before the first ";". I do not think that's legal.

Also, as mentioned, consider using the Jet OLEDB Provider:

Provider="Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.Mappath("_private/fpdb/supplier.mdb") & ";"

Otherwise, if you are having Frontpage generate these connection strings, I
suggest you ask in an FP group.


: The following error message comes from the database driver software.It may
: appear in a 'different language' depending on how the driver is
: The specified procedure could not be found (ADODB.Connection)
: Source ADO
: Number -2147024769(0x80070107f)
: ---------------------------
: Do you know what this error message means?

You are trying to execute a parametised query, but the query can not be
found in the database. Without source code, it is impossible for me to


More information about the thelist mailing list