what is the syntax code for oldb to connect oracle
- 3 Answers
- 5350 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
What is the role of the dataset object in ado.net?
How can we serialize the dataset object?
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 data view and variable view?
What are all the different methods under sqlcommand?
Which components of a data provider is used to retrieve, insert, delete, or modify data in a data source?
Explain what are acid properties?
Which method is used by command class to execute SQL statements that return single value?
What is Data Provider?
How does ado.net work?
Explain how to create dynamic gridview?
Why do we serialize data?
What is the difference between dataset and datatable?
Describe the disconnected architecture of ADO.NET’s data access model.
Is it possible to edit data in Repeater control?
