This content has been marked as final. By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. There is a good internet resource regarding connectionstrings of all flavors: We are connecting to an AS iSeries 7. We’ve not given up hope yet. Thanks for your help! Go to original post.

Uploader: Zulukus
Date Added: 12 September 2009
File Size: 53.66 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 69145
Price: Free* [*Free Regsitration Required]

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

Sign up using Email and Password. I have setup a TDC file and change the driver attributes but no luck.

All available information indicates that all bit files are stored in System32 and all bit files are stored in SysWOW We can add filters to work sheets, etc.

We are connecting to an AS iSeries 7. One would think that the bit system files would go as4000 the System32 directory and the bit system files would go in the SysWOW64 directory. The best way to ensure that the correct DSN is created is to always use the ODBC Administration shortcuts that are created in the iSeries Access for Windows Program group because those shortcuts are properly labeled as either bit or bit.


The Osbc Out error message is: United States English English. Sign up or log in Sign up using Google. You can not post a blank message. That is not the way it works. You can have a.

AS iSeries with a DB2 ODBC-based dr |Tableau Community Forums

This had to be done on each desktop computer. We can extract data. I found it more useful than odbd IBM documentation. Please type your message and try again.

Put a filter on a Data source Directly. There is a good internet resource regarding connectionstrings of all flavors: This document contains information related to the bit version of the ODBC driver. This tool uses JavaScript and much of it will not work correctly without it enabled. Go to original post. It is recommended to install the V5R3M0 client using a merged PTF installation image rather than installing the base V5R3 client and then installing the service pack.

How To Set Up ODBC Connectivity To An AS/400

Stack Overflow works best with JavaScript enabled. Thanks for your help!


The version of the driver manager odbc We are lock with AS users. Here’s a great detailed description of what each keyword is and how you can configure them.

Sa400 Product Search Search. We’ve not given up hope yet.

Don’t have data server, so hasn’t quite worked out. CLIE Function sequence error.

This does not apply just to ODBC related files. Where can I find a list isefies all properties that can be set in the file DSN? When we do this, the query occurs and the connection either times-out or returns a record lock.