This content has been marked as final. Show 5 replies
The usual cause is that you have the wrong bits (32/64) of Oracle client software installed.
Did you install 32 bit or 64 bit Oracle client software?
Is you web app running as 32 bit or 64 bit? Open Task Manager, click the process tab, is there a *32 next to the name? If so, its 32 bit.
IIS runs as 64 bit on a 64 bit box, the development webserver that comes with VS is 32 bit even on a 64 bit box.
Hope it helps,
Thanks for your reply.
I'm sure that the version of Oracle 10.2.0.4 is 64bit.
My web app version is 32 bit,so I execute "cscript C:\inetpub\adminscripts\adsutil.vbs SET w3svc/AppPools/Enable32bitAppOnWin64 1" to make it running as 32 bit.
I have installed the "10204_vista_w2k8_x64_production_client.zip", "ODAC10203x64.zip", "ODAC112021Xcopy_x64.zip", "WinIA64_10205_client.zip" separately on same separate environment(Windows Server 2008 R2 64bit, Oracle 10g 10.2.0.4).
Some of them I have installed successfully, but there is not Ole Db Provider in Data Source Manager(ODBC).
Some of them I have installing appearing something wrong.
I just want to make my 32 bit web application which can connect to the Oracle 10g 64 bit on Windows Server 2008 R2 64bit.
I feel a little hopeless now, but I'm still trying.
Supported versions on Win7 are 10205, 11201, and 11202.
To run a 32 bit app, you need 32 bit Oracle client software.
What I'd recommend is
a) remove everything you have installed at this point, as even if you get things working you have a big mess of an install
b) install 18.104.22.168.1 ODAC (32 bit) which will give you the 32 bit oledb provider.
ODAC 11.2 Release 3 (22.214.171.124.1) - ODAC112021.zip
Note that you'll never seen an OLEDB provider in the ODBC administrator though.. you'll only see ODBC drivers.
Hope it helps,