Click here to Skip to main content
15,937,198 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

 
Share this answer
 
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
 
Share this answer
 
Have you tried www.connectionstrings.com[^]?
 
Share this answer
 

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