what is the syntax code for oldb to connect oracle
Answers were Sorted based on User's Feedback
Answer / srinivas.kinthada
i think oldb is not correct it's may b.
it is oledb
using system.data.oledb;
oledbconnection cn=new
oledbconnection("uid=<username>;pwd=<password>;server=<servername>");
cn.open();
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raghavendra.v
it is not oldb it may be oledb
using System.Data.Oledb;
Oledbconnection cn=new OleDbConnection
("Provider=Msdaora.1;uid=<username>;pwd=<pwd>;server=<server
name>");
cn.open();
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / sudha
first add the namespace
using system.Data.oledb;
OledbConnection cntn = new OledbConnection("Provider =
Microsoft.jet.oledb.12.0;datasource = (local);Integrated
security = SSPI,persistent Security = false");
provider = it depends on version of Microsoft Access like if
it is 2003 - 4.0 & if it is 2007 - 12.0
dataource - u can make it as local or provide the path to ur
database
Is This Answer Correct ? | 0 Yes | 0 No |
Which is better entity framework or ado.net?
What is difference between executenonquery and executequery?
What is meant by ‘transaction’ in a database and what are the ‘properties of transaction’?
What is row state?
How to Read, Add, Update and Delete record in Entity Framework ?
What is ado data control?
What is azure ado?
What is ado oledb and odbc?
What are the ado.net components?
What is meant by executenonquery?
What is the usage of the dataset object in ado.net?
What is the full form of ado.net?