what is the syntax code for oldb to connect oracle
- 3 Answers
- 5668 Views
- IBM, I also Faced
- E-Mail Answers
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
Explain the difference between ado and ado.net?
What is executenonquery ado.net?
What is the provider being used to access oracle database?
What are the different row versions available in table?
What is the usage of the dataset object in ado.net?
How do you update a dataset in ado.net and how do you update database through dataset?
What is adodb dll?
What is Dataset Object?
What are the classes in System.Data.Common Namespace?
Is datareader faster than datatable?
What is full form of ado?
Explain executenonquery?
How to pass values into a datatable?
What is the significance of CommandBehavior.CloseConnection ?
What is ado net stands for?
