Work with Microsoft OLE DB .NET Data Provider

This article deals with connection strings related to Microsoft OLE DB .NET Data Provider.
  • 2216

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.