Create SQL connection using install script in installshield project

Question

0.00/5 (No votes)

See more:

In InstallShiled setup project we have certain requirement that we need to validate any specific DataBase is exist or not on given SQL Server.

For that we are using below Install Script:

JavaScript

szADOConnObjID = "ADODB.Connection";
set pADOConnObj = CreateObject(szADOConnObjID); 

szConnString = "driver={SQL Server};"; // For TLS 1.2 Only use driver={SQL Server Native Client 11.0};
szConnString = szConnString + "server=SQLServerName;";
szConnString = szConnString + "Initial Catalog=master;";
szConnString = szConnString + "Integrated Security=True";
MessageBox("SQL Connection String: " + szConnString, INFORMATION);
	
try
	MessageBox("Trying with Windows Authentication first", INFORMATION);
	if (pADOConnObj.State==0)then 
		pADOConnObj.Open(szConnString);
		MessageBox("Connection Success", INFORMATION);
	endif;	
catch
	MessageBox("Windows Authentication Catch",INFORMATION);
	MessageBox(Err.Description , SEVERE);
endcatch;

With above Install Script it gives below error:

JavaScript

---------------------------
Sample SQL Connect - InstallShield Wizard
---------------------------
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
---------------------------
OK   
---------------------------

Any idea what am I doing something wrong here?

What I have tried:

JavaScript

szADOConnObjID = "ADODB.Connection";
set pADOConnObj = CreateObject(szADOConnObjID); 

szConnString = "driver={SQL Server};"; // For TLS 1.2 Only use driver={SQL Server Native Client 11.0};
szConnString = szConnString + "server=SQLServerName;";
szConnString = szConnString + "Initial Catalog=master;";
szConnString = szConnString + "Integrated Security=True";
MessageBox("SQL Connection String: " + szConnString, INFORMATION);
	
try
	MessageBox("Trying with Windows Authentication first", INFORMATION);
	if (pADOConnObj.State==0)then 
		pADOConnObj.Open(szConnString);
		MessageBox("Connection Success", INFORMATION);
	endif;	
catch
	MessageBox("Windows Authentication Catch",INFORMATION);
	MessageBox(Err.Description , SEVERE);
endcatch;

Posted 21-Jun-17 20:47pm

Bharat Leel

Updated 23-Jun-17 23:39pm

Add a Solution

2 solutions

Solution 1

Maybe you are missing "database=master;" and "Trusted_connection=Yes", see the example here:
Installshield custom dialog, custom actions, and code[^]

Posted 22-Jun-17 1:15am

RickZeeland

Updated 22-Jun-17 1:21am

v2

Comments

Bharat Leel 24-Jun-17 5:35am

Thanks, it fixed my solution at some extend, while digging more finally I found solution that I also need to replace Driver with Provider.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Bharat Leel · Accepted Answer · 2017-06-23T23:39:00

After digging in detail I found fix for this from here.

For Non-TLS 1.2

JavaScript

szConnString = "Provider=SQLOLEDB;"
szConnString = szConnString + "data source=SQLServerName;"
szConnString = szConnString + "Initial Catalog=master;"
szConnString = szConnString + "Integrated Security=SSPI"

For TLS 1.2

JavaScript

szConnString = "Provider=SQLNCLI11;"
szConnString = szConnString + "SERVER=SQLServerName;"
szConnString = szConnString + "database=master;"
szConnString = szConnString + "Trusted_Connection=Yes"
msgbox "SQL Connection String: " + szConnString, INFORMATION

For TLS 1.2 is best solution because it's working in both environment.