Archive: Executing SQL Server queries
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?
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
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.