what is the syntax code to oledb to connect oracle

Answer Posted / sinthu vijay kumar

hi friends...

we have so many databases for ex oracle,sql
server,sybase,ms Access etc.providers are used to giving
the connecion to the database ,which r different for
different databases.the avilable providers in ado.net are
oracle.net data provider,odbc.net dataprovider etc.
the syntax for provider is:
con=new odbcconnection
("uid=scott,pwd=tiger,database=oracle")
here uid,pwd,database r vary with different databases.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to store data in memory?

508


Which one of the following objects is a high-level abstraction of the connection and command objects in ado.net?

585


What are the benefits of using of ADO.NET in .NET 4.0?

539


What is ole access?

550


I loaded the dataset with a table of 10 records. One of the records is deleted from the backend, how do you check whether all the 10 records were present while updating the data(which event and steps) and throw the exception 28 can datareader hold data from multiple tables?

554






What is the difference between DataReader and DataSet in ADO.NET?

591


How can we check that some changes have been made to dataset since it was loaded?

518


Define isolation?

537


Why is ADO.NET serialization slower than ADO ?

569


Which is better ole db or odbc?

497


What is ambient transaction?

508


Describe the disconnected architecture of ADO.NET’s data access model.

543


What is ado or jdbc?

516


What is a serialized object?

538


What is data control techniques?

510