Classic ASP DatabasesDiscuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
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))