This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Remote Folder Access
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 26, 2011
10:55 AM
Remote Folder Access
Hi,
I was wondering if there was a way to browse the folders on a remote server? I am installing a SQL Server database from a script on the remote server but I am just manually specifying the path on the remote server instead of browsing to it. How or is it possible to do this from the installation? The project is an InstallScript MSI project.
Thanks,
Greg
I was wondering if there was a way to browse the folders on a remote server? I am installing a SQL Server database from a script on the remote server but I am just manually specifying the path on the remote server instead of browsing to it. How or is it possible to do this from the installation? The project is an InstallScript MSI project.
Thanks,
Greg
(2) Replies
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 26, 2011
01:06 PM
I don't know about browsing remote server folders, but if you run these SQL scripts they will give you the default Data and Log folders for the SQL database engine you are connected to:
.mdf files:
.ldf files:
Should work for SQL 2000, 2005, & 2008
HTH
.mdf files:
SELECT REPLACE(filename, 'master.mdf', '') AS Value FROM master.dbo.sysdatabases WHERE name='master'
.ldf files:
SELECT RTRIM((SELECT REPLACE(filename, 'mastlog.ldf','') FROM master.dbo.sysfiles WHERE (status & 0x40) <>0)) AS Value
Should work for SQL 2000, 2005, & 2008
HTH
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
‎Apr 26, 2011
01:11 PM
Yea, the problem that I am trying to work around is letting the user installing the databases to be able to pick folders other than the default data directories. I've read in some posts that you can't browse remote folders due to the restriction of the windows installer so maybe I will just have to have the user run an installation on the database server so that they can pick their own data directories and not the default. Then I can have the installer create the folders if they don't exist because it is running locally.
Unless anyone else has another idea?
Thanks,
Greg
Unless anyone else has another idea?
Thanks,
Greg