The app offers best evergreen collection of Latest and old Telugu movie Video songs. New telugu songs to download. Free Download Telugu Videos Android app.

• Odbc Driver Version List Of 1
• Microsoft Odbc Driver Versions
• Odbc Driver Version List Of Windows

I am a Database Developer and currently working in SQL Server Technology. I am trying to find out the ODBC driver name based on the installed SQL Server Version. Here is what I mean - Example,

In the list that displays, select the latest ODBC Driver for your platform and bit version. Download and install the drivers. Amazon Athena. ODBC Driver now includes the version number in the driver name when OCIATTRDRIVERNAME is set, such as ODBCCLNT: 12.2.0.1.0. (Bug 21795969) (Bug 21795969) Oracle ODBC driver truncated an output parameter of SP when run from 12.1.0.2. For Windows installations, you can download version 17.2 of the Microsoft ODBC Driver 17 for SQL Server here. Linux and macOS packages are also available. For installation details see the online instructions.

We are using SQLCMD.exe to execute some scripts through our custom MSI. SQLCMD fails if it doesn't find the correct ODBC driver. Hence we need to be able to identify the correct ODBC version based on the SQL version installed, so that we can check this before installation and prompt the user to install the correct ODBC version as a prerequisite.

I have already explored the below -

1. Windows Registry - I did not get a clear cut idea of how to identify ODBC drivers based on versions. ODBC drivers and SQL Server versions are mentioned at multiple places and either they do not match amongst themselves or with the installed SQL Server Version.
2. Admistrative Tools -> ODBC Admistrator -> Drivers TabSQL Server Version here do give some idea but we are unable to decode odbcad32.exe. Link - https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/check-the-odbc-sql-server-driver-version-windows?view=sql-server-2017

Odbc Driver Version List Of 1

If anyone knows anything then please render help. We need a solution using C# ( recommended ), however, if any other technology then we can have a look for its feasibility.

Thanks in advance.

1 Answer

Windows registry is the best way to go, I'm not sure why you're seeing inconsistencies. There are two main places to look:

For 64bit: HKEY_LOCAL_MACHINESOFTWAREODBCODBCINST.INIODBC Drivers

For 32bit: HKEY_LOCAL_MACHINESOFTWAREWOW6432NodeODBCODBCINST.INIODBC Drivers

If you want the specific version, you will need to go up a level into the registry keys that have the same name as those listed in ODBC Drivers. For exmaple, under ODBC Drivers you have the key 'ODBC Driver 17 for SQL Server' listed as installed, under ODBCINST.INI you will have a entry called 'ODBC Driver 17 for SQL Server' where you can find further details.

ODBC driver versions aren't intrinsically linked to the version of SQL installed. It's absolutely possible the ODBC driver has been updated separately, and/or multiple versions are installed.

Microsoft Odbc Driver Versions

Odbc Driver Version List Of Windows

Not the answer you're looking for? Browse other questions tagged sql-serverodbcdriver or ask your own question.