I know this thread is from a while back, but hopefully I can still get some
help on this.
I also used RODBC to connect to a SQL Server, and my stored procedure
returns a results set (that is not stored as a temp or permanent table).
So I was wondering if there was a way to access this results se
Thanks Dieter.
The stored proc drops and recreates a result table that contains a copy of
the same result set that is returned by the query.
If I pause after line 1, line 2 returns a valid result set and line 4
displays a table of data.
If I do not pause the script after line 1 or 2, line 3 fail
tradenet wrote:
>
> Thanks Dieter.
>
> The date argument isn't a problem. When I invoke the stored proc
> execution with the date arguments the stored proc runs fine, but RODBC
> doesn't wait for the stored proc to finish and return results.
>
>
Don't understand that one. How do you know t
Thanks Dieter.
The date argument isn't a problem. When I invoke the stored proc execution
with the date arguments the stored proc runs fine, but RODBC doesn't wait
for the stored proc to finish and return results.
Regards,
Andrew
Dieter Menne wrote:
>
>
>
> tradenet wrote:
>>
>> Short of
tradenet wrote:
>
> Short of uploading a SQL server database, I don't think I can make this
> example reproducible, but I hope it's not so complicated as to require
> reproducibility
>
> I can call a parametrized stored procedure without a problem and the proc
> does indeed execute success
Short of uploading a SQL server database, I don't think I can make this
example reproducible, but I hope it's not so complicated as to require
reproducibility
I'm using RODBC to get data from Microsoft SQL Server.
I can call a parametrized stored procedure without a problem and the proc
does
6 matches
Mail list logo