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

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: