Skip to content
⌘ NSIS Forum Archive

Connect to Specific DB with sql server

3 posts

jammusi#

Connect to Specific DB with sql server

Hi,

I am using MSSQL_OLEDB to connect sql server
But SQL server can contain more then one DB
I can not find a way to indicate what is the data base name.

Please advice

Tx

Oren
sgiusto#
this is more a sql question rather than a nsis question...
You can use the USE command to select a database, on or you can put the full path to the table in your statements (select * from master.dbo.sysdatabases)
Hope this helps
Stefano