ODBC newbie needs help

ODBC newbie needs help

Post by esimb » Thu, 03 Jul 2003 01:27:49


Hi Tim

See response below



I'd be happy to assist

That's correct


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
few questions

http://www.yqcomputer.com/
also send you our article on the "Mac and ODBC story", let me know if
you need this

BR
Emmon
 
 
 

ODBC newbie needs help

Post by Benjamin R » Thu, 03 Jul 2003 01:47:50

Hi Tim,


XXXX@XXXXX.COM (Tim Rodgers) writes:

You got the idea.


There probably is. If you can't find one, you can always just write a
short helloworld-type program.


I'm not sure what OpenLink provides. I have used the ODBC libraries
and includes as they come with the Developer Tools and that has worked
for me. I only had to fiddle a bit with the actual names of the
include files, as the application that I was compiling didn't
recognise the exact configuration automatically.


Hope this helps, benny