Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 08, 2012 06:42 AM by Frank Jiang - MSFT
Member
37 Points
367 Posts
Nov 05, 2012 10:20 AM|LINK
Hi all, Hope doing well, sir i am using oracle 11g there i created my db which is installed in other system. and one another system i have the web application. now i have to run the web application to use of that db which is installed in other system. i set the connection string in web.config like that:
<add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Grand1)));User ID=Amplex_Grand1;Password=passwd; Integrated Security=No;" providerName="System.Data.OracleClient"></add>
if i am using here in host=that ip address which has db installed it's not getting logged in.
but with this connection string it is working with the same system which has db installed. could you help me. thanks
Contributor
2350 Points
387 Posts
Nov 05, 2012 12:00 PM|LINK
Please check the URL for in depth description of connection string to oracle DB - http://docs.oracle.com/html/E10927_01/featConnecting.htm#i1006259. Although i assume that you must have searched it on the internet. In case it could help you.
All-Star
16006 Points
1728 Posts
Microsoft
Nov 08, 2012 06:42 AM|LINK
Maybe you need to install Oracle client:
http://stackoverflow.com/questions/7302684/connect-to-remote-oracle-database-from-asp-net
Connect to Oracle Database with no Oracle Client install
http://omegacoder.com/?p=445
vicky1
Member
37 Points
367 Posts
How to connect host server databse to run web application?
Nov 05, 2012 10:20 AM|LINK
Hi all,
Hope doing well,
sir i am using oracle 11g there i created my db which is installed in other system. and one another system i have the web application.
now i have to run the web application to use of that db which is installed in other system.
i set the connection string in web.config like that:
<add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=Grand1)));User ID=Amplex_Grand1;Password=passwd; Integrated Security=No;" providerName="System.Data.OracleClient"></add>
if i am using here in host=that ip address which has db installed it's not getting logged in.
but with this connection string it is working with the same system which has db installed.
could you help me.
thanks
Pankaj.Sharm...
Contributor
2350 Points
387 Posts
Re: How to connect host server databse to run web application?
Nov 05, 2012 12:00 PM|LINK
Please check the URL for in depth description of connection string to oracle DB - http://docs.oracle.com/html/E10927_01/featConnecting.htm#i1006259. Although i assume that you must have searched it on the internet. In case it could help you.
Frank Jiang ...
All-Star
16006 Points
1728 Posts
Microsoft
Re: How to connect host server databse to run web application?
Nov 08, 2012 06:42 AM|LINK
Maybe you need to install Oracle client:
http://stackoverflow.com/questions/7302684/connect-to-remote-oracle-database-from-asp-net
Connect to Oracle Database with no Oracle Client install
http://omegacoder.com/?p=445
Feedback to us
Develop and promote your apps in Windows Store