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

What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?

535


What is adodb dll?

520


What DataReader class do in ADO.NET ?

589


What is different between sqlcommand object and command behavior object?

544


What is csdl entity framework?

557






What is ole db query?

526


What are the namespaces used in ADO.Net to connect to a database?

601


What is isolation?

571


What are three methods for displaying data in a syncfusion datagrid

614


What is connection string?

529


What is the role of data provider in ado.net?

553


Explain the difference between data reader and data adapter?

509


Explain the namespaces in which .net has the data functionality class.

538


What are the different layers of ado.net?

520


Explain how to bind the controls(best practice) comboboxes to the data in the dataset?

560