Oracle Database Connection
Can someone please guide me in making a connection to an Oracle database on another server? I have installed Oracle 8i in our web server hoping that I can get connection.
I am getting the following error message:
Oracle Automation error '800a01b8'
Unable to make connection, ORA-12560: TNS:protocol adapter error
/development/Connection.asp, line 21
Below is my connection code:
'Declare variables as OLE Objects.
'Create the OraSession Object.
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
'Create the OraDatabase Object by opening a connection to Oracle.
' Be sure your own username and password to access your Oracle db
Set OraDatabase = OraSession.OpenDatabase("", "bendev/bendev",Cint(0)) ---->> THIS IS LINE 21
'Create the OraDynaset Object to execute SQL statement
Set OraDynaset = OraDatabase.DbCreateDynaset(_
"select * from dbo.disburse_schedule", cint(0))