PDA

View Full Version : Why doesn't SQLServerSelectLogin work in InstallShield 2008 by default?



JamiZhang
07-17-2007, 03:11 PM
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,

hidenori
07-17-2007, 05:56 PM
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.