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.... Link to comment https://forums.phpfreaks.com/topic/72042-odbc-help/ 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 Link to comment https://forums.phpfreaks.com/topic/72042-odbc-help/#findComment-363032 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... Link to comment https://forums.phpfreaks.com/topic/72042-odbc-help/#findComment-363043 Share on other sites More sharing options...
amatz Posted August 12, 2008 Share Posted August 12, 2008 sir/maam; Link to comment https://forums.phpfreaks.com/topic/72042-odbc-help/#findComment-614174 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? Link to comment https://forums.phpfreaks.com/topic/72042-odbc-help/#findComment-614274 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.