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
What is the difference between the clone() and copy() methods of the dataset class?
What are advantages of microsoft-provided data provider classes in ado.net?
What are the steps you will take to improve performance? Will you use dataset or datareader?
What are the different methods by which we can populate a dataset?
Which one of the objects is a high-level abstraction of the connection and command objects in ado.net?
What is data view and variable view?
What is dataset and datatable in ado.net?
How do you merge 2 datasets into the third dataset in a simple manner?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is the difference between executequery and executenonquery?
What are the features of ado.net?
What are the usages of the command object in ado.net?
What is the use of ADO.NET and XML web services?
What is ado.net objects?
What is ambient transaction?