thorak

Ok, I have spent the past 2 days researching this and cant seem to get
anywhere. System setup is:

Win XP PRO sp2
PHP 5.2.5
Apache 2.2.6
Paradox 5 (I think)

One machine has the paradox database on it (used by another program as
well). Another computer has PHP and Apache on it. Unfortunately I
don't have the option of putting it all on the same computer. I have
had a ridiculous amount of problems getting to this error... but
finally past all the other ones. I will refer to these as PHP machine
and Paradox Machine for ease.

I keep getting the following error:

Warning: odbc_connect() [function.odbc-connect]: SQL error:
[Microsoft]
[ODBC Paradox Driver] Could not open Paradox.net., SQL state S1000 in
SQLConnect.

- I setup a test to see if this problem was PHP based or Network
based. Copied the whole paradox data dir onto the PHP machine as
trial. Pointed the ODBC connection to this version of the paradox DB
and everything works fine.... so it definately has something to do
with the network connection... but I don't know what else to try!

- I have tried the instructions on the following link:
http://support.microsoft.com/kb/142479

- I have tried using BDE Admin on the PHP computer to edit the
IDAPI.Cfg and link through a mapped network drive to the paradox
machine - but cant as the PDXUSRS.NET file is in c:\ (cant share c:\
drive - therefore cant map). All this as per : several group
discussions I came accross. I thought about changing the location of
the .NET file on the paradox machine - but my admin wont let me.

Any suggestions?