python处理teradata数据库_在Python / Pyodbc中查询Teradata的问题

我试图用PyODBC查询

Python中的Teradata数据库.

与数据库的连接建立好了;但是,当我尝试获取结果时,我碰到了这个错误“Decimal：u”的无效文字.请帮助.

我在RHEL6上,使用Python 2.7.3

这里是代码和结果：

import pyodbc

sql = "select * from table"

pyodbc.pooling = False

cnx = pyodbc.connect("DRIVER={Teradata};DBCNAME=host;DATABASE=database; AUTHENTICATION=LDAP;UID=user;PWD=password", autocommit=True, ANSI=True)

cursor = cnx.cursor()

rows = cursor.execute(sql).fetchone()

InvalidOperation Traceback (most recent call last)

in ()

----> 1 test.fetchone()

/usr/local/lib/python2.7/decimal.pyc in __new__(cls, value, context)

546 context = getcontext()

547 return context._raise_error(ConversionSyntax,

--> 548 "Invalid literal for Decimal: %r" % value)

549

550 if m.group('sign') == "-":

/usr/local/lib/python2.7/decimal.pyc in _raise_error(self, condition, explanation, *args)

3864 # Errors should only be risked on copies of the context

3865 # self._ignored_flags = []

-> 3866 raise error(explanation)

3867

3868 def _ignore_all_flags(self):

InvalidOperation: Invalid literal for Decimal: u''