Short version of question: Where is the ODBC counterpart to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/ad
oproperties.asp? I
want to specify "mode=share deny none" in my ODBC connection string but I
don't know the syntax.
Long version of question: see below.
Thanks,
Siegfried

Long version of question:

I was having a related conversation in Table Design and was thinking this
forum might be slighly more appropriate.

I'm trying to debug a problem that only occurs when multiple perl ODBC
clients are simultaneously INSERTing and SELECTing and UPDATEing while my
ASP.NET/C# client is SELECTing. The multiple perl ODBC clients never seem to
have any problem.

The ASP.NET/C# always comes back with an error message like "could not lock
file" (if I am using OleDB) or "ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver]General error Unable to open registry key 'Temporary
(volatile) Jet DSN for process 0x17e8 Thread 0x1684 DBC 0x1588014 Jet'.
ERROR [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr
failed ERROR [HY000] [Microsoft][ODBC Microsoft Access Driver]General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x17e8
Thread 0x1684 DBC 0x1588014 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft
Access Driver] Could not use '(unknown)'; file already in use. ERROR [HY000]
[Microsoft][ODBC Microsoft Access Driver]General error Unable to open
registry key 'Temporary (volatile) Jet DSN for process 0x17e8 Thread 0x1684
DBC 0x1588014 Jet'. ERROR [HY000] [Microsoft][ODBC Microsoft Access
Driver]General error Unable to open registry key 'Temporary (volatile) Jet
DSN for process 0x17e8 Thread 0x1684 DBC 0x1588014 Jet'. ERROR [HY000]
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file
already in use."

if I am using ODBC.

When I rewrite my ASP.NET/C# in perl/ODBC, there is no problem (except for
the fact that Perl CGI does not support datagrids). The perl rewrite
correctly displays the data with no error messages!

Some folks have suggested the problem is with perl not releasing records.
It seems to me, however, if perl/ODBC can SELECT then why cannot ASP.NET/C#
SELECT? Furthermore, I have looked at the perl documentation and since I am
not using transactions, there is nothing to release.

I notice in my OleDb connection string, as documented at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/ad
oproperties.asp
there is phrase that says:

Mode=Share Deny None

How do I tell ODBC that I want to share and deny none? Maybe I need to tell
Perl/ODBC to "share deny none" but I don't know how to do that in ODBC. Can
someone point me to the documenation on ODBC connection strings where these
properties are defined?

Thanks,
Siegfried