Work with Microsoft OLE DB .NET Data Provider
This article deals with connection strings related to Microsoft OLE DB .NET Data Provider.
Standard for Microsoft OLE DB .NET Data Provider
The string given below is a standard string for
Microsoft OLE DB .NET Data Provider. To implement it in your program use the
following string.
|
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
Id=Username;Password=user_Password;OLEDB.NET=True;
|
OraOLEDB Properties
When OraOLEDB is used by OLE DB .NET Data
Provider. then only two kinds of properties can be used. They are SPPrmsLOB and
NDatatype properties.
Provider=OraOLEDB.Oracle;Data
Source=OracleDB;User Id=Username;Password=user_Password;OLEDB.NET=True;
SPPrmsLOB=False;NDatatype=False;SPPrmsLOB=False;
|
Distributed Transactions
The command given below will give the
information about the transactions that are distributed.
|
Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User
Id=myUsername;Password=myPassword;DistribTX=1;
|
NOTE: 0 value means disabled and 1 value
means enabled.
Further
Readings
You may also want to read these related articles.
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here