ODBC Query - RCC DSN list, Stored Procedure

[harryhsyd]

I'm experiencing a couple of problems with the ODBC Query test with HostMon 5.92.
When I try and create/edit the test with RCC it shows the DSNs on my local machine and not those of the server.

Also, how do I get a return value from a MS SQL Stored Procedure?
I'm using

Declare @RetVariable int
RETURN @RetVariable

HostMon executes the SP fine but gives the following error.
Error: [ODBC SQL Server Driver] Prepared statement is not a cursor-specification

Cheers
Harry

[Yoorix]

Also, how do I get a return value from a MS SQL Stored Procedure?
I'm using
Declare @RetVariable int
RETURN @RetVariable

I think you should try SELECT @RetVariable instead of RETURN

Regards,
Yoorix

[KS-Soft]

When I try and create/edit the test with RCC it shows the DSNs on my local machine and not those of the server.

Yes, RCC does not retrieve list of data sources from remote system (yet). But you may type it manually.

Regards
Alex