A User data source is only visible to the currently logged on user and is only available on the current machine. Socket Timeout Value sec: Once you have installed the driver, you must create and configure a data source. Sign up using Facebook. A File data source can be shared by all users who have the same drivers installed. Continue the installation, accepting the default values.

Uploader: Meztimi
Date Added: 12 February 2013
File Size: 35.94 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 35448
Price: Free* [*Free Regsitration Required]

General Inxtall Data Source Name: You will be prompted to configure a data source if you selected the “Configure a data source” check box as instructed above.

After you have selected New Database Query, you will be prompted to choose a data unstall. The ODBC version that we ships is a read-only version, so this box is dimmed. An ODBC driver is a tool an application uses to access a host database file. Type a unique name for the data source you are creating.

If it is not free to get odbc drivers, can you suggest any other way to connect to DB2 other than linked server? Sign up or log in Sign up using Google. The below link has a step by step guide that worked well for me http: HiT ODBC provides a way for you to run a self-test on your data source to make sure it is configured properly.


I need to access the database in the DB2 server. By clicking “Post Your Answer”, you acknowledge that you have read our istall terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

After deciding what type of data source you want, you will need to add it. Stack Overflow works best with JavaScript enabled. This launches Microsoft Query, if it is installed.

Cid 1, 1 14 Sign up using Facebook. Email Required, but never shown. Installs all ODBC files on a single client” option. Both answers are correct, but only have the links to were the answers are.

How To Set Up ODBC Connectivity To An AS/400

Create a new data source as described above. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

Don’t show this message again. To open odbc data sources in windows versions 7 upwards press the windows key type odbc click on the version you need 32 bit or 64 bit.

IBM Where are the ODBC drivers that access DB2/ on the iSeries? – United States

In the Setup Complete dialog box, verify that the “Configure a data source” check box is selected, and then click Finish. Data sources store information about how to connect to a particular database. For the remaining tabs Language, Performance, Security, DPC and Advancedaccept default values, unless you odbf a compelling reason to do otherwise.


Therefore, using the data source will depend on how the application works.

Installing and Configuring ODBC/400 LITE Drivers

A System data source is inetall to all users on this machine, including NT services. A User data source is only visible to the currently logged on user and is only available on the current machine. Socket Timeout Value sec: The translated version of this page is coming soon. Type a description for the data source.

sql server – How to install IBM db2 ODBC driver in Windows 7 – 64 bit? – Stack Overflow

Click Next, and then click Finish. One last prompt asks which knstall to put the data in, and then the data is inserted into your spreadsheet. Then, the next time you attempt to run a New Database Query, you will be prompted to install Microsoft Query.