dkirk Posted October 6, 2007 Share Posted October 6, 2007 I have an MS Access db that I am connecting to via ODBC. Within the Access db, I have a linked table from a AS400 db which is also connected via ODBC through MS Access. I have created a query within Access using fields from the AS400 table. I am trying to extract info from the AS400 query in Access by using php. My problem is that the MS Access connection does not require a user name and password to connect but the AS400 connection requires both. Of course it is no problem connecting to either of these db's using a seperate connection but I cannot extract info from the AS400 query in Access using php. I have created the query in Access because the table size in the AS400 is huge and I only require info from a few of the fields. Is there anyway to "connect within a connection"? I hope this makes a little bit of sense.... Quote Link to comment Share on other sites More sharing options...
Barand Posted October 6, 2007 Share Posted October 6, 2007 Why don't you connect directly to the AS/400 with a client access odbc connection Quote Link to comment Share on other sites More sharing options...
dkirk Posted October 6, 2007 Author Share Posted October 6, 2007 I could connect directly but the table size from which I need the info from is so large, it takes about 10 minutes to return the results from the query statement. The table which I am pulling info from is in the neighborhood of 2GB. This is why I have created a query through Access. Through the query the file size is dropped to around 60MB... Quote Link to comment Share on other sites More sharing options...
amatz Posted August 12, 2008 Share Posted August 12, 2008 sir/maam; Quote Link to comment Share on other sites More sharing options...
Barand Posted August 12, 2008 Share Posted August 12, 2008 Have you tried creating a logical file (view) on the AS400 containing the fields and indexes you need, and querying that file? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.