Re: Could not open Paradox.net

On Dec 29 2007, 8:01 am, Thorak <diving...@[EMAIL PROTECTED]
> 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://sup****t.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.