FreeTDS and SQL Server: Could Not Find Stored Procedure 'S' about pyodbc HOT 3 CLOSED

I have the same problem, but querying sybase ASE. This is also on python 3.4 but running on debian 8. I have installed the latest version of pyodbc (3.0.9) with pip.

both tsql and isql can connect with no issues to the database, and do normal select statements, but pyodbc and sqlalchemy give me the same error as above. I also tried playing around with the configurations for client encoding with no success.

This seems to be related to issue #40. I tried installing 3.0.8 with pip, which had the same problem. Since 3.0.7 doesn't seem to be available on pypi anymore I downloaded it from google code (direct link to the file), and installed it from there. 3.0.7 seems to work with no correctly, both on pyodbc and using sqlalchemy.

from pyodbc.

If you are using unixODBC this should be fixed by b126ffb on the master branch.

If you are not using unixODBC and your driver requires a SQLWCHAR size other than 2-bytes let me know. I'm going to need to make this configurable but since it works for unixODBC and Windows I'll start there.

I'll release this as 3.1.0 when I've fixed a couple of other bugs.

from pyodbc.

Thanks!

from pyodbc.