Troubleshooting

The Microsoft ODBC Desktop Database Drivers are a Microsoft Jet-based set of ODBC drivers. Whereas Microsoft ODBC Desktop Database Drivers 2.0 include both 16-bit and 32-bit drivers, versions 3.0 and later include only 32-bit drivers.

Problem

IBM iSeries Access for Windows provides both a 32-bit and 64-bit ODBC driver. This document contains information related to the 64-bit version of the ODBC driver.

Resolving The Problem

IBM iSeries Access for Windows provides both a 32-bit and 64-bit ODBC driver. The 64-bit ODBC driver is automatically installed along with the 32-bit ODBC driver when running under a 64-bit version of Microsoft Windows. ODBC applications running in 64-bit versions of Windows will automatically use the appropriate ODBC driver, depending on whether the application was compiled as 32-bit or 64-bit.
Microsoft provides the following versions of the ODBC Administrator: 32-bit and 64-bit. Both versions are named odbcad32.exe (there is no odbcad64.exe). Both versions can be accessed from the iSeries Access for Windows folder.
64-bit Windows has the familiar C:WindowsSystem32 directory, and it also has a C:WindowsSysWOW64 directory that serves a similar function as a repository for system files. That seems straight-forward. One would think that the 32-bit system files would go in the System32 directory and the 64-bit system files would go in the SysWOW64 directory. That is not the way it works. Some things in 64-bit Windows are the opposite of what you would expect. The windowssystem32odbcad32.exe is really the 64-bit ODBC Administrator. The windowsSysWOW64odbcad32.exe is the 32-bit ODBC Administrator.
Note: All available information indicates that all 64-bit files are stored in System32 and all 32-bit files are stored in SysWOW64. This does not apply just to ODBC related files.
Similarly, the 64-bit ODBC driver that is installed with iSeries Access for Windows on a 64-bit Windows PC is windowssystem32cwbodbc.dll and the 32-bit driver is windowsSysWOW64cwbodbc.dll. The driver name in both cases is iSeries Access ODBC Driver. The version of the driver manager (odbc32.dll) determines to which driver the ODBC calls get routed.
When running on 64-bit Windows, User DSNs will work with either driver. System DSNs that are created with 64-bit ODBC Administrator will only work with the 64-bit Driver. System DSNs that are created with the 32-bit ODBC Administrator will only work with the 32-bit driver. 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 32-bit or 64-bit.
The version information for the iSeries Access for Windows 64-bit ODBC contains the number 64, so it is easily identifiable. The format for the version information for Windows 32-bit or 64-bit iSeries Access for Windows ODBC driver is: aa.bb.dd.dd, where aa corresponds with the version of iSeries Access for Windows (V5R3 is 10, V5R4 is 11, and so on), bb is 0 (32-bit) or 64 (64-bit), cc is the service pack (SP) version (SP1 is 1, SP2 is 2, and so on), dd is a special fix version number (always 0 except in cases where a particular patch has been provided).
Restrictions of the 64-bit iSeries Access for Windows ODBC Driver:
Microsoft Transaction Server (MTS) is not supported on the 64-bit iSeries Access for Windows ODBC driver. For additional Information about MTS, refer to the link Use Microsoft Transaction Server (MTS) in the iSeries V5R4 InfoCenter.
Prior to V6R1 System i Access for Windows, only the Intel Itanium 64-bit processor family is supported for ODBC SSL connections. At V6R1 System i Access for Windows, support was added to include ODBC SSL connection support for the AMD 64-bit processor family. This restriction is documented in the V5R4 Information Center.
http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzaij/rzaijwhatsnew.htm
Versions of iSeries Access for Windows that are supported when running on 64-bit Windows:
iSeries Access for Windows V5R4M0 and iSeries Access for Windows V5R3M0 with service pack PTF SI17742 (or later) are supported when running on 64-bit Windows. Client Access Express V5R1M0 with Service Pack SI11806 might install on 64-bit Windows and iSeries Access for Windows V5R2M0 with Service Pack SI18400 (or later) usually will install on 64-bit Windows. Some functions might work with the earlier versions, but no support is provided for these environments. 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. Refer to the readmesp.txt file that comes with the service pack from the FTP server for instructions on how to create a merged installation image:
ftp://ftp.software.ibm.com/as400/products/clientaccess/win32/v5r3m0/servicepack/si24723/readmesp.txt
Refer to the iSeries Access for Windows home page section titled Microsoft Windows Operating Systems and iSeries Access.

Document Information

Modified date:
18 December 2019

