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 is dataset object? Explain the various objects in dataset.
What is the use of SqlCommandBuilder?
Why do we use sqldataadapter?
What is the difference between an ADO.NET Dataset and an ADO Recordset?
What are the different namespaces used in the project to connect the database? What data providers available in .net to connect to database?
What is sql command in ado net?
What is difference between ado.net and asp net?
What are the connected and disconnected modes in ado.net?
Why sql Data Reader object not created
What are the essential features of ado.net?
What is ado full form?
How would u connect to database using .NET?