Last post Oct 21, 2015 06:49 AM by olybobo
Sep 24, 2015 07:54 AM|vaibh|LINK
i have web application which is running well on my 32 bit machine but when i am trying to deploy it on 64 bit server it is giving a big headache from last 2 days.
scenario is i am having 64 bit server with 64 bit oracle 10g server and i have configure web application in IIS.
in IIS i have unable 32 bit true in app pool,
now it is giving error of OraOracle.oracle is not register on local machine
if i change provider then error shows oracle 7.3 or more need to install ..
suggest be best practice to deal with Oracle 64 bit and Asp.net web application
Oct 04, 2015 10:16 PM|Angie xu - MSFT|LINK
From your description above, here are some suggestions:
1. Set Enable 32-Bit Applications to False, load 64 bit DLL into a 64 bit process.
2. To configure a connection string for Oracle in the Web.config file,
In the Configuration element, add a
ConnectionStrings element if one does not already exist.
Create an add element as a child of the ConnectionStrings element, defining the following attributes:
Security Info=True;Password="******";User ID=User1"
4. Save the Web.config file.
Please let me know if you need any help.
Oct 15, 2015 05:21 AM|vaibh|LINK
Hey hi thanks for the reply..
I did as you said one more thing is missing in your solution i was using oledb connection but your solution is not suppose for that thats why i change it in system.data.oracleClient.
now it is giving following error while opening connection
if i run application through IIS then error is
ORA-12154: TNS:could not resolve the connect identifier specified
if i run through Visual studio then error shows
Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.
Oct 21, 2015 06:49 AM|olybobo|LINK
Please see this message below