Reply to Thread

Re: Problems with SQL server install in 8.1

Perfect. Thanks for the update!

Friedrich

Re: Problems with SQL server install in 8.1

Thanks....that was it....set up %MYFOLDER% and all is well.....

Re: Problems with SQL server install in 8.1

BTW, when you launch an external file from the install, you need the exact location. If the external file is located in the temporary Windows folder, you can use %TMPDIR%.

Friedrich

Re: Problems with SQL server install in 8.1

See attached

Friedrich

Re: Problems with SQL server install in 8.1

I would suggest to use %CURDIR%.

-or-

Set Variable %MY_INSTFOLDER% to FUNCTION:Get System Info(Installer Path Name)

Friedrich

Re: Problems with SQL server install in 8.1

We were just discussing.....SQL should always be in the same dir as the other install files. Do I even need %SRCDRV% at all. It's not used anywhere else.

Re: Problems with SQL server install in 8.1

I think you are correct......I'm trying to find where %srcdrv% is set (it's been a few months since I put this together).

When I install from media %srcdrv% is probably the cd drive or jump drive.....but when I download from the web.....it is being loaded from a download directory on C & %srcdrv% is probably not set.

Not sure how to show %srcdrv% in the message box....

Will I need a different installer to install from the web and use something like %tmpdir% instead of %srcdrv%

Re: Problems with SQL server install in 8.1

I think it's a simple "source folder" problem.

%SRCDRV%\SQLEXPR_x86_ENU might resolve to, say, E:\SQLEXPR_x86_ENU when the installer is launched from the E: drive. Do you have the SQL redistributable located on the root of the drive after you unzipped it? Or do you have it in a sub-folder?

And always add the ".exe" extension when you launch an application via the CreateProcess Windows API (Run Command Line is a wrapper around CreateProcess).

Friedrich

Re: Problems with SQL server install in 8.1

That may be it......I'll try trapping for the message....something flashes but it is too fast.....just confusing why it would run from disk & not from download....

Re: Problems with SQL server install in 8.1

Hello,

Then you have to catch the return value from the external installer to see if it returns an error code. And make sure the runtime variables resolve to the expected values. For example, your %SRCDRV% variable value.

IMO, your path location is incorrect and the SQL redistributable is not launched at all. Add a simple "Display Message Dialog" function before your "Run Command Line" action to see if "%SRCDRV%\SQLEXPR_x86_ENU.exe" (please note the missing '.exe' above) displays the correct and expected values.

Hope this helps a bit.

Friedrich