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
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