Windows 7 64Bit, Oracle Database access from Classic ASP

Step 1: Install Oracle Client 64bit, the latest version (Solution intended for those who are already on 10g or above)

Step 2: If your connection call is not something like following, change it to

Dim adoCon                'Holds Connection
Dim rsViewRecords         'Holds Record Set

' Initiate connection

Set adoCon = Server.CreateObject("ADODB.Connection")

' Checking whether an exception raised during the Server Create Object call

if Err.Number <> 0 then 
response.Write "<hr>ORASESSION Error<br>" & err.number & "  --  " & err.Description & "<hr>"
response.Write "Session created"
end if 

adoCon.Open ";data source=orcl;user id=scott;password=tiger;plsqlrset=true"
Set rsViewRecords = Server.CreateObject("ADODB.Recordset")

' Your other stuff goes here



That’s all guys



Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.