mxODBC + MSSQL = code -9 error (again)

[Matt]

I am just starting to use the mxODBC package, and have come across an
issue that has been posted in the newsgroups before, but I have not yet
found a solution.

I am using ActiveState Python 2.0 "ActivePython 2.0, build 202
(ActiveState Tool Corp.) based on Python 2.0 (#8, Oct 19 2000,
11:30:05) [MSC 32 bit (Intel)] on win32", on a Windows 2000
Professional PC, and attempting to connect to a Microsoft SQL Server
7.0 database, using a simple test script adapted from your
documentation. Thes test script, included below, works fine when
connecting to an Access database, so I am assuming my installation is
valid.

But, when I connect to a SQL Server database, and have a result set
that includes a Unicode character data  (SQLDMO_DTypeUVarchar -9
Variable length) type, I get the "InterfaceError: SQL type (code -9)
not implemented" error. This is avoidable since my tables to not use
Unicode fields, but apparently some of the SQL Server system tables do.

The script below, when run against a MS Access DSN, properly returns a
list of tables. But it appears the same call against the MS SQL DSN
returns Unicode data in the result set (in c.tables).

***

import ODBC
db = ODBC.Windows.Connect('SQLTest','sa')
c = db.cursor()
c.execute('select count(*) from testdata')
c.fetchone()
c.tables(None,None,None,None)
ODBC.print_resultset(c)
c.close()
db.close()

Traceback (most recent call last):
  File "d:\python20\pythonwin\pywin\framework\scriptutils.py", line
301, in RunScript
    exec codeObject in __main__.__dict__
  File "D:\Python20\Lib\ODBC\Misc\sqltest.py", line 7, in ?
    ODBC.print_resultset(c)
  File "d:\python20\lib\ODBC\ODBC.py", line 75, in print_resultset
    lines = apply(format_resultset,(cursor,headers),kws)
  File "d:\python20\lib\ODBC\ODBC.py", line 33, in format_resultset
    rows = cursor.fetchall()
InterfaceError: SQL type (code -9) not implemented


Sent via Deja.com http://www.deja.com/
Before you buy.