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

  • 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

    Thursday, September 24, 2015 7:54 AM

All replies

  • User-166373564 posted


    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,


    Sunday, October 4, 2015 10:16 PM
  • 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.

    Thursday, October 15, 2015 5:21 AM
  • User702049738 posted

    Please see this message below


    Wednesday, October 21, 2015 6:49 AM