[R-sig-DB] Executing Stored Procedures from Microsoft SQL Server

[Sean O'Riordain]

Hi Phil,

The first thing I'd check is whether the stored-procedure is actually
returning two things, rather than a single "set" - I've been caught by
this before!  Could you have a print statement hanging around from
debugging?  Are you using "return" or are you printing the results in
the stored-procedure?  I suggest that you create a small stored
procedure which only contains a simple "select top 10 * from
SimpleTable" to verify that it works.

cheers,
Sean O'Riordain


On 16/11/06, Phil Smyth <psmyth using yahoo.com> wrote:
> I am running R 2.3.0 on Windows 2000 connecting to MSSQL 8 via RODBC. When I try to execute a stored procedure via sqlQuery it returns no data. Regular queries work fine and the same query returns the desired results when pasted into the SQL query analyzer. Is it possible to execute a stored procedure?
>
> Thanks,
>
> Phil Smyth
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>