Software Deployment Question
Testing A SQL Database Connection with InstallShield 2015... Issues and Questions...
I hope someone can help me. I have to test a connection to a SQL database to ensure we'll have connection for the web app that is being installed. I thought it would be easy in that InstallShield should have some 'canned' SQL Login dialogs. Out of the box I didn't see any SQL dialogs but found that if I add a connection in the SQL Scripts view, I get the dialogs.
I added the minimum database requirement (SQL 2008 R2) and added the SQL Login dialog to my UI. At first test I could see the Servers on the network, entered user name and password and selected the available databases from the catalog dropdown on the dialog. It appeared OK at first, but a message was soon displayed that the database couldn't be CREATED due to permissions. WHAT? I don't want to create the database, I just want to see that I can log into it. After some digging I found some commands in the ISSQLDBMetaData that appeared to Create, Insert, etc.
I removed those entries and tried again, now it seemed all was OK, however, I can now click the Next button and proceed to the next dialog after only selecting the server. No user name/pswd or database and the verification passes. Even when all info is entered, but I enter garbage for the database name - the verification appears to pass.
I can't figure it out.
I'm wondering if I should just create my own dialog and Custom Action to get the job done here. I'm not even sure the existing SQL dialogs I'm playing with are even suited for what I'm trying to do.
Any guidance here would be greatly appreciated!