Quest: ASP.NET access to Database without any SQL Server...

  • Thread starter Thread starter lewi
  • Start date Start date
L

lewi

I am just starting to use ASP.NET(C#) with VS.NET 2002 Pro on Win2000 Server
and spend only little time with MySQL while working with PHP. Now I am only
using all this for developement/learning and only on the localhost. I would
use SQL 2000 server if I have it but don't have the money to get it but I
don't want to wait with porting the PHP script so what can I use with
ASP.NET to access a DB so I can build round then replace this with SQL
2000(or higher) Server later...

Like is there a way to access an MS Access 2000 DB which I have but not
install yet using ODBC or some other DB connection. Can I access this DB
with an SQL interface so command aren't needed to be changed in my ASP.NET
page with adding SQL 2000 Server later...

Any help...
 
Hello

You can start with MSDE (Miscrosoft Desktop Engine) which is a free version
of SQL server 2000, with lower performance and reduced features. But it is
good for development and testing purposes.

Read about it and download it here
http://www.microsoft.com/sql/msde/default.asp

Best regards,
Sherif
 
Read about it and download it here
Thanks, I will try that out...
Click to expand...
Ok, I installed it but I don't know where to do next...

What do I do now to setup a DB. Install MS Access 2000?...

When I have a DB should I be able to make SQL call from ASP.NET app to
access the DB?

Any more help?
 
Hello

MSDE doesn't come with GUI clients (Entreprise manager , Query analyzer,
etc)
You can connect to it using osql command line utility, or using ASP.NET (or
any Sql Client).
You can use visual studio too, to design tables, etc

Best regards,
Sherif
 
You can connect to it using osql command line utility, or using ASP.NET
(or
any Sql Client).
You can use visual studio too, to design tables, etc
Click to expand...
Thanks alot for the great help... I will look at sample ASP.NET apps to
learn how to access the DB and see if I can create a DB in VS...

Thanks again...
 
Back
Top