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 18th, 2004, 12:21 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 database quetions

Hi, I just want to know what is the recommended database system if I would want to develop a system with ASP.Net?

Microsoft Access? Microsoft SQL Server 7.0? or...??? And what is ADO.Net actually? How does it relates to database? Or it is just a kind of connection method to database?

What about ODBC? I really confuse with all these stuff.
 
Old August 18th, 2004, 12:41 AM
Friend of Wrox
Points: 1,288, Level: 14
Points: 1,288, Level: 14 Points: 1,288, Level: 14 Points: 1,288, Level: 14
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2004
Location: Stockholm, Sweden
Posts: 331
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to qazi_nomi
Default

As the data base is concern it depends on your system if system is small then MS Acces else SQL Server and ADO and ODBC are the objects to connect to the database




Numan
--------------------------------------------------
Love is the most precious thing of this world. So find and grab it!
 
Old August 18th, 2004, 04:40 AM
Friend of Wrox
 
Join Date: Jul 2004
Location: Tehran, , Iran.
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post
Default

if you want to use ASP.NET,ADO.NET .its better to use MS SqlServer its faster because there isnt any provider between ADO connection object and MS SqlServer(7 or above).

--------------------------------------------
Mehdi.:)
 
Old August 18th, 2004, 07:50 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

Thanks ya qazi for the valuable suggestions. If the ADO and ODBC are the connection object to the database, does it means that no matter I use MS SQLServer or MS Access, I can choose either connection object, either ADO or ODBC?

But... mehdi, I can't get you... Do you mean that if I would want to use ASP.net and ADO.net, then I have to use MS SQLServer because ADO connection is not supported in MS SQLServer version 7.0 and above?


chuah

 
Old August 18th, 2004, 08:34 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

First, I would NEVER use access for a web site with any kind of volume. It's not built for it.

Second, I wish people would forget ODBC exists- It's slow and outdated. Using ADO.NET and the proper connectors your performance and reliability will go way up- and you don't have to worry about setting up ODBC connections on the servers.

Third, ADO.NET works with SQL Server as well as Access and many other "databases". Microsoft developed optimized methods that can be used with SQL Server 7.0 or Greater (I'd not even consider 7.0 at this point.. and use 2000.. or if your relase date is sometime off, 2005). Your optimal performance with ADO.NET is going to be with SQL Server 2000 at this point.

What you should use is going to depend on your requirements. There is no one size fits all answer.


Hal Levy
Web Developer, PDI Inc.

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

chuah,
first you should select your DataBase Management(like MS SQLserver,Access,Oracle,MySQl)
then according to above you should select your DataProvider(DataProvider is an object that connects your Connection object(like SqlConnection,OleDbConnection)to your DataBase Management software)i.e for MS Access you need OLED Provider and for MS SQLServer (7 or above)you dont need any DataProvider at all so using MS SqlServer could result more performances
sorry if I couldnt represent my meaning...
Hope it was clear.
(if u need more explanations no problem)

--------------------------------------------
Mehdi.:)
 
Old August 18th, 2004, 09:14 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

Mehdi, Why would you say you don't need a data provider for SQL Server? There is a data provider, just when you use the SQL Server namespace, it's assumed....

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 18th, 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

I ment There is no additional DataProvider Layer & no need for Translation to TDS.


--------------------------------------------
Mehdi.:)
 
Old August 18th, 2004, 08:46 PM
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

Ya, you all are really helpful.

Listen to Hal's advice, now I would forget about ODBC, because I have to narrow down my choices as well, otherwise I will be lost in middle of somewhere, rite? And I just bought Wrox's ADO.net bible, so I would not prefer ODBC as well. ;)

From yours' reply, ODBC and ADO.net are an object which connect to our DBMS, rite? Then, now I understand also that ADO.net has its support in MS Access as well as SQL Server.

And.... now, mehdi... follow what you have adviced me, the first step is that to choose a DBMS. But, before I choose a DBMS, I am very confuse also what are the DBMS out there that are avalaible. From what I know are MS Access, Oracle, and SQL Server 7.0. The worst is that I always confuse with "MS SQL server", "SQL Server 7.0", "MySQL", "SQL Server"... Does all these "name" refer to same DBMS or there are definitely different DBMS? May you just list out the DBMS item by item especially for those DBMS which quoted "SQL" as above.

I know after the selecting of DBMS, I have to choose a Data Provider so to connect to DBMS, rite? This one I would assume the use of ADO.net as suggested by Hal. However, I would like to solve the first step problem first, as I still confuse what are those DBMS yet.

Hal, I am very agree with what you said,

 
Quote:
quote:What you should use is going to depend on your requirements. There is no one size fits all answer.


I will draft out the system that I will going to develop later, so to get your advice further.


Chuah

 
Old August 19th, 2004, 07:34 AM
Friend of Wrox
 
Join Date: Jul 2004
Location: Tehran, , Iran.
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post
Default

Quote:
quote:
Does all these "name" refer to same DBMS or there are definitely different DBMS?
no,they are different i.e
1-MS Access
2-MS SqlServer(or SQLServer)
3-MySQL
4-Oracle
.....
all of them use SQL language(like SELECT * FROM .....)
for everyone you should use different provider that means u should use different namespace i.e
MS SQLSERVER(7 or above)------------->System.Data.SqlClient namespace
MS Access(or MS SQLSERVER below 7)----------------->System.Data.OleDb namespace
MySQl----------------->u should find the suitable provider from microsoft.com(its not installed with .NET defaultly)
Oracle--------------------->like MySql
HTH.

--------------------------------------------
Mehdi.:)




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.