what is the syntax code to oledb to connect oracle
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
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 |
What are the major difference between classic ADO and ADO.NET?
How can we save all data from dataset?
Which is faster ado.net or linq?
What is data reader in ado.net?
What are the various methods provided by the DataSet object to generate XML?
How to identify the updated rows in a dataset?
What is the return type of executescalar?
Difference between DataReader and DataAdapter / DataSet and DataAdapter?
What DataReader class do in ADO.NET ?
Explain what are the steps to connect to a database?
What is the difference between typed and untyped dataset?
What is the default timeout specified for "sqlcommand.commandtimeout" property?