Re: Executing Stored Procedures on a Microsoft SQL 2000 Server

FROM : Andy Satori
DATE : Wed Apr 20 14:28:42 2005

from the command line, you would use tsql and 'exec storedProcName
param1,param2;'

from code, you'll need to create the connection, and then setup the
call, it's a little more complex, but the source for tsql will show you
the way to do it.

You could also use ODBC and skip FreeTDS, or you could use JDBC via the
Java bridge.  Flip a coin :-).  Much of the decision boils down to
preference.

Andy

On Apr 20, 2005, at 5:42 AM, Ben Borofka wrote:

> I'm trying to write a Cocoa client that will (ideally) execute stored
> procedures on a Microsoft SQL 2000 Server. Has anyone had any
> experience with this? I'm a complete beginner when it comes to
> databases so I am looking for a little advice or some easy examples.
> My project is not all that complex. It only needs to be able to
> connect to the server, create/execute 2-3 stored procedures, and
> that's all. It'd sure be nice to use some clean Cocoa wrappers for
> this, but I know it's not going to happen.
>
> I've downloaded and compiled FreeTDS, but I am a little unsure how I
> am going to go about putting it in my project. I also have no idea how
> to execute stored procedures with the compiled tools, the
> documentation doesn't explain it anywhere.
>
> Any help? Am I facing in the right direction?
>
> Thanks!
>
> Ben Borofka
> _______________________________________________
> 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>
>