cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JamiZhang
Level 3

Why doesn't SQLServerSelectLogin work in InstallShield 2008 by default?

I convert one InstallScript MSI from InstallShield 12 to 2008. SQLServerSelectLogin is working in 12, but not show up in 2008.

I create a new InstallScript MSI with InstallShield 2008, just add the script and SQL connection. The return value by SQLServerSelectLogin is -1. The same result is returned by SQLServerSelectLogin2. I attach this simple project here.

What setting do I need to change for SQLServerSelectLogin to show up in 2008?

Thanks,
Labels (1)
0 Kudos
(1) Reply
hidenori
Level 17

Please replace the following codes with the SQLRTInitialize2() function call:

szDLL = SUPPORTDIR ^ "ISSQLSRV.DLL";
nResult = StreamFileFromBinary(ISMSI_HANDLE, "ISSQLSRV.DLL", szDLL);
UseDLL(szDLL);

From IS 2008, InstallScript MSI projects support the SQLRTInitialize2() function which loads the ISSQLSRV.DLL. The SQL* functions check to see if the initialization function has been called.

Regards.
0 Kudos