how to deploy asp.net with oracle on 64bit server

Question

User-174653821 posted

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

Answer 1

User-166373564 posted

Hi,

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,

1. Open the Web.config file in the root directory of your ASP.NET application. If you do not have a Web.config file, create one.

2. In the Configuration element, add a ConnectionStrings element if one does not already exist.

3. Create an add element as a child of the ConnectionStrings element, defining the following attributes:

<add name="OracleConnectionString"
  connectionString="Data Source=OracleServer1;Persist 
    Security Info=True;Password="******";User ID=User1"
  providerName="System.Data.OracleClient" />

4. Save the Web.config file.

Please let me know if you need any help.

With regards,

Angie

Answer 2

User-174653821 posted

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.

Answer 3

User702049738 posted

Please see this message below

http://stackoverflow.com/questions/15293975/could-not-load-file-or-assembly-oracle-dataaccess-error