Previous Thread:   Managing 2 Databases vs Splitting Database

10/22/2005 1:00:49 AM    Wanted: Documentation on ODBC Connection Strings
Short version of question: Where is the ODBC counterpart to  
  
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adoproperties.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/adoproperties.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

7250599242


10/22/2005 1:18:58 PM    Re: Wanted: Documentation on ODBC Connection Strings
I found this:  
  
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataodbcodbcconnectionclassconnectionstringtopic.asp  
  
It gives the BNF of the connection strings and then says "  
  
The connection string may include any number of driver-defined keywords.  
  
Because the DRIVER keyword does not use information from the system, the  
  
driver must define enough keywords so that a driver can connect to a data  
  
source using only the information in the connection string. The driver  
  
defines which keywords are required to connect to the data source."  
  
Where are the keywords for JET documented?  
  
Siegfried


Search

search