Re: Executing Stored Procedures on a Microsoft SQL 2000 Server
Re: Executing Stored Procedures on a Microsoft SQL 2000 Server
- Subject: Re: Executing Stored Procedures on a Microsoft SQL 2000 Server
- From: Andy Satori <email@hidden>
- Date: Wed, 20 Apr 2005 08:28:42 -0400
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden