what is the syntax code for oldb to connect oracle
Answer Posted / 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 |
Post New Answer View All Answers
What is ado code?
Does entity framework use ado.net?
What does ole stand for in excel?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
Which namespaces are used for data access?
What is ado.net in vb net?
What is difference between datareader and dataadapter?
Explain the difference in record set and dataset?
What is Dataset Object?
What are two important objects of ADO.Net?
What is csdl entity framework?
What is difference between executenonquery and executequery?
What are the parameters that control most of connection pooling behaviors?
How can we load multiple tables in a dataset?
Can we connect two dataadapters to same data source using single connection at same time?