Downloads Realtek PCIe FE / GbE / 2.5GbE / Gaming Family Controller Software Quick Download Link Realtek USB FE / GbE / 2.5GbE / Gaming Family Controller Software Quick Download Link. Realtek Below are the driver packages to install various wireless devices including Realtek chips on Real Macintosh & Hackintosh machines on Mac OS 10.9 t o10.15 Caralina. Please visit the git hub for these devices here (real mac) and here (Hackintosh) for more information and support. REALTEK DTV USB DEVICE is a Shareware software in the category Audio & Multimedia developed by Audio Realtek. It was checked for updates 785 times by the users of our client application UpdateStar during the last month. The latest version of REALTEK DTV USB DEVICE is currently unknown. It was initially added to our database on. The problem getting it to work with Win10 is that default Device Installation Realtek dtv usb device allows Windows to install or update with wrong drivers. Adressbars in browsers and devicw that 90’s stuff Thanks for all your suggestions but I have tried every one of them already. If it still persists, we would be happy to help you further. Realtek usb drivers.

ISAM ODBC Driver.The Easysoft ODBC-ISAM Driver makes your ISAM data fully accessible from SQL, making it easy for end users to retrieve, update and analyse the data. Our customers have found that our ISAM ODBC driver offers them the best solution for formatting and analysising data, and delivering it into a vast array of applications.In the unlikely event that you need help with the installation of this driver then our support team is on hand to assist you. ODBC Driver for C-ISAM and D-ISAM FilesThe Easysoft ODBC-ISAM Driver provides relational, real-time, read/write access to C-ISAM and D-ISAM data for ODBC-enabled applications on Windows, UNIX and Linux. The Easysoft ODBC-ISAM Driver makes your ISAM data fully accessible from SQL, making it easy for end users to retrieve, update and analyse the data. Our customers have successfully used the Easysoft ODBC-ISAM Driver to:.

Analyse, format and deliver ISAM data in Microsoft Excel, Crystal Reports and BusinessObjects. Provide a user friendly, graphical interface to ISAM data by developing custom front ends in programming languages such as Microsoft Visual Basic, C, C# and Borland Delphi. Publish ISAM data in web pages by accessing ISAM files through ODBC from PHP/ Perl/ ASP running under a web server.Indexed Sequential Access Method (ISAM) data is organized into records that are stored sequentially in ISAM files. An index file is used to store key values that identify each record along with pointers that locate the corresponding record in the database.

This speeds up data retrieval because individual records can be retrieved without having to search the entire data set. Because ISAM provides fast and cost-effective access to data without the overhead of an relational database management system (RDBMS), ISAM continues to be a viable solution for many companies.The Easysoft ODBC-ISAM Driver reads the ISAM file definitions from an Easysoft schema file; your ISAM files and applications remain unchanged. You create the schema with the Easysoft Administrator, an easy to use, graphical, administration program provided with the driver.The Easysoft ODBC-ISAM Driver supports Informix C-ISAM and Byte Designs DISAM file systems. Relational Access to C-ISAM and D-ISAM Data. SQL access Query and update your ISAM data by using SQL. Retrieve information from multiple ISAM files at once by using joins. Use SQL to create tables, the corresponding ISAM files do not have to exist, they will be created as required.

Efficient data retrieval If your ISAM files are remote, reduce expensive network traffic by using SQL to filter data at the server so that only the minimum data required is returned to the application. Protect sensitive data Use views to restrict what columns or rows users can see. Integration with relational databases Integrate non-relational ISAM data with relational databases such as Microsoft SQL Server and Microsoft Access.

For example, create a linked server in SQL Server to access your ISAM data and then take advantage of features available in SQL Server such as stored procedures.Remote ODBC/JDBC Access to C-ISAM and D-ISAM Data. Cross-platform ODBC access If your ISAM files and ODBC-enabled applications are on different machines, connect your applications to your remote ISAM data by combining the Easysoft ODBC-ISAM Driver with the. This solution has enabled our customers to access ISAM files on UNIX and Linux from Windows applications such as Visual Basic, SQL Server, Access and Excel. Cross-platform JDBC access For cross-platform JDBC access to remote ISAM files from Java, use the Easysoft ODBC-ISAM Driver with the.SQL Optimisation. Query optimisation The Easysoft ODBC-ISAM Driver automatically analyses queries to determine whether the SQL can be transformed into equivalent but better performing SQL.

The transformed query returns the same results as the original query but can be processed more efficiently. Indexes The Easysoft ODBC-ISAM Driver takes advantage of indexes set on the tables in a query to increase performance. If necessary, the Easysoft ODBC-ISAM Driver rearranges the order in which tables are processed to enable an index to be used.Administration and Security.

Easy configuration The Easysoft Administrator provides a simple to use, graphical interface that lets you populate the schema necessary to describe the structure of your ISAM data. User-level security Control access to your ISAM data by creating user accounts that define who can access each table and whether the data is read-only. You can also limit what columns or rows a user can access by creating views.ISAM Features. Integration with ISAM applications You can continue to use your existing applications to read and update ISAM data.