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
connection 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 program,
the string should be quoted as most shells use the semicolon as their command
separator. If the connect string is entered on the interactive 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 during 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 connection:
$ 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-2014 by OpenLink Software
AUTHOR¶
iODBC Administrator <iodbc@openlinksw.com>