For validating my servername using installscriptmsi project, I used SQLRTServerValidate method. Before that I called SQLRTInitialize2()method. Then I got an error that "There was an error loading sqlrt.dll. The file needs to be loaded for Installshield SQL operation.Verify that the file is in the SUPPOERTDIR directory." But I read that SQLRTInitialize2 loads the SQLRT.dll file for InstallScript projects and the ISSQLSRV.dll file for InstallScript MSI projects. Why this error comes for my installscript msi project?I already gave sqlrt.obl and SQLCONV.obl libs.Can anyone help me for that?
I created an installscript project in Installshiled 2009 Preimier Edition. I added \Script\SQLRuntime\Lib\SQLRT.obl into Build->Settings->Libraries and call SQLRTInitialize2(). I received the error message: "There was an error loading SQLRT.dll. This file needs to be loaded for InstallShiled SQL operation. Verify that the file is in the SUPPORTDIR directory. Setup will now terminate."
How can I fix this error.
PLease give me an answer as i am a beginer in InstallShiled.
Thanks in advanced
hidenori wrote: Is the problem reproducible if you create a new InstallScript MSI project from scratch and only add a connection in the SQL Scripts view?
SQLRT* functions are designed to work in conjunction with the SQL Scripts view. You must have at least one connection in the view to use those functions.
