Running Program(on VB .NET) Without SQL

[FriendlySoluations]

How can i use the project(Windows Application) made by vb.net(use Ado.Net) depend on SQL Server2000 in client pc without install SQL Server2000 in the client pc? In other words I want ask if there is any way in which we will not install SQL Server2000 on client pc and the program will run properly?

[Rizwan Bashir]

you just need to change the connection string for the server. So save your connection string in app.config file and use that. or read it from any XML or text file from client machine

Rizwan Bashir ALM Soft[^]

[Dave Kreskowiak]

If your application is written dependant on an SQL Server backend, you'll still need an instance of SQL Server running somewhere, either one on the client PC or one on another server. On the local machine, you can install the desktop version of SQL Server. For SQL Server 2000 it's called MS Desktop Engine, or MSDE[^]. For SQL Server 2005, its called SQL Server Express[^].

Dave Kreskowiak Microsoft MVP - Visual Basic