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