How To Find Odbc Driver Version In Windows

This tutorial explores how to install 32-fleck and 64-chip ODBC drivers in Windows ten and create a DSN for an ODBC data source.

• What is an ODBC commuter and a information source?
• Installing an ODBC driver for Windows x (32-bit and 64-bit)
• Configuring a DSN for an ODBC commuter in Windows ten (64-bit)
• Configuring a DSN for an ODBC driver in Windows ten (32-bit)
• Step-by-stride ODBC data source setup in Windows x

What is ODBC Commuter and Data Source?

Open Database Connectivity (ODBC) is a standard application programming interface that allows external applications to admission information from various database management systems. The ODBC interface provides for maximum interoperability – an application that is independent of any DBMS, tin access data in various databases through a tool called an ODBC commuter, which serves as an interface between an external program and an ODBC information source, i.e. a specific DBMS or cloud service.

The ODBC driver connection string is a parameterized string that consists of one or more name-value pairs separated by semi-colons. Parameters may include information almost the data source name, server address and port, username and countersign, security protocols, SQL dialects, and many more than. The required data is different depending on the specific driver and database. Here's an example of ODBC connectedness string:

DRIVER={Devart ODBC Driver for Oracle};Straight=True;Host=127.0.0.ane;SID=ORCL1020;User ID=John;Password=Doe

Devart ODBC Drivers are powerful connectors for a host of database management systems and deject services that allow you to connect to your information from near any third-party application or programming language that supports the ODBC API. By a third-party application, we mean tools like Ability BI, Tableau, Microsoft Excel, etc. See this page for the listing of external applications that have been tested for compatibility with our drivers.

Installing ODBC Driver for Windows ten

1. Run the downloaded installer file. If you already accept another version of the driver installed in the system, you will go a warning — clickYes to overwrite the quondam files, though it'southward recommended to first uninstall the onetime version. If this is the first time you lot install Devart ODBC commuter, but click Next.

2. Read and accept the license agreement, and then click Next.

three. Select the installation directory for the ODBC commuter and click Adjacent.

4. In the Select Components tab, select which version of the driver to install (64-flake / 32-bit), and whether to include the help files.

5. Confirm or change the Kickoff Menu Folder and click Next.

6. Input your activation primal or choose Trial if you want to evaluate the product before getting a license. You lot tin load the activation central past clicking on the Load Activation Primal… button and selecting the license file from your machine. Click Next so Install.

seven. After the installation is completed, click Finish.

Configuring a DSN for ODBC Driver in Windows 10 (64-scrap)

Earlier connecting a tertiary-party awarding to a database or cloud source through ODBC, yous need to gear up upward a data source name (DSN) for the ODBC driver in the Data Source Administrator. A 64-bit version of the Microsoft Windows operating system includes both the 64-bit and 32-bit versions of the Open Database Connectivity (ODBC) Data Source Administrator tool (odbcad32.exe):

• The 32-bit version of odbcad32.exe is located in the C: \Windows\SysWoW64 folder.
• The 64-bit version of odbcad32.exe is located in the C: \Windows\System32 folder.

i. In your Windows Search bar, type ODBC Data Sources. The ODBC Data Sources (64 scrap) and ODBC Information Sources (32 bit) apps should appear in the search results.

Alternatively, yous can open the Run dialog box by pressing Windows+R, type odbcad32 and click OK.

Yet some other style to open the ODBC Data Source Administrator is via the command prompt: enter cmd in the search bar and click the resulting Control Prompt button. Enter the command odbcad32 and hit Enter.

2. Since most modern computer architectures are 64-scrap, we'll select the 64-bit version of the ODBC Data Source Administrator to create a DSN for our ODBC commuter. The odbcad32.exe file displays two types of information source names: System DSNs and User DSNs. A User DSN is only accessible to the user who created information technology in the system. A System DSN is accessible to any user who is logged in into the arrangement. If you don't want other users on the workstation to admission your data source using the DSN, choose a User DSN.

iii. In the administrator utility, click on theAdd button. The Create New Data Source dialog box will display the list of installed ODBC drivers in the system. Choose the needed driver from the list. The option of the driver is determined by the data source you are trying to connect to — for example, to access a PostgreSQL database, cull Devart OBDC Commuter for PostgreSQL. Click Stop.

iv. Enter a name for your data source in the corresponding field. Fill in the parameters for the ODBC connection string, which is driver-specific. In most of our ODBC drivers for databases, a connection string with basic parameters requires the user to only input their server address, port number, and login credentials, since Devart ODBC drivers allow direct access to the database without involving additional client libraries.

five. Click Exam Connection to verify connectivity. If you lot see the Connection Successful message, click OK to save the DSN. You should now see your new DSN in the User DSN tab of the ODBC Data Source Administrator tool.

Configuring a DSN for ODBC Driver in Windows 10 (32-bit)

The steps for configuring an ODBC DSN for a 32-bit driver are practically the aforementioned every bit for the 64-bit driver, except for the footstep where yous select the 32-flake version of the ODBC Data Source Ambassador. Running the odbcad32 command in the Command Prompt or in the Run dialog box will start the 64-bit version of the ODBC administrator on the 64-bit Windows past default, therefore your all-time option is to select the 32-bit version of the administrator in the search results of the Windows search box.

Note though that if you have both versions (32-bit and 64-bit) of the commuter installed and y'all have configured a User DSN (in contrast to a System DSN), y'all will be able to use the same DSN for 32-bit and 64-bit applications (run across the Platform column in the screenshot below).

In a situation where you need to use an application that is available only in 32-fleck, the 32-bit ODBC driver does the trick. An example is Apache OpenOffice, which is distributed as a 32-chip application.

Pace-past-stride ODBC Information Source Setup in Windows 10

1. Printing Windows + R to open the Run dialog.
2. Type in odbcad32 and click OK.
3. In the ODBC Data Source Administrator dialog box, select the System DSN or User DSN tab.
4. Click Add together. The Create New Data Source dialog box should announced.
5. Locate the necessary driver in the listing and click Finish.
6. In the Information Source Name and Clarification fields, enter the name and a description for our ODBC information source, respectively.
7. Make full in the commuter-specific connection string parameters, such as server address, port, username, password, etc.
8. Click Test Connection to verify connectivity.
9. Click OK to relieve the DSN.

If you would like to test our ODBC connectors, visit the ODBC drivers page.

• Writer
• Recent Posts

how to, odbc

Source: https://blog.devart.com/installing-odbc-driver-and-creating-data-source-on-windows.html

Posted by: nunezhurasawends89.blogspot.com

Share this post