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 row state?

716


How do you connect to sql server database without using sqlclient?

789


Define the data provider classes that is supported by ado.net?

753


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

895


List the 4 common ado.net namespaces?

881


What are the steps you will take to improve performance?

669


Explain why canot we use multiple inheritance and garbage collector paralelly in .net?

802


What does executequery return?

714


How to check if the Dataset has records ?

743


Explain which name space is used to get assembly details?

722


What are the different ado.net namespaces are available in .net?

761


Can you explain how to enable and disable connection pooling?

738


Explain the dataadapter class in ado.net?

883


What is bubbled event?

733


What are basic methods of dataadapter?

720