Posted on: 4/24/2013 4:17:10 PM | Views : 650

So I have a Asp.net Application that runs on a windows server 2008 R2 that I didn't set up. The website itself I designed but I'm not good with networking and driver setups. What I'm trying to do is set the website up on another windows server 2008 (production server). So when I took the files from the working site over to the production server, it can't find the database. Now my DSN connections are set up for both the 32 and 64 bit versions but the only time I can get the site to connect is when I change the web config file strings from:
<add name="OracleConnection" connectionString="Dsn=test_Dsn;uid=XXXX;pwd=XXXX" providerName="System.Data.Odbc"/> To
<add name="OracleConnection" connectionString="Data Source=OT2T;uid=XXXX;pwd=XXXX" providerName="System.Data.OracleClient"/> Then it will connected only the code in my aspx files, example:

 Go to the complete details ...