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?
On Tuesday, April 10, 2012 8:56:29 PM UTC-5, Jeffrey wrote:
>
> 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
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlalchemy/-/Dn6zGPbjSXcJ.
To post to this group, send email to sqlalchemy@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
