-
ODBC Linked Table within Access database
I have an access database containing multiple tables, queries and an ODBC linked table to a dos multivalue database system. I am running a query on this linked table which runs perfectly when you run the mdb from the desktop. The problem is that when you try to run it from an aspdb(enterprise) webpage it gives the following error
Error # (Get_RS_GetCount - 1 -SELECT COUNT(*) as c from qstock) = 80004005(-2147467259)
Description = [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'BM' failed.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S1000
Native Error = -2001
where BM is the system DSN for the multivalue database.
The ODBC is a read only driver and the connection is username & pwd protected.
What am I doing wrong?
I hope we can make this work.
Regs
Tony
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|