what is the syntax code for oldb to connect oracle

Question Posted / vinod

3 Answers
6467 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the syntax code for oldb to connect oracle..

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

what is the syntax code for oldb to connect oracle..

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

what is the syntax code for oldb to connect oracle..

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

Post New Answer

More ADO.NET Interview Questions

FetCh Records No 5 to 10 From Dataset

4 Answers

What is ado recordset?

0 Answers

How to find the count of records in a dataset?

6 Answers

I want to ask u that if i add radio button in ado.net form,and how radion button data insert in SQL2005 Database...