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, 03:56 PM
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

Peter,

How shocking! I guess I am back to using the old way for the few applications I must use it on...



Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 20th, 2004, 09:30 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

From all the replies, one thing just make me to guess again is that because MS SQLServer and .net product are both from Microsoft, so, to use that two products together, there is no "middleman" needed as the connectivity already built in. For the DBMS like Oracle and others which are not from Microsoft, then the connection is not assumed where I have to define it manually, is that rite?

Is that corect also my understanding as shown below:

MS SQLServer can use "System.Data.SqlClient" (Good performance)
MS SQLServer can use also "System.Data.Oledb" (Lower down performance)
MS SQLServer can use also "System.Data.Odbc" (Lower down performance)

Oracle can't use "System.Data.SqlClient"
but can use

  "System.Data.Oledb"
  "System.Data.Odbc"

 
Old August 20th, 2004, 01:36 PM
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

Yes.
Yes.
Yes.

I was on MSDN today and here's the lead article: http://msdn.microsoft.com/data/defau...DataAccess.asp

So, that might give some pointers to oracle.. I didn't read the details...

Like I said, if I can pick what database to use I pick MS SQL Server.....


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 22nd, 2004, 04:45 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

Mehdi and Hal, if I am using SQL Server 2000, is the syntax used the same with SQL Server 7.0? Recently my friend borrow me one book, is all about SQL Server 7.0 training by Microsoft Press. I have a quick glance over it, there are few systax example as below:

USE Northwind
EXEC sp_helpconstraint adult
EXEC sp_help state_default
        .
        .
and many more

I understand some query language such as SELECT, GRANT, FROM all that, but when come to this "USE", "EXEC", "sp..." I really do not have idea what is it.

So, can I learn the basic(its syntax) using the SQL Server 7.0, but apply to SQl Server 2000 (due to short of funds to posses any new book already )?

Mehdi, you have created a site to teach people how to develop Library Management System, rite? You are teaching people using SQL Server 2000 as well, so if you read this reply again, can you explain me in detail regarding this DBMS question?


 
Old August 22nd, 2004, 12:20 PM
Friend of Wrox
 
Join Date: Jul 2004
Location: Tehran, , Iran.
Posts: 623
Thanks: 0
Thanked 1 Time in 1 Post
Default

I havent worked with MS SQL 7 but I worked with MSDE(SQL Server 2000)with Visual Studio.NET)

i.e EXEC sp_helpconstraint adult I think it should execute a stored procedure although in MS SqlServer 2000 we use this syntax
EXECUTE sp_helpconstraint adult
(I think Hal worked with MS SQLServer 7 and can help you better)

--------------------------------------------
Mehdi.:)
 
Old August 22nd, 2004, 01:38 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, thanks Mehdi.

Anyway, I know that all the SQL query language is standard, so it can apply to most of the DBMS. However, last semester I did learn a few lessons of Oracle, and the way it uses SQL query seems a bit different (if i am not mistaken).. anyhow.. I will forget about Oracle as I don't want to install it in Win OS also (very complicated to install ).

From your reply, that's why I worry before, because even though I don't understand the command such as "EXEC", but I just worry that may it be platform-specific command where SQL Server 7.0 will use this but SQL Server 2000 will use other. Now you replying me saying that in SQL Server 2000 use "EXECUTE" rather than "EXEC", which means what I worry is reasonable, :)

Anyway, thanks again, Mehdi. I will wait for Hal's reply...

 
Old August 23rd, 2004, 08:56 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

SQL 2000 does everything SQL 7.0 does. However, it also does more. You can safely learn from a 7.0 book.

You just won't learn about the NEWER things in SQL 2000... Of course, SQL 2005 is on the way.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee
 
Old August 24th, 2004, 09:16 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

Ok, thanks so much, Hal.

 
Old October 2nd, 2005, 10:32 PM
Registered User
 
Join Date: Sep 2005
Location: bpl, mp, India.
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to dsschauhan Send a message via Yahoo to dsschauhan
Default

Hi I'm goining to develop an Online Examination Project and I want to Know the connectivity of ASP.net with Ms-Access through the use of web.config file.
Pls send answer on dsschauhan@hotmail.com

dev
 
Old November 28th, 2006, 05:48 PM
Registered User
 
Join Date: Nov 2006
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to am_component
Default

is there away to set the max no of rows of the odbc recordset
don't advice to change to another class cuz my code is working but this the only bug (till Now)





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.