Mailing Lists: Apple Mailing Lists
 Image of Mac OS face in stamp
Re: Newbie: Cocoa App accessing SQL Server DB
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Newbie: Cocoa App accessing SQL Server DB

On Sat, Jul 03, 2004 at 08:44:50PM -0400, Itamar Hassin wrote:
> Could someone please point me to the right website/document that
> explains how to be able to connect to SQL Server (2000) and open record
> sets like one would do using ADO and VB? Any other programming model is
> also good as long as I can run stored procedures and retrieve
> "recordsets".

Two options I can think of:

FreeTDS - <http://www.freetds.org/> provides several APIs; I've got
FreeTDS's version of isql to compile on OS X, so its native API should
work, but never had any success with the ODBC driver (however I have
gotten it to work on Linux); you may do better with a different driver
manager from the one Apple provides if you want to use ODBC.

Use JDBC with a SQL Server JDBC driver, such as the one Microsoft
provides. You can either use the Java bridge to access it directly,
or the easyDB Framework:

<http://www.macosguru.de/download/>

Check out SQL4X Manager, from the same page, to see an example of
a Cocoa application that uses JDBC to talk to SQL Server.

Most likely you'll find the JDBC/easyDB solution easier to deal with -
easier to set up, easier to interface with Cocoa, and easier to debug,
but you may not want the overhead of a Java VM in your program.

--
=Nicholas Riley <email@hidden> | <http://www.uiuc.edu/ph/www/njriley>
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.

References: 
 >Newbie: Cocoa App accessing SQL Server DB (From: Itamar Hassin <email@hidden>)



Visit the Apple Store online or at retail locations.
1-800-MY-APPLE

Contact Apple | Terms of Use | Privacy Policy

Copyright © 2011 Apple Inc. All rights reserved.