Deploying SQL Server w/ VB
-
Is there a way to package SQL Server (databases and any other necessary files) into my Visual Basic .exe so that it can be used on any machine? That is, one without access to the database or SQL Server? Assuming there would be no adding or deleting of records to any table.
-
No. SQL Server is not really designed for that sort of use... it would normally be located on a central server and accessed by client applications... and you would need sufficient licenses of SQL Server to cover the number of users connecting to the server...
-
There is an option though ... MSDE (Microsoft Data Engine). This is to SQL server as Personal Web Server is to IIS. It's distibutable with your applications and supports all standard SQL syntax for querying. You can actually manage one of these databases using MS Access also so you don't need to use command line management or the SQL enterprise manager. The main drawback to this is, limited connections ... they limit your concurrent connections to 5. much like PWS is limited to about 5 to 10 or so.
Post a reply
SQL Server forum discussion
-
problem with select within select
by hamidreza.hr923 (2 replies)
-
convert EMPTY fields to NULL?
by viktorcheberachko (5 replies)
-
how to delete values of a particular column in a table
by sanjaymishra112sm112 (7 replies)
-
Send mail from stored Procedure.
by Mulish Mehdi (3 replies)
-
how to update multiple entries
by khari6579 (1 replies)
Quick links
Recent activity
- arif ahmad replied to How to receive data in web ...
- William Thompson replied to What is the name of the Win...
- Sameera Piyadigamage replied to Point of Sale Developers: H...
- Scott Carline replied to 4 x C# Developers for large...
- Rajendra Dhakal replied to Restore SQL Server text dat...
- cloud rainda replied to How to convert between TS f...
Enter your message below
Sign in or Join us (it's free).