running stored procedure in sqlserver db

beren

New Member
I need to run a stored procedure in a Microsoft sqlserver 7.0 database from the progress 4gl (and webspeed).

I've tried using com-handles and ADO to connect to the database and then running the stored procedure.
Connecting to the database wasn't a problem, running the stored procedure is.

The stored procedure has 4 input parameters and returns a recordset.

It seems the execute method doesn't handle more than one input parameter for the stored procedure.
I also tried the createparameter method, but this didn't work either, maybe the syntax used was wrong ? (I couldn't find any examples using com-handles).

My question is what my options are:
Is it possible to run a stored procedure from the progress 4gl using com-handles and ADO ?
If not is my only option using a sqlserver dataserver instead ?
If it is possible what are the advantages of using a sqlserver dataserver ?
Are there any other options ?

thanks
chris smith
 
Back
Top