test

Solaris 7 Sun Hardware Platform Guide

Open Data Base Connectivity (ODBC) Driver Manager

ODBC is an open database connectivity standard for data access. The InterSolv DataDirect ODBC Driver Manager allows you to access the ODBC API interface. The driver manager determines the appropriate database requests from client applications, loads the ODBC database drivers, and routes ODBC function calls to the drivers. In addition to the DataDirect ODBC Driver Manager, you need ODBC drivers to provide the critical link between your ODBC-compliant client/server applications and your database.

Note -

The ODBC Driver Manager is not a Sun Microsystems Inc. supported product. ODBC Driver Manager is a product of InterSolv. For all technical questions or support please contact InterSolv.

For support questions or information about the ODBC Drivers, contact Intersolv at sunsoft@intersolv.com or through one of the following phone numbers:

The mailing address is: InterSolv, 9420 Key West Avenue, Rockville, Maryland, 20850, USA.

Further information is available at http://www.intersolv.com.

ODBC is a standard for data access from Microsoft and X/Open. Databases supporting ODBC include Clipper, dBASE, FoxBase, FoxPro, INFORMIX, INGRES, Microsoft SQL Server, Oracle, Sybase System 10, Sybase SQL Server, and Sybase NetGateway to DB2 and other databases, and ASCII text files.

The Supplement CD includes a demo version of the InterSolv ODBC dBASE driver. This demo software can display only 30 records and process 100 SQL statements, but is otherwise fully functional.

InterSolv ODBC Clusters and Packages

Table 3-2 provides a list of InterSolv ODBC packages provided on the Supplement CD.

Table 3-2 InterSolv ODBC Clusters and Packages

Cluster Name 

Includes Cluster/Package 

Description 

SUNWCodbc 

ISLIodbc 

ODBC (Open DataBase Connectivity) Driver Manager 

 

 

ISLIodbcD

Demo ODBC (Open DataBase Connectivity) Mutli-Dialect dBASE Driver 

Installing InterSolv ODBC Software

To install the InterSolv ODBC software, follow these steps:

  1. Start CDE or OpenWindows.

  2. Insert the Supplement CD into your CD-ROM drive.

    The File Manager window is displayed.

  3. Open a command window and become superuser using the su command and superuser password.

  4. Enter the swmtool command at the # prompt: 

    # /usr/sbin/swmtool

    The Admintool:Software window is displayed.

  5. Select Add from the Edit Menu.

    The Admintool:Set Source Media window is displayed.

  6. Type 

    # cd /cdrom/cdrom0/Product

    The Admintool:Add Software window is displayed.

  7. In the Admintool:Add Software window, select ODBC Driver Manager Software 2.11.

    This will install the SUNWCodbc cluster, which includes both the driver manager package (ISLIodbc) and the demo dBASE driver package (ISLIodbcD).

  8. Click the Customize option if you want to select only one of these packages or change the destination directory from /opt.

    The Admintool:Customize Installation window appears. When you have made the choices you want, click the Add option to return to the Admintool: Add Software window.

  9. In the Admintool:Add Software window, click Add.

    The installation process should take a few minutes. You'll need to respond to prompts to install each InterSolv package you've selected. This message window is closed when installation is complete.

  10. Quit the Admintool:Software window.

Using InterSolv ODBC Software

To use InterSolv ODBC software, refer to the PostScript files installed in the /opt/ISLIodbc/2.11/doc directory. For further details on the driver manager and the demo dBASE driver, refer to the man pages for odbc.ini and qedbf installed in the /opt/ISLIodbc/2.11/man/man4 directory. Also refer to the comments about installation on your system in the /opt/ISLIodbc/2.11/install.log file.