Thread: Running SQl server Scripts
October 25th, 2002, 06:17 AM #1
- Join Date
- Oct 2002
Running SQl server Scripts
I have a apllication developed in vb.net for which the database used is sqlserver.IF I want to load my application in some other machine then if that mahcine does not have sqlserver or sqlclient then how will I run the sql scripts which is basically having the database creation
October 25th, 2002, 02:08 PM #2
- Join Date
- Oct 2001
you'll have to ask the user (hopefully an admin) what machine to look for a sqlserver client for and what protocol they use (ie. named pipes vs tcp/ip) and what ports etc to use.
If you use the .net installer they may have some of that automated for you.
Welcome to TechIMO
Helicopters don't fly; they vibrate so much and make so much noise that the earth rejects them.
October 25th, 2002, 05:01 PM #3
I would guess you would have to have the installer prompt for a SQL server to connect to or have it based on a config file or registry key so that you could construct your SQL statements correctly.
It's easy to have VB.net create an ADO connection to a copy of SQL server that's not on the machine you're installing onto, just in your connection string you have to have something like "server=yourservernamehere" instead of "server=localhost" or my favorite "server=.".
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)