Last post Sep 19, 2013 04:11 AM by kctt
Sep 17, 2013 10:52 PM|aditya1986|LINK
I have two websites in one server. One site runs with MSSQL and another one with oracle. While running in local machine I install Oracle and use TNS.ora in oracle admin folder to run the site.
Means now i have to install oracle express in server to run the site? ( oracle runs on another server but not on host server).
Sep 18, 2013 04:27 AM|smirnov|LINK
The database server does not need to be installed on the same box where web server is. If your database will be located on another server then you simply need to change connection string (typically in the web.config file) from localhost to that server. If
you have no other server, then you would need to install oracle on the same server.
Sep 18, 2013 11:43 PM|necro_mancer|LINK
What is important here is that you must allow DB Remote Connection to your Oracle database. By doing so, you can simply put your site on any server in this world and you can simply change the connection string on your site and point it to your Oracle database
Please mark this response as an "answer" if it helps you. Thanks heaps!
Sep 19, 2013 04:11 AM|kctt|LINK
You will need to install Oracle data access components on web server for asp.net to connect to Oracle database on remote database server.