I'm using Installshield 12 for an InstallScript MSI project.
I need to be able to detect if a SQL Server exists and that the login credentials are valid but without having to run a scrip to get the dialogt. The project currently prompts the user for the SQL Server information when they're installing the server portion of our software. One of the client pieces require a UDL file to directly connect to the database, which posed my problem. Back to the server piece real quick; once the credentials entered into the SQL_Dialog authenticate, I've modified the InstallScript OnSQLLogin function to store the server name and any credentials entered so that I can use them later. At that point, the database for our software is created via an SQL Script (handled by installshield), I have InstallScript code creating the UDL file automatically, and all is well.
I would like to automate the creation of the UDL file for when the software is installed on a client machine only, so here's what I was thinking ... If I could get that very same SQL Dialog to appear, have the user enter in the SQL Server connection information, AUTHENTICATE (and optimally check to make sure the database exists if possible), and then write the UDL file in the same manner as I'm already doing it .... I could accomplish my goal. I'm a little hung up on the code in the OnSQLLogin script as far as which and how to use portions of it to do this though.
ANY HELP IS GREATLY APPRECIATED. THIS IS SOMEWHAT URGENT, BUT I APPRECIATE ANY HELP ON THIS WHATSOEVER!
Start Free Trial
