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
 
Old August 19th, 2004, 08:15 AM
Friend of Wrox
Points: 3,489, Level: 24
Points: 3,489, Level: 24 Points: 3,489, Level: 24 Points: 3,489, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Central, NJ, USA.
Posts: 1,101
Thanks: 0
Thanked 2 Times in 2 Posts
Default

I don't think MySQL or Oracle are good choices-

MySQL doesn't have a data provider for .NET I don't belive- I thought I saw some questions about that.

Oracle is still very convoluted in how you connect- at least that's what my oracle people are telling me.. You have to install the Oracle Client...create a special file.. configure the system to connect.

So Access or MS SQL Server I think are the best choices... and Access isn't good for anything but the smallest site. In 99% of the cases MS SQL Server 2000 is the right choice for most web sites - especially if you don't have to deal with Legacy Data.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 19th, 2004, 08:18 AM
Authorized User
 
Join Date: Jun 2004
Location: Georgetown, Selangor, Malaysia.
Posts: 99
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via ICQ to hlchuah77
Default

Oh I see...

from your reply, I can guess that MS SQLServer 7.0 or MS SQLServer 2000 is actually the DBMS by Microsoft, rite? and MySQL might be other company's product... rite? Please correct me if I am wrong, :)

Am I asking too many questions actually? Because I am first time involving in this kind of forum, really don't know what should be asked or what should not be asked.

 
Old August 19th, 2004, 08:25 AM
Friend of Wrox
Points: 3,489, Level: 24
Points: 3,489, Level: 24 Points: 3,489, Level: 24 Points: 3,489, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Central, NJ, USA.
Posts: 1,101
Thanks: 0
Thanked 2 Times in 2 Posts
Default

You are correct- BOth Access and SQL Server 2000 (7.0 is no longer availible- it's replaced by 2000) are Microsoft products.

Oracle *COULD* play nicely with Microsoft ADO.NET - they just choose not to.



Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 19th, 2004, 08:27 AM
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

I have yet to see on this thread what appears to me to be a necessary clarification for something that seems to be confusing a few people:

ADO.NET is the collection of classes that are used for data access. ADO.NET is not a data access provider. It is the .NET replacement for ADO (where we used ADODB.Connection and ADODB.Recordset in ASP and VB).

Within the System.Data namespace are the namespaces for the different data providers that have been mentioned (System.Data.SqlClient, System.Data.OleDb, System.Data.Odbc). These ARE data providers.

What people have been trying to say is that if you plan on using MSSQL Server, then you should use the SqlClient namespace for your data operations because the classes for connecting to MSSQL Server are built to work directly with the database server instead of going thru the "middleman" of the OLEDB or ODBC data access layer components of Windows. You can most certainly still use the System.Data.OleDB provider with SQL (and use the SQLOLEDB provider for Windows that comes with SQL), but it doesn't make sense and hurts performance. You could however use the System.Data.OleDb namespace classes with an Oracle database because there is no native .NET connectivity to Oracle. You would then use an Oracle provided OLEDB access provider such as "OraOLEDB.Oracle". (I believe you can get an "OracleClient" assembly of classes for .NET, I have never looked into it though. This may provider a performance enhancement similar to the SqlClient classes.)

I hope this helps to clarify what has been said in this thread.
 
Old August 19th, 2004, 08:35 AM
Friend of Wrox
Points: 3,489, Level: 24
Points: 3,489, Level: 24 Points: 3,489, Level: 24 Points: 3,489, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Central, NJ, USA.
Posts: 1,101
Thanks: 0
Thanked 2 Times in 2 Posts
Default

According to my Oracle DBA here I don't have many options with Oracle. My searching online also found nothing but complex methods to talk to Oracle - all that required the install and config of the OraClient software- Much like an ODBC Connection.

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 19th, 2004, 08:41 AM
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

Yes, that is how we have had to do it here. But that's only because we have to write applications that play nicely with either MSSQL or Oracle (or another OleDB provider supported datastore).

Perhaps we have both been missing something:

http://msdn.microsoft.com/library/de...acleclient.asp
 
Old August 19th, 2004, 08:45 AM
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

Hal,

I just looked into it a bit more, and I found System.Data.OracleClient.dll in my 1.1 framework available reference list. So the other providers are available by default with inclusion of the reference to System.Data, but Oracle needs to be referenced manually.
 
Old August 19th, 2004, 09:28 AM
Friend of Wrox
Points: 3,489, Level: 24
Points: 3,489, Level: 24 Points: 3,489, Level: 24 Points: 3,489, Level: 24
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Central, NJ, USA.
Posts: 1,101
Thanks: 0
Thanked 2 Times in 2 Posts
Default

I didn't read the reference at length yet... Does it still require the installation of the Oracle client software or will it work independent of it?



Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 19th, 2004, 10:19 AM
Friend of Wrox
 
Join Date: Jul 2004
Location: Tehran, , Iran.
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post
Default

Hal,also MySQL has a special DataProvider for .NET(except OLEDB.NET)
I think Microsoft released it about two months ago.

--------------------------------------------
Mehdi.:)
 
Old August 19th, 2004, 12:32 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

Quote:
quote:Originally posted by Hal Levy
 ...will it work independent of it?

I also haven't read the documentation at length. That's what I would hope would be the case.

I spoke to someone who reports that the .NET OracleClient only works with certain previous versions. The later versions (I don't recall from what version on) do NOT work with the classes in this namespace.




Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem to restore database in C#2005 database acmuralee MySQL 0 March 25th, 2008 04:42 AM
Microsoft JET Database Database Engine (0x80040E09 cannielynn0312 Classic ASP Professional 2 December 17th, 2007 02:50 AM
Database Connection to Access Database reachsevar ASP.NET 2.0 Basics 1 November 28th, 2007 08:56 AM
Copying Table From one Database To Anoter Database jayanth_nadig VB Databases Basics 1 June 19th, 2006 02:39 PM





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