Very Computer

I have install DataDirect odbc driver to access Paradox files from our own
applications and from Excel.

I'm currently using an accounting package written in Delphi 5 which is using
Paradox files and the BDE. The netdirectory for this app has been set to a
specific directory ( O:\MYACCOUNTING\NET\ to make things clear). When I run
this app, the pdoxusrs.net file is created in this directory.

When I run my own app or a query in Excel, this file is also created in the
same directory. So we are sure that we are using the same file. I can use
both apps with the same pdoxusrs.net file but not both at the same time.

My accounting is open. I run a query in Excel and get the following message
:Driver's SQLAllocHandleon SQL_HANDLE_ENV failes.

This is exactly the same error message when I try to acces the accounting
files from my app.

Any suggestion (maybe something else than using this odbc driver) ?

TIA

If two users store their temporary files to the same directory,
this causes errors and conflicts.

With BDE you can set the user's Private Directory in Delphi code.
But I'm not sure how the Private directory problem is handled
when you access Paradox tables via ODBC.

Maybe you could start your Excel ODBC query, and check to which
directory those temporary files appear.
And then in your Delphi app set the second user's Private
directory to somewhere else.

This is all my quessing only. I have never worked with Paradox
tables via ODBC.

Quote:>> Maybe you could start your Excel ODBC query, and check to which directory

With one simple program, I have traced the problem and it seems that as soon
as the connection is established, the odbc driver places a kind of lock on
the pdoxusrs.net that prevents anyone else to use it.
When I leave my program, the odbc driver "frees" the pdoxusrs.net and let
others use it.

If the accounting is running, my simple program can't place this "lock" on
the pdoxusrs.net and the driver returns an error.

It's my explanation but I'm not sure about it. I also made the same test
with another odbc driver (from intersolv) with exactly the same result.

Quote:> Hello,

> I have install DataDirect odbc driver to access Paradox files from our own
> applications and from Excel.

> I'm currently using an accounting package written in Delphi 5 which is
using
> Paradox files and the BDE. The netdirectory for this app has been set to a
> specific directory ( O:\MYACCOUNTING\NET\ to make things clear). When I
run
> this app, the pdoxusrs.net file is created in this directory.

I do not know how you set the NetFileDir setting for Paradox ODBC, or
even if it is necessary to set there.

Quote:> For some reason mapped drive letters don't seem to work
> consistently with Paradox in these environments.

Quote:>> I would suspect a problem with either the Net file directory path or the

I got another suggestion from someone else. He suggested to move move the
idapi32.dll file to the windows\systems folder but this doesn't work
neither.

Quote:>> I do not know how you set the NetFileDir setting for Paradox ODBC, or<<

LOCAL oConn AS AdoConnection
..
  oConn := AdoConnection{}
  oConn:ConnectionTimeout := 5
..
  oConn:Mode    :=adModeShareDenyNone
  oConn:CursorLocation :=adUseServer
  oConn:Open("DSN=BobDataDirect; ND=O:\MYACCOUNTING\NET\ ;", NIL, NIL, NIL)

Quote:

> I do not know how you set the NetFileDir setting for Paradox ODBC, or
> even if it is necessary to set there.

> > For some reason mapped drive letters don't seem to work
> > consistently with Paradox in these environments.

> I still have some 16-bit BDE apps running out there. And customers
> have installed them also on W2k and XP machines. The 16-bit BDE does
> not understand anything about UNC paths, so the only alternative
> is to use mapped drives.
> This mapping seems to work all right on W2k and XP too, already for
> several years.