Where is documentation on connection strings?

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"};

http://www.connectionstrings.com/

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

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Siegfried Heintze" wrote in message
...
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"};

Siegfried Heintze wrote:
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/de...roperties.asp]

http://msdn.microsoft.com/library/de...properties.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

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=adm in;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.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Siegfried Heintze" wrote in message
...



http://msdn.microsoft.com/library/de...properties.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