Autoload broken with MS-SQL and adodbapi

[Former user]

Autoloading tables doesn't work with MS SQL Server and adodbapi. Attached is a short test script that fails against the Northwind database and a file containing the output of the script.

[Former user]

Test program; requires patch in ticket 298

[Former user]

Output of test program

[Former user]

This apparently is a problem with adodbapi, it is fixed by applying this patch: http://sourceforge.net/tracker/index.php?func=detail&aid=1236900&group_id=63427&atid=503936

[Mike Bayer]

hey ms-sql folks, can i get an update on this ? adodbapi is just broken ? why does it only break on reflecting tables and not other queries ?

[Former user]

(original author: ram) Mike,

unmodified adodbapi uses server-side cursors to hold result sets, and those break when attempting to reuse a connection that has pending results.

The patch modifies adodbapi to use ADO client-side cursors (which seem to download all results from the server on execute), thereby sidestepping the problem.

Not sure why the problem happens on table reflection, as the table reflection code seems to use up all results before issuing the next query.

Will test in the next few days; I need to set up a new Windows environment with adodbapi.

[paj]

I couldn't reproduce this, using adodbapi against SQL Server 2005 (although I don't have the Northwind sample). I have emailed Kent, but if we don't get a reply I propose closing this ticket.

[Former user]

(original author: ram) done