Skip to content
⌘ NSIS Forum Archive

Executing SQL Server queries

3 posts

aadya#

Executing SQL Server queries

Hi All,
I would like to execute sql server queries during my installation.
The only way i know is to use client utility - osql. Is there any other way i can do the same?
Problem is it is not always guaranteed that the client computer on which installation is being carried on will always have this utility.

any thoughts?
crisp#
My SQL Server is limited to none :-).
Anyway, first why don't you redistribute the command line utilities with your installer ?
And secondly, did you check the NSIS Archive especially this item ? http://nsis.sourceforge.net/archive/...php?pageid=471

Greetings,
Cristian
aadya#
Thanks.
Yeah i checked that and infact i already did built in something like that.
About redistributing the command line utilities, I am sure OSQL will have dependencies on a few dlls for ODBC connections. Now I am not really sure which "package + OSQL" is the right combination. I read a bit about sqlredis.exe/ MDAC etc... compounded my limited thinking ability 🙁
MSDE though ships with OSQL but installing MSDE itself is big thing via another installer.
I guess need to do a lot of digging on this subject.