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 |
Which is faster entity framework or ado.net?
What is the current version of entity framework?
Write steps of retrieving data using ado.net ?
ADO and ADO.NET differences?
What are the namespaces used in ADO.Net to connect to a database?
How can I retrieve two tables of data at a time by using data reader?
describe about the ado.net object model
Is ADO.NET derived from COM? true /false
how to display empty table to datagrid
What are the steps you will take to improve performance? Will you use dataset or datareader?
What Is Difference Between Ado And Ado.net?
What is sql connection in ado.net?