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 datatable in ado.net?

512


can we create synonymn in ms access,sql server,my sql if so explain me with example

1568


Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?

612


How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?

512


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

566






how Sequence to connect and retrieve data from database using dataset?

744


How would you connect to database using .NET?

563


How to add a check box or a dropdown list to a column in a datagrid?

531


What is untyped dataset?

536


What is the difference in record set and dataset?

515


What is row state?

518


What are the advantages and drawbacks of using ado.net?

607


What is an example of ordinal data?

483


What does ole stand for in excel?

594


What are the difference between readonly vs. Const?

495