Where is documentation on connection strings?

[Siegfried Heintze]

This connection string I copied from "ASP.NET and ADO.NET" by Esposito is
very interesting (see below). It works when my perl programs are not trying
to use ODBC to simultaneously access my database. It does not work when they
are using "SELECT", "UPDATE", "INSERT".

See the Jet OLEDBatabase Locking Mode=1? What the heck does this mean? Can
someone point me to the documentation (URL) where it describes this? I tried
setting the locking mode to zero but this did not help.

Thanks,
Siegfried



string[] strConn = new string[]{@"Jet OLEDB:Global Partial Bulk Ops=2;Jet
OLEDB:Registry Path=;Jet OLEDBatabase Locking Mode=1;Jet OLEDBatabase
Password=;Data Source=""C:\Inetpub\heintze\keyword-job-search\",
@"job-search.mdb", @""";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global
Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System
database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet
OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet
OLEDBon't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False"};

 

[Sylvain Lafontaine]

http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=81

 

[peregenem]

See the Jet OLEDBatabase Locking Mode=1? What the heck does this mean? Can
someone point me to the documentation (URL) where it describes this?

From MSDN:

OLEDBatabase Locking Mode

A Long value (read/write) that specifies the mode used when locking the
database to read or modify records.

The Jet OLEDBatabase Locking Mode property can be set to any of the
following values:

Page-level Locking 0
Row-level Locking 1

Note: A database can only be open in one mode at a time. The first user
to open the database determines the locking mode to be used while the
database is open.

[ADO Provider Properties and Settings
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adoproperties.asp]

 

[Siegfried Heintze]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/adoproperties.asp
contains documentation on" mode=share deny none". I can find no mention of
such a similar clause in

http://www.connectionstrings.com/

http://www.carlprothman.net/Default.aspx?tabid=81

Does ODBC allow such clauses like ODBC does? If so, where?

Thanks,
Siegfried

 

[Sylvain Lafontaine]

Sorry, but ODBC is getting really old by now and finding documentation on
things like « mode = share deny none » is difficult today; even with Google.

The http://www.connectionstrings.com/ site make a mention of the Exclusive
mode:

"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\mydatabase.mdb;Exclusive=1;Uid=admin;Pwd="

However, there is no indication of the possible values for this parameter.
I think that you will have to dig up old information about the Microsoft
Access ODBC driver.