Re: ODBC

FROM : Brian Weitzner
DATE : Wed Jul 26 21:20:38 2006

On Jul 25, 2006, at 12:10 PM, Scotty's Lists wrote:

>
> On Jul 24, 2006, at 5:37 PM, Brian Weitzner wrote:
>

>> 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!

>
> Actual Technologies has a Carbon example app using the Mac iODBC 
> libraries.  They claim it's easy to translate into Cocoa/ObjC. 
> YMMV.  It should at least give you some clues on how to set up the 
> Xcode project (i.e. what libraries/frameworks to include, etc.).
>
> <http://www.actualtechnologies.com/example.php>
>
> I found this reference on the iodbc-macosx list at sourceforge. 
> You might find some other clues there.
>
> <http://sourceforge.net/mailarchive/forum.php?forum_id=38722>
>
> Finally, if you post the crash log from your app, or some other 
> relevant snippet from Xcode of the feedback you get from the crash, 
> you might make it more enticing for the list to follow up on your 
> question.  As it reads now, you're asking the list to help you 
> program obj-C, and I'm guessing no one has time to debug that one.
>
> -s
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Cocoa-dev mailing list      (<email_removed>)
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/cocoa-dev/<email_removed>
>
> This email sent to <email_removed>


I thought I'd give everyone an update thus far- it appears that my 
problem is in the fact that the database I need to use is a firebird 
database and we don't want to pay for a driver.  I found one for free 
but it requires me to be unixODBC and not iODBC.... and of course I 
have to build it from source and that doesn't compile correctly. 
Then I have to compile the driver from source- hopefully that will 
actually compile.  After I figure this mess out it should work. 
Thanks to everyone who helped!


--
Brian Weitzner