Re: [sqlalchemy] pyodbc.connect works create_engine fails

2013-12-03 Thread Karthic Raghupathi
Thank you so much for this snippet! It helped figure out my connectivity issues to Microsoft SQL Server. On Thursday, December 23, 2010 1:42:42 PM UTC-5, Michael Bayer wrote: On Dec 23, 2010, at 1:31 PM, Pirate Fibonacci wrote: running on fedora 13. yum installed everything. got unixodbc

[sqlalchemy] pyodbc.connect works create_engine fails

2010-12-23 Thread Pirate Fibonacci
running on fedora 13. yum installed everything. got unixodbc installed and working, this includes iodbctest, isql, tsql, and the following works: import pyodbc cnxn = pyodbc.connect(DSN=Default;UID=user;PWD=passw) cursor = cnxn.cursor() cursor.execute(use database) cursor.execute(select * from

Re: [sqlalchemy] pyodbc.connect works create_engine fails

2010-12-23 Thread Michael Bayer
On Dec 23, 2010, at 1:31 PM, Pirate Fibonacci wrote: running on fedora 13. yum installed everything. got unixodbc installed and working, this includes iodbctest, isql, tsql, and the following works: import pyodbc cnxn = pyodbc.connect(DSN=Default;UID=user;PWD=passw) cursor =