sumit1
Posts: 18
Joined: Thu Nov 29, 2018 3:40 pm

How to install an ODBC connection 13 automatically

Tue Jan 08, 2019 6:06 am

Hi,


We are trying to install the following in silent mode as prerequisites to main install:
- MS SQL Server 2012
- Microsoft ODBC Driver 13

Ms Sql Server 2012 install successfully.
We want steps to install an ODBC connection 13 automatically using prerequisites with all settings. Also conditions to check ODBC driver is install or not if not then install ODBC driver 13 automatically.

Catalin
Posts: 6506
Joined: Wed Jun 13, 2018 7:49 am

Re: How to install an ODBC connection 13 automatically

Tue Jan 08, 2019 11:50 am

Hello,
We want steps to install an ODBC connection 13 automatically using prerequisites with all settings.
In order to achieve this, you can proceed as it follows:

- First thing you need to do is to download the "ODBC Driver 13 for SQL Server". As of today's date, a valid download link is:

https://www.microsoft.com/en-us/downloa ... x?id=50420

- After downloading it, open your project and add it as a "Pre-Install" / "Feature-Based" prerequisite.

- Click on the prerequisite --> under "Setup Files" tab --> under "Install Command Lines" insert the following command line arguments:

-Full UI: /qn IACCEPTMSODBCSQLLICENSETERMS=YES
-Basic UI: /qn IACCEPTMSODBCSQLLICENSETERMS=YES
-Silent (no UI): /qn IACCEPTMSODBCSQLLICENSETERMS=YES

One thing to keep in mind: In order to install "ODBC Driver 13 for SQL Server" automatically and silently, elevated rights are required ("Run as Administrator").

Attached you can find a sample project for your reference:
Sample Project ODBC.aip
(19.69KiB)Downloaded 873 times
All you have to do for the above project is to replace the path of the driver prerequisite with the one downloaded on your machine.
Also conditions to check ODBC driver is install or not if not then install ODBC driver 13 automatically.
In what regards this (in this case, it is required that you add the ODBC driver as a "Feature-Based" prerequisite), you can use a "Search" or a custom action that will check if the ODBC driver is already installed and, based on that, condition the feature assigned to your "Feature-Based" prerequisite (the ODBC driver prerequisite) in "Organization" page.

One thing worth mentioning here:

For feature-based and post-install prerequisites, on below Enterprise project types only the "Full UI" install command line can be used and the prerequisite will be installed only if the main package is run with full UI. All other command line fields will be ignored and the prerequisite will not be installed if the main package is installed with silent or basic UI.

Hope this helps.

All the best,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

sumit1
Posts: 18
Joined: Thu Nov 29, 2018 3:40 pm

Re: How to install an ODBC connection 13 automatically

Tue Jan 08, 2019 12:44 pm

Thank You Catalin

It's working

Catalin
Posts: 6506
Joined: Wed Jun 13, 2018 7:49 am

Re: How to install an ODBC connection 13 automatically

Tue Jan 08, 2019 3:40 pm

You are always welcome.

I am glad I could help.

Kind regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

sumit1
Posts: 18
Joined: Thu Nov 29, 2018 3:40 pm

Re: How to install an ODBC connection 13 automatically

Wed Jan 09, 2019 1:37 pm

Hi

i have one question insted of \qn can i use qs\ like following sql silent UI.We tried this but not worked showing some error like prerequisite not instaled correctly

Sql Server Silent UI:

/QS /IACCEPTSQLSERVERLICENSETERMS=1 /Action=Install /Features=SQLENGINE /InstanceName=Localhost/SECURITYMODE=SQL /SAPWD=test /ADDCURRENTUSERASSQLADMIN=true /SQLSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE"



-Full UI: /qn IACCEPTMSODBCSQLLICENSETERMS=YES
-Basic UI: /qn IACCEPTMSODBCSQLLICENSETERMS=YES
-Silent (no UI): /qn IACCEPTMSODBCSQLLICENSETERMS=YES

Insted of Qn use Qs but not worked
-Full UI: /qs IACCEPTMSODBCSQLLICENSETERMS=YES
-Basic UI: /qs IACCEPTMSODBCSQLLICENSETERMS=YES
-Silent (no UI): /qs IACCEPTMSODBCSQLLICENSETERMS=YES
3.png
3.png (28.04KiB)Viewed 19642 times

Catalin
Posts: 6506
Joined: Wed Jun 13, 2018 7:49 am

Re: How to install an ODBC connection 13 automatically

Wed Jan 09, 2019 3:23 pm

Hello Sumit,

In order to achieve what you want, you can use the following command line:

Code: Select all

/passive IACCEPTMSODBCSQLLICENSETERMS=YES
This will have the same results as the "/qs" parameter passed to the "SQL Server" setup.

Hope this helps.

Kind regards,
Catalin
Catalin Gheorghe - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Feature Requests”