Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


what is the syntax code to oledb to connect oracle

Answers were Sorted based on User's Feedback



what is the syntax code to oledb to connect oracle..

Answer / govind.konduri

using system.data.oledb;

oledbconnection oracon=new oledbconnection
( " provider=msdaora;
User Id=scott;
Password=Tiger");

Is This Answer Correct ?    2 Yes 0 No

what is the syntax code to oledb to connect oracle..

Answer / kakani kumar

Using System.Data.Oledb;

OledbConnection cnn = new Oledbconnection("Prvider=MsDaOra,
User ID=scott, Password=Tiger, Datasource=m10 );
Datasource is optinal

Is This Answer Correct ?    1 Yes 0 No

what is the syntax code to oledb to connect oracle..

Answer / srinivas

using system.data.oledb;
oledbconnection cn=new
oledbconnection("uid=<user_name>;pwd=<pwd>;server=<servername>");
cn.open();

here u declare <user_name> is u give username
pwd is u give password
<server> or data source is u give

Is This Answer Correct ?    0 Yes 0 No

what is the syntax code to oledb to connect oracle..

Answer / 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

what is the syntax code to oledb to connect oracle..

Answer / 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

what is the syntax code to oledb to connect oracle..

Answer / siddhartha sharma

using System.data.oledb;
oledbdataadapter da;
dataset ds;
da=new data Adapter("select * from
Databasename","connection string");
ds=new dataset();
da.fill(ds);// fetch the database to frontend
//// we use that syntex to fetch oracle database to our
application

Is This Answer Correct ?    0 Yes 1 No

Post New Answer



More ADO.NET Interview Questions

What is dataset and tell about its features. What are equivalent methods of previous, next etc. Of ADO in ADO.NET ?

1 Answers   Digital GlobalSoft,


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?

0 Answers  


What is the use of connection object in ado.net?

0 Answers   TryTechnicals Pvt Ltd,


How does entity framework work?

0 Answers  


Describe the command object and its method.

0 Answers  






What is the default view of Data Grid?

5 Answers   TCS,


We all know that Dataset is purely disconnected architechure, but we also know that we can update the changes made to the dataset can be updated in the backend database. when there is no connection how does the update happedn?

6 Answers   Accenture, FastStream,


Describe connection object in ado.net

0 Answers  


What is the significance of CommandBehavior.CloseConnection ?

0 Answers   NA,


What is ado circle?

0 Answers  


Is it possible to edit data in Repeater control?

0 Answers  


What is the purpose of using adodb?

0 Answers  






Categories