We realized, over a 64bit OS you may need to change the default application pool to accommodate 32bit applications. Please refer to this post
So, you are still using classic ASP or develop 32bit .NET applications using Visual Studio and Oracle databases on a Windows 7 64bit box and completely lost as connection cannot be established?
Here are few workaround solutions
Install the latest Oracle clients (both 64bit and 32bit)
If you installed Oracle client in the following folders (example)
right click on the folder, under security tab check whether authenticated users have read privileges.
If not, provide the basic privileges (Read & Execute, list folder contents, Read) Refer the image
Now add the user “IIS_ISURS” user and provide the same rights mentioned above
RESTART your Windows 7 “64bit” box now!
You can establish the connection from classic ASP like following
Dim rsViewRecords 'Holds Recordset
Set adoCon = Server.CreateObject( "ADODB.Connection")
if Err.Number <> 0 then
response.Write "<hr>ORASESSION Error<br>" & err.number & " -- " & err.Description & "<hr>"
adoCon.Open "provider=oraoledb.oracle;data source=test;user id=apps;password=apps;plsqlrset=true"
Set rsViewRecords = Server.CreateObject( "ADODB.Recordset")