Connectiong to Paradox DB with ODBC via PHP

[jhannley]

Hi,

I have a paradox DB that I created a DSN ODBC connection with in Windows 2008. I also have apache running on the same box.

I am trying to connect to the db via ODBC and PHP but I have hit some serious road blocks.

My PHP script, parses the DB and extracts the information to a MYSQL database every 10 seconds. The issue is that it dies, not when I connect to the ODBC datasource but when I query against it! But it's not consistent.... for example:

There are times when my script runs without any issues!
There are times when it dies completely barfing error code: S0002 - essentially telling me it can't find the table.
There are times when it consistently works one iteration and then dies every second iteration...

I can view this database in EXCEL, 100% at all times via ODBC!

Does anyone have any suggestions or thoughts onto what's happening here?

Thanks,
Jeremiah

 

[ingresman]

Can you report the actual MYSQL error ?
Could you run ODBC tracing and see what is going over the wire at the time of failure ?
Do you have to use ODBC in the PHP >, xould you use the MYSQL extnetion ?