ASP error with ODBC Access base and linked table with ODBC Mysql 
Author Message
 ASP error with ODBC Access base and linked table with ODBC Mysql


I have an ACCESS Base with
Linked Table to ODBC Databases (MyODBC)
That work fine in ACCESS and client HTML
like this connection.

ADOConnection1.Open "DRIVER={Microsoft Access Driver (*.mdb)};
DBQ=" & pathbase
<OBJECT id=ADOConnection1

I was REALLY AMAZED when I saw that. I can store the databases on a
Linux or Solaris box, but have neat-o front ends using MS Access.

I like utilize this goody with ASP in IIS server.
When a try to connect with ASP in IIS server,
the connection fall when ODBC try to access to the
linked base (Mysql) and I receive this error message :

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][Pilote ODBC Microsoft Access] ODBC --
failure to connect at 'gnm test'.
/Projet1/_ScriptLibrary/Recordset.ASP, line 466

However I can create a "data environment" in global.asa and access to
the data in the linked base from Visual Interdev.

I don't know enough the mechanism of ASP and ODBC to  understand
why I have this bug.

Thank you  for any help.

Manfred HANKE

Sat, 22 Nov 2003 22:55:28 GMT
 [ 1 post ] 

 Relevant Pages 

1. BUG with asp and ODBC Access base with linked table with ODBC Mysql

2. ASP ADO Error - ODBC Connection Failed - Using SQL Server Linked Tables In Access

3. Strange ODBC errors using DAO to access linked tables in Access .MDB

4. Access and linked ODBC tables don't use ODBC Definition

5. ODBC Error (SQL0206N) linking a table from Access 97

6. ODBC error linking Btrieve tables with Access after Pervasive SP3 installed

7. ODBC error when linking to DB2 table from Access 2000

8. odbc link access base

9. Linked Table between SQL 6.5 and Access 2.0 or Access 97 through ODBC

10. Accessing Linked Oracle Tables in Access Using ODBC in VB

11. Preventing table update when linking oracle database table to access via ODBC

12. Error Accessing ODBC Linked Server - Error 7356

Powered by phpBB® Forum Software