See response below
I'd be happy to assist
In a word yes. As long as you have the ODBC Administrator installed,
you can then install the Oracle 8i driver configured to connect to
your remote server. The application then initialises the ODBC
administrator which in turn will call on the ODBC Driver which will
then make the connection.
Application - ODBC Administrator (Datasource) - ODBC Driver - Database
If you want to write your own ODBC compliant application, you don't
necessarily need the ODBC administrator as you can build your
application with the ODBC SDK directly.
As you're using the odbcsdk, you should find an ODBCTEST tool
available which allows you to test simple sql statements. Also when
you install the ODBC driver, you can test the connection.
iODBC is actually an affiliate of OpenLink Software but its our open
source arm. If you need any more assistance, please don't hesitate to
ask. There are two types of ODBC drivers as well.
Why not check this reference source out, you might find it answers a
also send you our article on the "Mac and ODBC story", let me know if
you need this