[python-win32] adodbapi and stored procedure output parameters on

[Vernon Cole]

Randy:
I am no longer employed by the company who supplied the SQL server I
used to test on, and am stuck with SQLexpress on my laptop. No Query
Analyzer. (Bah!) Clearly, either my test was invalid, or there is a
difference in SQL versions.  What version are you using?
--
Vernon

On Tue, May 26, 2009 at 12:54 PM, Randy Syring <randy at rcs-comp.com> wrote:
>
>
> Vernon Cole wrote:
>
> In this case, the proceedure outputs TWO record sets, since there are
> two SELECT statements.
> If the second select statement, "select @param = 10" were changed to
> "SET  @param = 10" then, I believe, the result
> would have been as expected.
>
>
> Vernon, thanks for your comments.
>
> In SQL Server, there is no recordset output for:
>
> select @param = 10
>
> its simply a variable assignment.  You can verify this by doing the
> following in a TSQL or Query Analyzer session:
>
> declare @param int
> select @param = 1
>
> You should see that no resultset is returned.
>
> Having said all that, I ran Randy's test program using pywin32 v213 on
> Python 2.6 and Vista, and it ran correctly.
>
>
> Really!  I did a fresh install of 2.6 and win32 extensions on vista just to
> verify this and I still got an error.  Vernon, so you got a message from
> nose that two tests passed?  Can anyone else verify this?
>
> --------------------------------------
> Randy Syring
> RCS Computers & Web Solutions
> 502-644-4776
> http://www.rcs-comp.com
>
> "Whether, then, you eat or drink or
> whatever you do, do all to the glory
> of God." 1 Cor 10:31
>