Error in connection to database

[venky]

hi friends

here i am facing a different problem i.e


1. cs = "provider=MSDAORA.1;password=tiger;User ID=scott;Data Source="
2. cs = "Provider=OraOLEDB.Oracle;Password=tiger;Persist Security Info=True;User ID=scott;Data Source="

In the above two strings first one is not working , but second one is working very fine in my System.In other systems both working fine.

What is the reson for not accessing the Microsoft connection in my PC.Please help me any one regarding this.

 

[fpineda101]

Missing the Oracle Instance name

 

[cjard]

Make a file on your desktop called a.udl
Double click it
Fill in all the necessary parameters to connect your oracle
Test the connection
Open the UDL file in notepad
There is your connection string perfectly ready to conenct

 

[vineet]

Hi
Iam facing similar problem, my connection is getting
established but when Im opening it, it is throwing an
oracle.dataaccess.client.oracleexception

lstrConnectString = "User Id=" & gstrDBUserName & ";Password=" & gstrDBPassword & ";Data Source=" & gstrDBName & ""
gconCentralDB.Open() throwing error at this point

 

[cjard]

read my advice above