Re: ODBC

FROM : Brian Weitzner
DATE : Mon Jul 24 23:37:32 2006

On Jul 23, 2006, at 9:23 PM, Scotty's Lists wrote:

>
> On Jul 21, 2006, at 5:31 PM, Brian Weitzner wrote:
>

>> Hi, I'm a student and I am new to cocoa programming.  For a 
>> project I am working on, I need to connect to, submit queries to 
>> and display the results of those queries of a database via an ODBC 
>> driver.  I'm having a lot of trouble finding documentation on 
>> this, but I can't imagine it's all that difficult.  Any help would 
>> be greatly appreciated.  Thank you.

>
> Brian,
>
> I've not had an opportunity to do any ODBC programming, but I have 
> used Google. :-)
>
> Mac OS X ships with the IODBC libraries in /usr/lib, headers in /
> usr/include.
>
> Take a look at <http://www.iodbc.org/index.php?page=docs/

> macosodbcstory/index> for more info on using them on Mac OS X.
>
> This might also be useful: <<http://docs.openlinksw.com/st/

> iodbcappsmacos.html#iodbcmacosx>
>
> I don't believe there is a native Cocoa API, but you can call into 
> the iODBC C libraries from Cocoa code without any trickiness.
>
> Objective-C is C with extensions to enable object-oriented 
> programming.  If you're not new to C, you'll already know how to 
> use C libraries in Cocoa; it's the same as using them from C or C++.
>
> Scotty
>
>


Please forgive me as I am new to both Cocoa and databases.  I am 
running firebird database.  So through terminal, I use:

$ isql
Use CONNECT or CREATE DATABASE to specify a database
SQL> connect 'DbPATH' user UID password PASSWD;

to connect to my database.  So in my project, in the class that is 
responsible for accessing the database, i have #include <isqlext.h> 
(which calls isql.h and iodbcunix.h) in the header and implementation 
files.  So if I use DbConn(db, UID, PASSWD), my app crashes.... which 
tells me that this is not the right command or I need to include more 
files.  So my question has now evolved into how do I use obj-C to 
communicate with my database?  Is there any documentation on how to 
accomplish this or has anyone had experience with this?  Thanks for 
the help and for your patience!

--
Brian Weitzner