iodbctest(1)

💖 iodbctest(1) — iODBC Driver Manager 💖

okay bestie, so you know how the manual name is iODBC Driver Manager? yeah. that's the whole vibe here. welcome to the demo programs, they're iconic, they're little, they slay 💅

---

✨ NAME ✨

iodbctest, iodbctestw — iODBC Demonstration programs

no cap, that's literally it. two lil demo besties.

---

🌸 SYNOPSIS 🌸

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

---

🦋 DESCRIPTION 🦋

So. iodbctest and iodbctestw? They're simple ODBC sample programs. And the way they exist is to show off the strength of the ODBC API — like, connecting to literally any ODBC enabled database, issuing SQL commands, and pulling back the query results. main character energy fr fr 👑

Here's the tea on the difference:

• iodbctest uses the standard ODBC API calls to connect using any DSN — but it retrieves all results in ASCII mode.
• iodbctestw uses the ODBC Unicode API calls to connect using any DSN — and it retrieves all results in Unicode mode. ✨

---

💅 OPTIONS 💅

iodbctest uses the SQLDriverConnect function to make a connection using any available ODBC compliant driver. Which is huge, because it lets you override any ODBC connect attribute in the DSN string. periodt.

Connect strings should start with either a DSN=xxx or a DRIVER=xxxx attribute, optionally followed by other DSN attributes separated by a semicolon. like, for example:

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

Any attributes required for a proper connection that you did not enter in the DSN connect string must be present in the odbc.ini file. no skipping, bestie, the file has to have them 🙈

Now, quoting rules, listen up:

• If the connect string is passed as an argument to the iodbctest program, the string should be quoted, because most shells use the semicolon as their command separator. (semicolons are little menaces honestly 😭)
• If the connect string is entered on the interactive prompt, no quotes should be used.

Once a successful connection has been established, the user is prompted for a SQL command to be sent to the database. And heads up — a SQL command cannot span multiple lines. one line only, keep it cute 💖

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

---

🫶 Special commands, iykyk 🫶

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. bye bestie 👋

---

🌈 EXAMPLES 🌈

🍓 Example the first: get a list of DSNs before making a connection

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>

⭐ Example the second: connect to an Oracle 9 instance

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-2023 OpenLink Software

---

🧚 AUTHOR 🧚

iODBC Administrator <iodbc@openlinksw.com>

---

and that's the whole page bestie, no notes, we ate 💅✨

version 3.52.16 · dated 3 August 2005 · kisses from the iODBC Driver Manager crew, mwah 🫶💖