[thelist] ms access website solution?

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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.
:
: MDAC_TYP
: 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
all.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: Error Message:
: ---------------------------
: Unable to connect to database from the web server using the connection
: string,
: DRIVER={Microsoft Access
Driver(*.mdb)}-;DBQ=URL=_private/fpdb/supplier.mdb
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

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.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: The following error message comes from the database driver software.It may
: appear in a 'different language' depending on how the driver is
configured.
:
: 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
debug...

Cheers
Ken