Weird exception between dev & prod

[Jeffrey Melloy]

I've been using SQLAlchemy with a web service for a few months, and am
starting to see weird issues between dev & prod. This is connecting to
a SQL Server 2008 box from Windows.

In dev, it will be happily working, and then spit out
"sqlalchemy.exc.DBAPIError: (Error) ('HYC00', '[HYC00] [Microsoft][SQL
Native Client]Optional feature not implemented (0)
(SQLBindParameter)') 'select run_date, cast(value as float) val from
dashboard_query_history where query_id = ? and run_date between ? and
? order by 1' (504, datetime.date(2012, 4, 10), datetime.date(2012, 4,
11))"

Exact same query & syntax works fine in prod.

Here's my test script, with python 2.6.5 on both.

import sqlalchemy
print sqlalchemy.__version__

import pyodbc
print pyodbc.version

import datetime

oms = sqlalchemy.create_engine("mssql://CORP\svc_oms@hqadmintools01c")

begin_date = datetime.date(2012,04,10)
end_date = datetime.date(2012,04,11)
query_id = 504

rs = oms.execute("select run_date, cast(value as float) val from
dashboard_query_history where query_id = ? and run_date between ? and
? order by 1",
(query_id, begin_date, end_date))

for row in rs:
print " ".join([str(x) for x in row])

Dev:

0.7.6
3.0.3

Traceback (most recent call last):
File "sqlalchemy_test.py", line 16, in <module>
(query_id, begin_date, end_date))
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 2433, in execute
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1450, in execute
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1627,
in _execute_text
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1697,
in _execute_context
File "build\bdist.win32\egg\sqlalchemy\engine\base.py", line 1690,
in _execute_context
File "build\bdist.win32\egg\sqlalchemy\engine\default.py", line 335,
in do_execute
sqlalchemy.exc.DBAPIError: (Error) ('HYC00', '[HYC00] [Microsoft][SQL
Native Client]Optional feature not implemented (0)
(SQLBindParameter)') 'select run_date, cast(value as float) val from
dashboard_query_history where query_id = ? and run_date between ? and
? order by 1' (504, datetime.date(2012, 4, 10), datetime.date(2012, 4,
11))

And prod:
0.7.6
2.1.7
2012-04-10 00:02:23.903000 3.25
2012-04-10 00:13:24.253000 2.26
2012-04-10 00:24:24.650000 2.25
2012-04-10 00:35:27.760000 None
[etc]

The first thing I did was upgrade pyodbc on my dev box, and it got
exactly the same error. It's also sporadic; it tends to work for
awhile and then fail.

Any ideas?

-Jeff

[Derek Litz]

Based on the error message I would guess this is a problem with your install of Microsoft's SQL Native Client for odbc.  Sorry, not a windows guy, so all I can provide is a link http://msdn.microsoft.com/en-us/library/ms131321.aspx.

Is your dev MS native client the same as the prod MS native client?