I have no problem retrieving data from the SQL server, but the data 

retrieval is quite slow.  I want to speed it up by using stored 

procedures.  I'm not even sure if you can run a stored procedure in RDO.  

If anyone knows if this can be done and how...it would be greatly 

appreciated.



Thanks

It's pretty easy.  Instead of using straight sql just write in the name of

the procedure.  

Example: 



In script it looks like this:  rds.SQL = "EXEC gsp_ProcedureName Parameter,

Parameter1"







Josh King

GeoAccess Inc.

xxx.xxx.xxxx  x5237

xxx.xxx.xxxx  x5237



-----Original Message-----

From: Khang Nguyen [mailto:khang.nguyen@e...]

Sent: Friday, April 13, 2001 12:34 PM

To: ASP_ADO_RDS

Subject: [asp_ado_rds] How do i run SQL stored procuedures using RDS?



I have no problem retrieving data from the SQL server, but the data

retrieval is quite slow.  I want to speed it up by using stored

procedures.  I'm not even sure if you can run a stored procedure in RDO. 

If anyone knows if this can be done and how...it would be greatly

appreciated.



Thanks