MS Access ODBC connections

[ScottCybak]

Hi, i'm currently using an obdc dns name to connect a php app i'm working on to an access db. The only problem is coming in that, in the access database i'm querying, there is a linked table, and when i try to execute a query which includes this table, i'm getting an error message saying that it's locked or not set to be shared.

Do i have to literally include the joined tables into the db, or should i create another dns entry? I'd love to be able to somehow include the related db with the one i have setup as i can use some crazy Joins to do stuff rather then querying different databases.

Anyone have any ideas? Thanks in advance! Scott Cybak
scott@athree.com

 

[rycamor]

I believe you have to have an ODBC DSN for every database involved. Authentication is not "passed along" with the linked table. I think, though, once you have the DSN, the linked table will work as if normal.

However, I can't guarantee this. I have had a bear of a time on some occasions, trying to get PHP to recognize multiple data sources. This is especially bad if you are connecting accross network groups on a Windows Proxy server. -------------------------------------------

"Calculus is just the meaningless manipulation of higher symbols"
                          -unknown F student