IIS 7 and Above
Last post Jul 18, 2018 09:00 AM by deepakpanchal10
Jul 11, 2018 08:18 PM|tippet|LINK
I need help in understanding the compatibility with .NET assemblies and oracle version.dll, and how to verify what is installed on windows 2012r2 iis.
the site is 32bit enabled.= true
C:\Windows\Microsoft.NET\assembly\GAC_64 = NO Oracle.DataAccess
C:\Oracle\ora12c-32 = installed
Could not load file or assembly 'Oracle.DataAccess, Version=220.127.116.11, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The system cannot find the file specified.
Jul 12, 2018 02:26 AM|deepakpanchal10|LINK
Did you install the same version of Oracle on your IIS server where you host your application?
You need to install the same version of Oracle which you had used to develop your application and which is working on your development machine.
You need to make sure that same version is also mentioned in your Web.config file.
To know, Which version of Oracle is installed on your machine. You can use the script mentioned in article below.
Check If Oracle is Installed. If YES, What Version of Oracle Database Installed
Jul 12, 2018 12:45 PM|tippet|LINK
looking at the vbs it only checks up to v11g of oracle i have 12c
the script right now states I dont have oracle installed.
the web.config has this :
<assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89B483F429C47342" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-10.2.0.100" newVersion="18.104.22.168"/>
<assemblyIdentity name="AjaxMin" publicKeyToken="21ef50ce11b5d80f" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-5.14.5506.26196" newVersion="5.14.5506.26196" />
<assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-22.214.171.124" newVersion="126.96.36.199" />
Jul 18, 2018 09:00 AM|deepakpanchal10|LINK
Here below are some alternative approaches that you may try to use.
Run following query in SQL Developer or SQLPLUS in command prompt to find out the version number.
select * from v$version;
Which can give you output like below.
Notice that you can get the version which you had installed on your side.
Other way is to Go to "Control Panel" -> "Administrative Tools" and open "Datasources (ODBC)". By default, the tab "User-DSN" will be opened, click "Add" and a dialogue will pop up. In which you can find the version of Oracle installed on