1iodbctest(1)                 iODBC Driver Manager                 iodbctest(1)
2
3
4

NAME

6       iodbctest, iodbctestw - iODBC Demonstration programs
7
8

SYNOPSIS

10       iodbctest ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]
11       iodbctestw ["DSN=xxxx[;UID=xxxx][;PWD=xxxx][;OPT=value]"]
12
13

DESCRIPTION

15       The  iodbctest  program  and  iodbtestw programs are simple ODBC sample
16       programs, showing the strength of the ODBC API to connect to  any  ODBC
17       enabled database, issue SQL commands and retrieve the query results.
18
19       The iodbctest program uses the standard ODBC API calls to connect using
20       any DSN, but retrieves all results in ASCII mode.
21
22       The iodbctestw program uses the ODBC Unicode API calls to connect using
23       any DSN, and retrieves all results in Unicode mode.
24
25

OPTIONS

27       The iodbctest program uses the SQLDriverConnect function to make a con‐
28       nection using any available ODBC compliant driver. This allows the user
29       to override any ODBC connect attribute in the DSN string.
30
31       Connect  strings  should  start  with either a DSN=xxx or a DRIVER=xxxx
32       attribute optionally followed by other DSN attributes  separated  by  a
33       semicolon e.g:
34
35            DSN=ora9;UID=scott;PWD=tiger;DATABASE=ora9u
36
37       Any attributes required for a proper connection that are not entered in
38       the DSN connect string, must be present in the odbc.ini file.
39
40       If the connect string is passed as an argument to  the  iodbctest  pro‐
41       gram,  the  string should be quoted as most shells use the semicolon as
42       their command separator. If the connect string is entered on the inter‐
43       active prompt, no quotes should be used.
44
45       After  a  successful  connection  has  been  established,  the  user is
46       prompted for a SQL command to be send to the database.  A  SQL  command
47       cannot span multiple lines.
48
49       If  the SQL command returns one or more result sets, each result set is
50       fetched using character buffers and displayed in a table.
51
52       Additionally, the iodbctest program understands a few special commands:
53
54
55       qualifiers
56               Show a list of qualifiers using the SQLTables catalog call.
57
58
59       owners
60               Show a list of owners using the SQLTables catalog call.
61
62
63       tables
64               Show a list of tables using the SQLTables catalog call.
65
66
67       types
68               Show a list of tables types using the SQLTables catalog call.
69
70
71       datatypes
72               Show a list of data  types  using  the  SQLGetTypeInfo  catalog
73               call.
74
75
76       reconnect
77               Perform  a disconnect/reconnect with the information saved dur‐
78               ing the first SQLDriverConnect.
79
80
81       quit (or exit)
82               Exit the program and return to the shell.
83
84

EXAMPLES

86       Start the iodbctest program and get a list of DSNs before making a con‐
87       nection:
88
89           $ iodbctest
90           OpenLink ODBC Demonstration program
91           This program shows an interactive SQL processor
92
93           Enter ODBC connect string (? shows list): ?
94
95           DSN                              | Driver
96           -----------------------------------------------------------------
97           ora9                             | OpenLink Generic ODBC Driver
98           mysql                            | OpenLink Generic ODBC Driver
99           mysqllite                        | OpenLink Lite for MySQL
100           myodbc                           | MyODBC Driver
101           pgsql                            | OpenLink Generic ODBC Driver
102           tds                              | OpenLink Generic ODBC Driver
103
104           Enter ODBC connect string (? shows list): DSN=ora9;PWD=tiger
105           Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)
106
107           SQL>
108
109       Connect  to an Oracle 9 instance which has been previously setup in the
110       odbc.ini file:
111
112           $ iodbctest "DSN=ora9;UID=scott;PWD=tiger"
113           iODBC Demonstration program
114           This program shows an interactive SQL processor
115           Driver: 05.20.0316 OpenLink Generic ODBC Driver (oplodbc.so)
116
117           SQL>select * from emp
118
119           ID               |NAME
120           -----------------+-------------------------------------------
121           1                |Record 1
122           2                |Record 2
123           2                |Record 3
124
125            result set 1 returned 3 rows.
126
127           SQL> quit
128
129
131       Copyright © 1996-2016 by OpenLink Software
132
133

AUTHOR

135       iODBC Administrator <iodbc@openlinksw.com>
136
137
138
1393.52.12                          3 August 2005                    iodbctest(1)
Impressum