Click here to Skip to main content
15,041,548 members
Please Sign up or sign in to vote.
4.67/5 (2 votes)
See more:
I am trying to connect to a database on Oracle 11g Expres Edition. The following connect string is not working:
<br />
<add name="NCMS_ORACLE_CONNECTIONSTRING" connectionString="Data Source=127.0.0.1;Database=MYDB1;User Id=USER1;Password=PWD1;" providerName="System.Data.OracleClient"/><br />

All the above parameters are correct and I can use them to login from the web interface.

I was using the same setup earlier with Oracle 10g XE, but with 11g XE there is a new setup like WORKSPACE. So, I created my database workspace called MYDB1 and created all the tables in that.

Please help...
Srinivas
Posted

   
Comments
Om Prakash Pant 19-Dec-11 7:13am
   
didn't saw your post !!
Defining simply IP address isn't enough for Oracle. You have to define a name that is defined in your TNSNAMES.ORA description file. Typically in XE installatoins this is simply XE
   
Have you tried www.connectionstrings.com[^]?
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900