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 variable view?

696


What is the difference between data reader and data adapter?

806


Explain how do you connect to sql server database without using sqlclient?

745


what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?

781


What is ado recordset?

714


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

834


What are the parameters that control most of connection pooling behaviours?

851


Why do we serialize data?

728


What is an orm, and why would you use one instead of plain old ado.net?

830


What property must be set and what method must be called in your code to bind the data from some data source to the Repeater control?

799


What are the advantages of oledb compared with other classes?

2595


What is the difference between sqlcommand and sqldataadapter?

762


Which is better ole db or odbc?

707


What are the steps you will take to improve performance? Will you use dataset or datareader?

775


What is executenonquery ado.net?

751