Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 21st, 2011, 09:37 AM
Authorized User
 
Join Date: Apr 2009
Posts: 52
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connection problem with Oracle 11g and IIS7

When I am trying to connect to Oracle 10g with the connection string, it works fine but when I am trying to connect same Classic asp code with Oracle 11g, I am getting below error.

Microsoft OLE DB Provider for ODBC error '80004005'

[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.

I have checked my TNS entry is correct under tnsnames.ora

I am using Windows server 2008 and Oracle 11g.
 
Old December 16th, 2011, 07:55 AM
Registered User
 
Join Date: Dec 2011
Posts: 3
Thanks: 0
Thanked 1 Time in 1 Post
Default

The Microsoft ODBC driver for Oracle is very old and not supported.The support for Oracle database and drivers is at Oracles Web Site.
I suggest you visit oracle.com/technetwork/database/windows/whatsnew/index.html Oracle Network and register for an Account which is no cost.Then after you have joined the Oracle Network check the download sectio for Visual Studio Tools for Oracle and look for the ODAC112021xcopy.zip package for X64 or X86 which contains the updated runtime drivers for Windows.
After you have downloaded the runtime drivers read the guides at oracle for install.The new driver for Oracle will appear in the ODBC manager you then can update "your connection string" to use the new driver.If you can not connnect to the Oracle database the problem typically are the tns.listener connection settings.
Typical settings use XE.NAME for the server instance. You will need to open the firewall for port 1521 to allow connections.
If you look at the ora error which is oraXXXX message and search (Goolge or Bing) there are place on the Web that show how to change the tns listener for the Oracle Database engine.
If you have problems with the connection string you can (Google or Bing) Connection Strings.
If you have IIS Server errors then read the IIS Net library guides for Enabling and Turning on "Failed Request Tracing"





Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem connecting classic asp to SQLserver 2008 express via IIS7 on win7 64bit alextf Classic ASP Databases 2 February 6th, 2011 12:32 PM
"Oracle 11g included on the DVD"...huh? monicaroman BOOK: Beginning Oracle Application Express ISBN: 9780470388372 1 May 9th, 2010 12:08 AM
[Microsoft] [ODBC driver for oracle] [oracle] ORA-06413: connection not open dpkbahuguna Beginning VB 6 7 May 5th, 2009 12:31 AM
Oracle Connection teddyk ASP.NET 2.0 Basics 1 October 6th, 2008 06:08 PM
oracle connection silvia C# 4 January 17th, 2006 08:12 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.