Executing Stored Procedures on a Microsoft SQL 2000 Server

FROM : Ben Borofka
DATE : Wed Apr 20 11:42:26 2005

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