Where is documentation on connection strings?

  • Thread starter Thread starter Siegfried Heintze
  • Start date Start date
S

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 OLEDB:Database 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 OLEDB:Database Locking Mode=1;Jet OLEDB:Database
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
OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica
Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False"};
 
Siegfried said:
See the Jet OLEDB:Database Locking Mode=1? What the heck does this mean? Can
someone point me to the documentation (URL) where it describes this?
Click to expand...
From MSDN:
Click to expand...

OLEDB:Database Locking Mode

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

The Jet OLEDB:Database 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]
 
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.
 
Back
Top