References
26.12.2013 Update
We realized, over a 64bit OS you may need to change the default application pool to accommodate 32bit applications. Please refer to this post
http://www.connectionstrings.com/
http://stackoverflow.com/questions/234657/binding-asp-net-gridview-to-an-oracle-sys-refcursor
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)
D:\app\yourusername\product
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 adoCon 'Holds Connection Dim rsViewRecords 'Holds Recordset Set adoCon = Server.CreateObject("ADODB.Connection") if Err.Number <> 0 then Response.Clear() response.Write "<hr>ORASESSION Error<br>" & err.number & " -- " & err.Description & "<hr>" response.End end if adoCon.Open "provider=oraoledb.oracle;data source=test;user id=apps;password=apps;plsqlrset=true" Set rsViewRecords = Server.CreateObject("ADODB.Recordset") %>
Regards,
Admin