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 |
In how many ways we can retrieve table records count? How to find the count of records in a dataset?
What is the default view of Data Grid?
What are the different methods available under the sqlcommand class to access the data?
What is serialization and de-serialization in .net? How can we serialize the dataset object?
what is the syntax code for oldb to connect oracle?
What is ODP.NET?
What is connection pooling and what is the maximum pool size in ado.net connection string?
Explain the ADO . Net Architecture ?
Difference between sqlcommand and sqlcommandbuilder?
Explain ado.net features? Benefits? Drawbacks?
How you will set the datarelation between two columns?
What is ado code?