Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Classic ASP Databases Discuss 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 .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old October 18th, 2006, 03:07 PM
Friend of Wrox
Points: 1,007, Level: 12
Points: 1,007, Level: 12 Points: 1,007, Level: 12 Points: 1,007, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 195
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default 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.
 Dim OraSession
 Dim OraDatabase
 Dim OraDynaset


'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))



Thanks

Reply With Quote
  #2 (permalink)  
Old October 18th, 2006, 03:44 PM
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons
Default

I dont use Oracle but this link may help you:

http://www.asp101.com/articles/colin/oracle/default.asp

-------------------------
I will only tell you how to do it, not do it for you.††
Unless, of course, you want to hire me to do work for you.

^^Thats my signature
Reply With Quote
  #3 (permalink)  
Old October 18th, 2006, 04:13 PM
Friend of Wrox
Points: 1,007, Level: 12
Points: 1,007, Level: 12 Points: 1,007, Level: 12 Points: 1,007, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , USA.
Posts: 195
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to jmss66
Default

I see where I went wrong, I forgot to put in the database name.

Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle Connection teddyk ASP.NET 2.0 Basics 1 October 6th, 2008 07:08 PM
Connection to Network based Oracle Database soft4net ADO.NET 0 December 22nd, 2006 01:32 AM
oracle connection silvia C# 4 January 17th, 2006 08:12 AM
Connection string to Oracle Database phudong3da Dreamweaver (all versions) 2 May 2nd, 2005 08:13 PM
connection for Oracle 8i kosla78 ADO.NET 1 September 3rd, 2003 03:41 AM



All times are GMT -4. The time now is 08:16 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.