Running SQl server Scripts

[Sunayana]

Hi,

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

Regards,
Sonu

[vass0922]

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

[Nighthawk]

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=.".