Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
ASP.NET 1.0 and 1.1 Basics ASP.NET discussion for users new to coding in ASP.NET 1.0 or 1.1. NOT for the older "classic" ASP 3 or the newer ASP.NET 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Basics 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
  #1 (permalink)  
Old December 31st, 2005, 09:13 PM
Authorized User
 
Join Date: Mar 2005
Location: , , .
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Default connecting asp.net to oracle

i have asp.net1.1 and oracle 9i, trying to connect to oracle database but getting an error saying can't find the database, this is what I have in web config
 <appSettings>
  <add Key="OraTest"
       Value="provider= OraoleDB.Oracle.1; Data Source= c:\oracle\school\chapter3\3clearwater.sql;
       user id=far@far;
       password=far;" />
  </appSettings>
Thanks in advance

  #2 (permalink)  
Old January 1st, 2006, 04:38 PM
planoie's Avatar
Friend of Wrox
Points: 16,481, Level: 55
Points: 16,481, Level: 55 Points: 16,481, Level: 55 Points: 16,481, Level: 55
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2003
Location: Clifton Park, New York, USA.
Posts: 5,407
Thanks: 0
Thanked 16 Times in 16 Posts
Default

The data source should be the TNS service name of the TNSNAMES entry you have set up in your local oracle installation.

-Peter


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error While Connecting to Oracle 9i via .Net soft4net ADO.NET 1 December 21st, 2006 03:14 AM
connecting oracle with asp.net rajatake General .NET 2 June 28th, 2005 01:45 AM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Professional 3 January 13th, 2004 07:18 PM
OleDb.Net vs. ODBC.Net for Connecting to Oracle cjo ASP.NET 1.0 and 1.1 Basics 1 December 23rd, 2003 10:56 AM





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