mine Oracle version 8.1.6.
I am not getting any help as to how i should be able to connect to the Oracle Database located on Server-2 by using asp(Active Server Pages).
I have already configured the Listener & Local Net Service Name through the NET8 Config. Assistant I am able to connect to the Server-2 from Server-1 by using the Net8 Assistant and through the SQL*Plus also by giving the syntax :
connect scott/tiger@abcd - where abcd is the SID on the Server-2
Now when it is able to connect to the Oracle Database on Server-2 i want the same to happen through the asp script.I have tried a number of scripts for the same
Server-1 is used for application (ASP)
Server-2 is used for database (ORACLE)