what is the syntax code to oledb to connect oracle

Answer Posted / kakani kumar

Using System.Data.Oledb;

OledbConnection cnn = new Oledbconnection("Prvider=MsDaOra,
User ID=scott, Password=Tiger, Datasource=m10 );
Datasource is optinal

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is defaultview in datatable?

528


How to load multiple tables into a dataset?

534


Give an example of a .net application which connects to microsoft access database using ado.net classes.

579


Is it possible to load multiple tables in a Dataset?

519


oledbdataadpter with ms access in c#.net giving exception System.Data.OleDb.OleDbException while writing adapter.update(dataset,"tabname"); how to update the database from dataset?

1920






What is commandbuilder in ado.net?

520


How can we perform transactions in .net?

534


If a table contains 20000 records. In a page at each time 100 records to be displayed.

509


What provider ado.net use by default? Explain the role of data provider in ado.net? What is the role of data provider in ado.net?

531


What is openrowset?

490


Give an example that shows how to execute a stored procedure in ado.net?

559


Define Execute Reader?

584


Which method is used by command class to execute SQL statements that return single value?

549


Define different execute methods of ADO.NET command object ?

544


What is row state?

518