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.Clear() 
response.Write "<hr>ORASESSION Error<br>" & err.number & "  --  " & err.Description & "<hr>"
response.End
else
response.Write "Session created"
end if 

adoCon.Open "provider=oraoledb.oracle;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

regards,

Admin

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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: