jammusi
29th December 2010 13:46 UTC

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
30th December 2010 18:51 UTC

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

jammusi
2nd January 2011 06:28 UTC

thanks