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

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"

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

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?

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.:)

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...

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

Ok, thanks so much, Hal.

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 [email protected]

dev

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)