plz tell me wht should be the data source in the following code

mycon=new oleDbconnection("provider=msadora.1;use id=scott;
data source=;
password=tiger;")
mycon.open();

Recommended Answers

All 2 Replies

plz tell me wht should be the data source in the following code

mycon=new oleDbconnection("provider=msadora.1;use id=scott;
data source=;
password=tiger;")
mycon.open();

try this. And do you use userid and password to get into Access?

dim mycon as new oleDbconnection("Provider= Microsoft.jet.oledb.4.0; datasource=the access database file where you have saved or the file name"; uid = scott; pwd= tiger;")

:)

plz tell me wht should be the data source in the following code

mycon=new oleDbconnection("provider=msadora.1;use id=scott;
data source=;
password=tiger;")
mycon.open();

the data source should be the host string of your oracle.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.