Before you install the driver, execute the following command:. The output of. If you need to specify an install command bin-dir or lib-dir , specify the command after the install option. After reviewing the license agreement, type YES to continue with the installation. The driver needs to load the resource file to function. This file is called msodbcsqlr The location of the.
As of version For more information, see the ODBC driver release notes and system requirements. Skip to main content. This browser is no longer supported. Download Microsoft Edge More info. This is one of those questions that end up driving us crazy. Surely one of those classes will return a list of installed drivers, right?
But none of the WMI classes seem to return that information, at least not directly. There might be a convoluted way of getting at this information, but we Scripting Guys try to avoid convoluted ways whenever possible. All hope seemed lost, but then one of the Scripting Guys decided to apply the Upstairs Closet theory to the problem. Oddly enough, we also found a pair of shoes, that jacket that we always liked, and a hacksaw that disappeared 5 or 6 years ago. As soon as we knew we could get this information out of the registry it was easy to write a script that retrieved a list of all the installed ODBC drivers:.
As it turns out, the installed ODBC drivers are stored as individual registry values within this registry key, something like this:. This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No.
As Microsoft Office provides drivers that you can use to retrieve data from the following data sources list:. For more detail you can refer to: Use Microsoft Query to retrieve external data. If you want to use data source drivers from other manufacturers to retrieve information from data sources that are not listed here, you can contact your database vendor to get and install specific ODBC driver.
Was this reply helpful? Yes No. Sorry this didn't help. Thanks for your feedback. I have the same question
0コメント