I am attempting to join two tables through an 'INDEX' field like so: SELECT w.LOCATION, w.BOLIN, w.DATEIN, w.LOT, w.QTY, w.UNITMEAS, w.CUSTCODE, w.WEIGHT, w.PRODUCTCODE, , w."INDEX", w.QUAR FROM wrhse AS w, items AS s , WHERE w.DATEOUT IS NULL AND s.poCode ='"+txtpoCode+"' AND w."INDEX" = s."INDEX" However I am not getting a result. Initially I was using the following: sql = 'SELECT * FROM subitemsTEST.DB WHERE poCode = '"+txtpoCode+"' order by index desc' to get the indexes and from there I would get the data from 'wrhse' having the indexes. But when I get more than 192 rows for some reason the system does not display the complete result set. Why can this be? How can I join two tables? Thank you in advance.

Posted to MB Topic: ASP Classic - Handling Data « ASP Classic Board

{Too Long!}

Posted to MB Topic: PHP « PHP Board

Hi there, I am trying to connect to a Paradox table in PHP using the INTERSOLV ODBC driver provided with Paradox. I am able to connect to the DSN fine but when I try to run a query, I get this error: , Warning: odbc_[e_xec(]) [function.odbc-exec]: SQL error: [INTERSOLV][ODBC Paradox driver][Paradox]Network initialization failed., SQL state S1000 in SQLExecDirect I have checked my lock files and that my BDE has the correct NET DIR location, which is on our server that houses all of our Paradox tables. I have also tried re-installing Paradox several times. I am able to open the tables from this machine using Paradox with no error so I'm confused as to why this could be happening. Any help would be much appreciated. Thanks!

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board

Hi Steven, Thanks for the answer. I ended up solving the problem. The issue was that I was using Anonymous Authentication for the site on IIS and the user that was being used was a user that did not have appropriate permissions to access the lock file over the network. Hopefully this can help others who might run into this problem. Thanks!

Posted to MB Topic: Paradox Setup, Vista, etc. « Paradox Board