Access SQL Database from ASP.net

[Guest Ido]

I want to consult with you about SQL versions to access from ASP.net?

 

1) I just want to be sure: I read in one of many decent book about

ASP.net that says: "you need to install SQL 7.0 or higer to develope

ASP.net database applications" ... well I guess the author knows

better than me, but I got different answers, such as "you can use any

Database that suuport ODBC (include SQL6.5) for example.

I'm a little confuse here ??

 

2) I downloded from microdoft site this version of SQL Server compatible:

"msde.msi" and it is a free SQL Server compatible database engine

(database administration from within the ASP.NET Web Matrix

development ) MSDE does not have its own user interface (UI) or

tools. You interact with MSDE through the ASP.NET Web Matrix

development environment. I tried this a little and I was able to make

tabled easily thru ASP.NET Web Matrix development environment

 

Question: if you are fimiliar with this product, can you tell how much I

can rely on it? can I fill it with such amount of data as I would in

SQL7.0?(for example) what are the differents between SQL and this

SQL Server compatible product?

 

Thanks, :)

[Derek Stone]

System.Data.SqlClient supports SQL Server 7.0 and higher. However you can still access all version of SQL Server through the System.Data.OleDb namespace. SqlClient simply provides a faster and more efficient means of access.

 

MSDE is a slightly limited version of SQL Server, since it only allows for databases up to 2GB in size. It's also optimized for use by 2 - 4 users, although you won't notice a difference with a much higher load.

[Guest Ido]

Many thanks :)