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 09:45:53 -0400
Nicholas,
Did TDS compile cleanly for you? I had to tweak some of the makefiles
(I got errors from libtool [both prefixed with $(SHELL) and using
unknown flag -B]).
At the end, all compiled :) Now let's see if it works...
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.