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:
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
