Re: Could not open Paradox.net

On Dec 29 2007, 8:01 am, Thorak <diving...@xxxxxxxxx> wrote:
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.

Now I know this isnt a PHP group, but most of these similar errors
seem to be posted in this section... so here goes:

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?

You should modify the NET DIR of your ODBC datasource. NET DIR of your
ODBC datasource should be pointed to the same location as the other
applications. ODBC datasource NET DIR settings is located in
HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\Your DSN\Engines\Paradox
\ParadoxNetPath.
.

Relevant Pages

  • Re: Could not open Paradox.net
    ... One machine has the paradox database on it (used by another program as ... Another computer has PHP and Apache on it. ... I setup a test to see if this problem was PHP based or Network ...
    (comp.databases.paradox)
  • Could not open Paradox.net
    ... I have spent the past 2 days researching this and cant seem to get ... One machine has the paradox database on it (used by another program as ... Another computer has PHP and Apache on it. ...
    (php.general)
  • Re: Could not open Paradox.net
    ... System setup is: ... One machine has the paradox database on it (used by another program as ... Another computer has PHP and Apache on it. ...
    (comp.databases.paradox)
  • Could not open Paradox.net
    ... I have spent the past 2 days researching this and cant seem to get ... One machine has the paradox database on it (used by another program as ... Another computer has PHP and Apache on it. ...
    (comp.databases.paradox)
  • Re: Preferred Application Server
    ... >> I am a little confused when you bring Apache into the picture. ... How does your Paradox app interact ... > touching the same tablespace on a file server. ... > for the drawing & pops it up in the user's browser. ...
    (comp.databases.oracle.server)