Wrox Programmer Forums
Go Back   Wrox Programmer Forums > .NET > Other .NET > General .NET
| Search | Today's Posts | Mark Forums Read
General .NET For general discussion of MICROSOFT .NET topics that don't fall within any of the other .NET forum subcategories or .NET language forums.  If your question is specific to a language (C# or Visual Basic) or type of application (Windows Forms or ASP.Net) try an applicable forum category. ** PLEASE BE SPECIFIC WITH YOUR QUESTION ** When posting here, provide details regarding the Microsoft .NET language you are using and/or what type of application (Windows/Web Forms, etc) you are working in, if applicable to the question. This will help others answer the question without having to ask.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the General .NET 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 June 23rd, 2005, 02:27 AM
Authorized User
Points: 179, Level: 3
Points: 179, Level: 3 Points: 179, Level: 3 Points: 179, Level: 3
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2005
Location: chennai, Tamil Nadu, India.
Posts: 36
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to rajatake
Default connecting oracle with asp.net

Dear friends,

I am developing one asp.net application which is using oracle as a Back End. I am new to Oracle. While connecting asp.net with oracle, It throws the following error.

No error information available: REGDB_E_CLASSNOTREG(0x80040154).
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: No error information available: REGDB_E_CLASSNOTREG(0x80040154).

My connection coding is like follow:

Dim con As New OleDbConnection
 con.ConnectionString = "Provider=OraOLEDB.Oracle; Driver={Microsoft OLE DB for Oracle};Data Source=orcl;User Id=scott;Password=tiger;"
 con.Open()

Pls help me.



  #2 (permalink)  
Old June 28th, 2005, 01:41 AM
Friend of Wrox
 
Join Date: Sep 2004
Location: , , India.
Posts: 140
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dont use Microsoft OLE DB for Oracle
Instead Try
ConnectionString="OleDB:Provider=MSDAORA.1;Data Source=myserver.com;User ID=scott;Password=tiger;

give your correct data source and user id and password.

  #3 (permalink)  
Old June 28th, 2005, 01:45 AM
Friend of Wrox
 
Join Date: Sep 2004
Location: , , India.
Posts: 140
Thanks: 0
Thanked 0 Times in 0 Posts
Default


ConnectionString="Provider=MSDAORA.1;Data Source=myserver.com;User ID=scott;Password=tiger;
give your correct data source and user id and password



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 asp.net to oracle farsfar2 ASP.NET 1.0 and 1.1 Basics 1 January 1st, 2006 04:38 PM
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.