Testing ODBC DSNs on Mac OS X, with iODBCTest This is a simple 'C' based and ODBC compliant Interactive SQL processor. Launch iODBCTest by double-clicking the iODBC Test.command script found in /Applications/iODBC/. Alternatively, you can open a Terminal session, and execute this command: "/Applications/iODBC/iODBC Test.command" When prompted for a connect string, you can enter "?" to see a list of ODBC DSNs on your machine, or immediately enter a valid ODBC Connect String following the form -- DSN=<dsn name>[;UID=<username>[;PWD=<password>]][;<connect string attribute>=<value>] If you have an Oracle DSN named "Marketing", you might enter: DSN=Marketing;UID=scott;PWD=tiger Note: If there is a username but no password, you must include a semicolon at the end: DSN=Marketing;UID=sa;PWD=; Once connected, any valid SQL or ODBC command may be executed through this interface. You can also call on several built-in functions, which interrogate the back-end for -- datatypes owners qualifiers tables types The following example shows a connection to Microsoft SQL Server 2000, making a simple query against the sample Northwind database: [localhost:~] openlink% /Library/iodbc/bin/odbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list, or DSN=...): DSN=northwind;UID=sa;PWD=admin SQL>select au_lname, au_fname, state from authors where au_id < '333-33-3333' au_lname |au_fname |state ----------------------------------------+--------------------+----- White |Johnson |CA Green |Marjorie |CA Carson |Cheryl |CA O'Leary |Michael |CA Straight |Dean |CA 5 row(s) fetched. SQL>quit Again (y/n) ? n Have a nice day. [localhost:~] openlink%