IBM Server Site

IBS Home Up

ODBC Help & Support

What is ODBC?

  • ODBC is the acronym for Open DataBase Connectivity, a Microsoft Universal Data Access program. This is the software that

IBS ODBC Policy

  • Please note that ODBC is not an IBS Corporation software product! You must setup and configure ODBC yourself if you want to pull data via MS Excel or MS Word to the system.
Setting up an ODBC Connection to an AS/400 Database

After you set up client access and make sure that you install the ODBC driver, click on START, SETTINGS, CONTROL PANEL. If you don’t see ”Data Sources (ODBC)” on the first screen, but see “ADMINISTRATIVE TOOL”, click on ADMINISTRATIVE TOOLS, then DATA SOURCES(ODBC).

Click Add

Click Finish

Click Apply

Then click OK..Now you should be able to connect to the database. On the above screen, if you want READ ONLY rights, make sure you click the read only option.

IBS Lumber and Building Material Software Copyright © 2006 IBS Lumber Software Inc (TM)
Last modified: November 7, 2011

IBS Sales & Support 888-640-1252
Main Office 888-640-1252
Fax IBS 877-712-8937

All pages contained in this support website are not intended for general public distribution. Any material here can be considered private, confidential with various copyrights and restrictions against public release. You 'the browser' cannot legally release this information for general public distribution.

remote support: http://www.gotomeeting.com | remote support download program