I have a dilemma. I need to run a couple of SQL calls to a server from the client machine (after detecting the ODBC connection) as part of the client install. If anyone has any insight, It would be greatly appreciated!
This is a ready-only archive of the InstallSite Forum. You cannot post any new content here. / Dies ist ein Archiv des InstallSite Forums. Hier können keine neuen Beiträge veröffentlicht werden.
SQL
Started by
seisenreich
, Jan 17 2002 22:07
2 replies to this topic
seisenreich
-
- Members
- 2 posts
Posted 17 January 2002 - 22:07
Hi All,
Kurt Schneider
-
- Members
- 98 posts
Posted 18 January 2002 - 01:04
Greetings,
I'm not sure if this will work but I remember some utility called osql or maybe it was isql. It comes with SQL Server. It allows you to execute TSQL from the commandline. The part that I cannot remember is if you can connect remotely. I.E.
select * from <servername>.dbo.table. ......
It's worth checking out. Should find out more information in the SQL books online installed with SQL.
Good Luck. Let us know what you find out.
Kurt Schneider
Leigh Ravenhall
-
- Members
- 269 posts
Posted 20 January 2002 - 05:10
Another option would be to use the SQL-DMO components, which can be called from within a VBScript custom action. SQL-DMO allows for remote connection.
For details on how to use SQL-DMO, have a look in SQL Books on line, or in MSDN.