simultaneous connections with ODBC

Anon

I've a got a script that gets a lot of its data from a Paradox database using PHP's unified ODBC functions. It works great until more than one user tries to run it at once. This is the result:

Warning: SQL error: [Microsoft][ODBC Paradox Driver] The Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to
view its data., SQL state S1000 in SQLExecDirect

How can I allow multiple users to view this page simultaneously? I've looked for settings in the odbc drivers and IIS to no avail.

The server's running:
PHP 4
Windows 2000, service pack 1
IIS 5

Thanks in advance.

ame12

I don't think IIS and ODBC have anything to do with this. Looks like Paradox is reporting it wants exclusive access to the database. Suggest checking with Paradox support because PHP and IIS don't look like they have anything to do with this. Does Paradox even support multiple opens? I don't know much about it.

===========================================
http://badblue.com
Small footprint P2P web server for Windows,

Share files, get PHP up and running fast...

Anon

We have ASPs on the same system that perform similar tasks without a hitch. Are those scripts all establishing separte connections to Paradox? Is there some way I can get PHP to do the same thing ASP is doing?

gzimmer

Never used PHP with paradox, but I have used Delphi with paradox, and paradox is very particular about its setup. the path to the .net and .lck files have to be set up right or you will have a lot of problems when you try to go multiuser.