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 variable view?
What is the difference between data reader and data adapter?
Explain how do you connect to sql server database without using sqlclient?
what is the difference betwen typed dataset and untyped dataset?in general which dataset can we use in programming?
What is ado recordset?
How to bind the controls(best practice) comboboxes to the data in the dataset?
What are the parameters that control most of connection pooling behaviours?
Why do we serialize data?
What is an orm, and why would you use one instead of plain old ado.net?
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?
What are the advantages of oledb compared with other classes?
What is the difference between sqlcommand and sqldataadapter?
Which is better ole db or odbc?
What are the steps you will take to improve performance? Will you use dataset or datareader?
What is executenonquery ado.net?