Last post Oct 17, 2012 01:33 PM by SpclFrcs
Oct 17, 2012 10:38 AM|SpclFrcs|LINK
I am using Visual Studio 2008 for my website, the back end was sql server, but now it is going on an oracle server of which I have no access too. Someone else is doing the move. I was told the installation failed because the connectionstrings were not correct
and I have to rewrite the connectionstrings in the webconfig file to connect to the oracle db. I have the username, password, and database name for the oracle server. I have no other information for the oracle server. And I have no experience with Oracle
what so ever. Any help would be greatly appreciated.
Can I just rewrite the connection strings in the web config file? Is that enough to fix this? If so what do I write and where in the web config file do I put it?
Oct 17, 2012 10:39 AM|b471code3|LINK
Find your answers here: http://connectionstrings.com/
Oct 17, 2012 01:33 PM|SpclFrcs|LINK
B471code3: Thanks for the link. I found and am using this:
Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;Integrated Security=no;
So in my webconfig file do I just replace this:
<add name”xxxxxxxconnectionstring” connectionstring=”data source=sql server;Initial Catalog=xxxx;Integrated security=true” providername=”System.data.sqlclient”/>
<add name=”xxxxxConnectionString” connectionString=”Data Source=xxxx;User ID=xxxx;Password=xxxx;Integrated Security=no;”/>
Do I do that for all of the connectionstrings in the webconfig file? I have fourteen of them.