SQL Connection problem

[m_m123]

Hello

I have just now installed VISUAL STUDIO.NET 2003 and I am going to write a program in ASP.NET using VB.NET. I have a database created using SQL 2000 and I am going to make a connection to it. I can not find any provider suitable for this work from server explorer. I must add that I have not installed the SQL 2000 software on my PC right now.

How can I connect to this SQL 2000 database?

It will be very good if somebody can also introduce me with some syntaxes to do basic works with a database such as adding a record , ......

 

Thank you very very much

[jch001]

I would download and install SQL Server 2005 http://msdn.microsoft.com/vstudio/express/sql/default.aspx (And Managment Studio Express).

 

then mount your database on it, you should then be able to connect to the SQL Server Databases from .NET

[amir100]

I didn't get the question. You have a database created using SQL 2000. But you don't have SQL Server 2000 installed. Then where's the location of your database? Is it on another server?

 

If you don't mind reading then the first place I'd recommend is the .Net Framework SDK Documentation. In the "Content" tab find a node about accessing data using ADO .Net.