Re: Newbie: Cocoa App accessing SQL Server DB
Re: Newbie: Cocoa App accessing SQL Server DB
- Subject: Re: Newbie: Cocoa App accessing SQL Server DB
- From: Nicholas Riley <email@hidden>
- Date: Sat, 3 Jul 2004 21:10:52 -0500
- Mail-followup-to: Itamar Hassin <email@hidden>, email@hidden
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.