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: Itamar Hassin <email@hidden>
- Date: Sun, 4 Jul 2004 00:22:46 -0400
Nicholas,
Thanks for the reply.
I will download and compile TDS to see what gives.
I was aware of the Java alternative, but wanted to explore the
bare-bones way.
Thanks again, I'll let you know how it went...
Itamar
On Jul 3, 2004, at 10:10 PM, Nicholas Riley wrote:
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.