ASP ADO Error - ODBC Connection Failed - Using SQL Server Linked Tables In Access 
Author Message
 ASP ADO Error - ODBC Connection Failed - Using SQL Server Linked Tables In Access

I am using SQL Server 2000 sp3. The mdac version on the web server is
2.7. I am linking one table from sql server into an Access 2000 Database
using an ODBC connection from a system DSN. There is a query that joins
the data from the sql server table onto some jet tables. Everything runs
correctly from within Access. Only when I try and select * from my
Access query within ASP do I get the

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'MyDSN'
failed.

Which is the DSN for the linked table to the sql server.

Any help would be appreciated

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Sat, 30 Jul 2005 04:42:14 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. ASP error with ODBC Access base and linked table with ODBC Mysql

2. Error while opening access database (.mdb ) using ADO connection in ASP

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

4. Link SQL server table to Access using ADO

5. SQL Server linked tables in Access 2K databases using ODBC

6. Linking Access 7.0 to SQL Server 7.0 tables using ODBC File DSN

7. Linking Access 7.0 to SQL Server 7.0 tables using ODBC File DSN

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

9. Insert JPG in SQL via ODBC linked table in Access fails

10. ASP Access Query of a linked SQL Server Table

11. ODBC Error - saving a view in SQL 2000 using table from linked SQL 7

12. ODBC Call Failed -- SQL Server table link


 
Powered by phpBB® Forum Software