R
Rahul
I use .NET 2.0 OLEDB provider to connect to a connection string. The MSDN
library does not enumerate & explain various connection parameters that can
be set.
I copied the following code from one of the connection string:
"Jet OLEDB:Global Partial Bulk Ops=2;" & _
"Jet OLEDBatabase Locking Mode=1;" & _
"Jet OLEDB:SFP=False;persist security info=False;" & _
"Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;" & _
"Jet OLEDB:Create System Database=False;" & _
"Jet OLEDBon't Copy Locale on Compact=False;" & _
"Jet OLEDB:Compact Without Replica Repair=False;" & _
"Jet OLEDB:Global Bulk Transactions=1;"
Can anyone explain this string? I am not asking about the parameters, like
what is Locking Mode. What I am asking is whether Locking Mode=1 locks the DB
with Pessimistic or Optimistic Locking protocal?
Moreover, I need to tweak my application performance. So, can somebody point
me to a resource that enumerates & explain all parameters that cna be set in
this string???
library does not enumerate & explain various connection parameters that can
be set.
I copied the following code from one of the connection string:
"Jet OLEDB:Global Partial Bulk Ops=2;" & _
"Jet OLEDBatabase Locking Mode=1;" & _
"Jet OLEDB:SFP=False;persist security info=False;" & _
"Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;" & _
"Jet OLEDB:Create System Database=False;" & _
"Jet OLEDBon't Copy Locale on Compact=False;" & _
"Jet OLEDB:Compact Without Replica Repair=False;" & _
"Jet OLEDB:Global Bulk Transactions=1;"
Can anyone explain this string? I am not asking about the parameters, like
what is Locking Mode. What I am asking is whether Locking Mode=1 locks the DB
with Pessimistic or Optimistic Locking protocal?
Moreover, I need to tweak my application performance. So, can somebody point
me to a resource that enumerates & explain all parameters that cna be set in
this string???