iodbctest man page on Slackware

Man page or keyword search:  
man Server   14563 pages
apropos Keyword Search (all sections)
Output format
Slackware logo
[printable version]

iodbctest(1)		     iODBC Driver Manager		  iodbctest(1)

NAME
       iodbctest, iodbctestw - iODBC Demonstration programs

SYNOPSIS
       iodbctest ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]
       iodbctestw ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]

DESCRIPTION
       The  iodbctest  program	and  iodbtestw programs are simple ODBC sample
       programs, showing the strength of the ODBC API to connect to  any  ODBC
       enabled database, issue SQL commands and retrieve the query results.

       The iodbctest program uses the standard ODBC API calls to connect using
       any DSN, but retrieves all results in ASCII mode.

       The iodbctestw program uses the ODBC Unicode API calls to connect using
       any DSN, and retrieves all results in Unicode mode.

OPTIONS
       The iodbctest program uses the SQLDriverConnect function to make a con‐
       nection using any available ODBC compliant driver. This allows the user
       to override any ODBC connect attribute in the DSN string.

       Connect	strings	 should	 start	with either a DSN=xxx or a DRIVER=xxxx
       attribute optionally followed by other DSN attributes  separated	 by  a
       semicolon e.g:

	    DSN=ora9;UID=scott;PWD=tiger;DATABASE=ora9u

       Any attributes required for a proper connection that are not entered in
       the DSN connect string, must be present in the odbc.ini file.

       If the connect string is passed as an argument to  the  iodbctest  pro‐
       gram,  the  string should be quoted as most shells use the semicolon as
       their command separator. If the connect string is entered on the inter‐
       active prompt, no quotes should be used.

       After  a	 successful  connection	 has  been  established,  the  user is
       prompted for a SQL command to be send to the database.  A  SQL  command
       cannot span multiple lines.

       If  the SQL command returns one or more result sets, each result set is
       fetched using character buffers and displayed in a table.

       Additionally, the iodbctest program understands a few special commands:

       qualifiers
	       Show a list of qualifiers using the SQLTables catalog call.

       owners
	       Show a list of owners using the SQLTables catalog call.

       tables
	       Show a list of tables using the SQLTables catalog call.

       types
	       Show a list of tables types using the SQLTables catalog call.

       datatypes
	       Show a list of data  types  using  the  SQLGetTypeInfo  catalog
	       call.

       reconnect
	       Perform	a disconnect/reconnect with the information saved dur‐
	       ing the first SQLDriverConnect.

       quit (or exit)
	       Exit the program and return to the shell.

EXAMPLES
       Start the iodbctest program and get a list of DSNs before making a con‐
       nection:

	   $ iodbctest
	   OpenLink ODBC Demonstration program
	   This program shows an interactive SQL processor

	   Enter ODBC connect string (? shows list): ?

	   DSN				    | Driver
	   -----------------------------------------------------------------
	   ora9				    | OpenLink Generic ODBC Driver
	   mysql			    | OpenLink Generic ODBC Driver
	   mysqllite			    | OpenLink Lite for MySQL
	   myodbc			    | MyODBC Driver
	   pgsql			    | OpenLink Generic ODBC Driver
	   tds				    | OpenLink Generic ODBC Driver

	   Enter ODBC connect string (? shows list): DSN=ora9;PWD=tiger
	   Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)

	   SQL>

       Connect	to an Oracle 9 instance which has been previously setup in the
       odbc.ini file:

	   $ iodbctest "DSN=ora9;UID=scott;PWD=tiger"
	   iODBC Demonstration program
	   This program shows an interactive SQL processor
	   Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)

	   SQL>select * from emp

	   ID		    |NAME
	   -----------------+-------------------------------------------
	   1		    |Record 1
	   2		    |Record 2
	   2		    |Record 3

	    result set 1 returned 3 rows.

	   SQL> quit

COPYRIGHT
       Copyright © 1996-2009 by OpenLink Software

AUTHOR
       iODBC Administrator <iodbc@openlinksw.com>

3.52.7				 3 August 2005			  iodbctest(1)
[top]
                             _         _         _ 
                            | |       | |       | |     
                            | |       | |       | |     
                         __ | | __ __ | | __ __ | | __  
                         \ \| |/ / \ \| |/ / \ \| |/ /  
                          \ \ / /   \ \ / /   \ \ / /   
                           \   /     \   /     \   /    
                            \_/       \_/       \_/ 
More information is available in HTML format for server Slackware

List of man pages available for Slackware

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net