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?

Thorak wrote:

"PARADOX.NET" or "PDOXUSRS.NET" is a network-control file that is part of
the locking system. First, be sure that the location of this file is
properly identified for whatever driver you may be using. Then, make sure
that the web-server has read/write/create/delete access rights both to the
file and to the directory in which it lives.



----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com

On Dec 28, 6:02 pm, Sundial Services <i... (AT) sundialservices (DOT) com> wrote:
Thanks for the reply. I already knew this information... and did
mention in my original post that I tried some of these things. I guess
I dont know how to get the web server to talk to the Paradox computers
paradox.net OR pdoxusrs.net because they are located at c:\paradox.net
and c:\pdoxusrs.net. And I am unsure how to "share" a file in the root
of c:\

if you have both of those folders and both of those paths working right now,
something is VERY wrong.. paradox.net was the file for paradox dos 3.5 and
prior.. pdoxusrs.net is for paradox dos 4.x and paradox win.. you can't have
both.. and this impacts the ODBC driver and version control, too..

you NEVER want to deal with the root of a drive, especially C drive.. in
win2000, xp, and vista, you have "rights" issues, besides all the things
we've been harping on forever..

--
Steven Green - Myrtle Beach, South Carolina USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards
"Thorak" <diving.bc (AT) gmail (DOT) com> wrote

Thorak wrote:
Generally speaking, "after all these years Windows is finally recognizing
and using its own security features." :-) Things no longer get run "as an
Administrator" just because it's more-convenient.

So, basically, you need to be certain that all of the software components
you are using know where to put the network control files, and that they
have read/write/create/delete access to that location. Web-servers
typically run as very-restricted user accounts for obvious reasons.

----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com