When fetch numeric field, get "Program type out of range" error. #9

Closed
yihuang opened this Issue Mar 21, 2012 · 1 comment

Comments

Projects
None yet
2 participants
@yihuang

yihuang commented Mar 21, 2012

I've tried multiple versions of pyodbc, i've been using 2.1.7 which don't have this problem, but i got problem with bigint field, so i decide to upgrade to most recent version of pyodbc, it has no problem with bigint now, but have this new problem.

exception:

pyodbc.Error: ('HY003', '[HY003] [FreeTDS][SQL Server]Program type out of range (0) (SQLGetData)')

python: 2.6
os: debian6 x86/64
sqlserver: 2005/64
unixODBC: 2.2.11

yihuang added a commit to yihuang/pyodbc that referenced this issue Mar 21, 2012

@yihuang

This comment has been minimized.

Show comment Hide comment
@yihuang

yihuang Mar 21, 2012

It seems problem get fixed by simply change SQLWCHAR to SQLCHAR, i don't know if this breaks other codes, but it do fix my problem.

yihuang commented Mar 21, 2012

It seems problem get fixed by simply change SQLWCHAR to SQLCHAR, i don't know if this breaks other codes, but it do fix my problem.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment