[sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-03 Thread Paul Morel
Hi, I have been trying to diagnose this issue in a Windows Python 2.7 (Anaconda installed) environment running SQLAlchemy=1.1.11, pyodbc=4.0.17, and pymssql=2.1.3. Both pyodbc and pymssql connections will successfully connect and query a table correctly. However, when I attempt the same

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-04 Thread Paul Morel
alar() function: > > > > > https://bitbucket.org/zzzeek/sqlalchemy/src/8d740d6bd6b8bcc061713443120c67e611cdcb34/lib/sqlalchemy/engine/result.py?at=rel_1_1_11=file-view-default#result.py-1212 > > > > > Simon > > > > > > On Tue, Jul 4, 2017 at 2:39 PM, Paul Morel &

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-04 Thread Paul Morel
> > https://bitbucket.org/zzzeek/sqlalchemy/src/8d740d6bd6b8bcc061713443120c67e611cdcb34/lib/sqlalchemy/engine/result.py?at=rel_1_1_11=file-view-default#result.py-1212 > > > Simon > > > On Tue, Jul 4, 2017 at 2:39 PM, Paul Morel > <paul@tartansolutions.com > wrote:

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-04 Thread Paul Morel
Microsoft Analysis Services Client Tools = 10.0.6000.29 > Microsoft Data Access Components (MDAC) = 6.0.6002.18005 > Microsoft MSXML = 3.0 6.0 > Microsoft Internet Explorer = 9.0.8112.16421 > Microsoft .NET Framework = 2.0.50727.4253 > Operating System = 6.0.6002 *Server OS* > Wi

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-04 Thread Paul Morel
> "cursor.description" as well once you execute the query? > > On Tue, Jul 4, 2017 at 11:17 AM, Paul Morel > <paul@tartansolutions.com > wrote: > > I ran that select statement under both the pyodbc and pymssql direct > > connections and it appears t

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-04 Thread Paul Morel
> "cursor.description" as well once you execute the query? > > On Tue, Jul 4, 2017 at 11:17 AM, Paul Morel > <paul@tartansolutions.com > wrote: > > I ran that select statement under both the pyodbc and pymssql direct > > connections and it app

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-04 Thread Paul Morel
anaconda or did it compile on your local machine? This is kind > of a serious issue that a broken shared library got created > > On Jul 4, 2017 7:55 PM, "Paul Morel" <paul@tartansolutions.com > > wrote: > > BAM! That was it. There must be some type of

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-05 Thread Paul Morel
environment but it appears I don't have installation rights on that machine at the moment. I will see if I can reproduce this problem if I can get install privileges. On Wednesday, July 5, 2017 at 7:47:25 AM UTC-5, Mike Bayer wrote: > > > > On Jul 5, 2017 12:59 AM, "

Re: [sqlalchemy] SQLAlchemy won't connect correctly but pyodbc and pymssql will

2017-07-04 Thread Paul Morel
on extensions these days), try blowing those away for > SQLAlchemy. > > > On Tue, Jul 4, 2017 at 2:24 PM, Paul Morel > <paul@tartansolutions.com > wrote: > > Sorry, I gave you the cursor.description of the schema_name() query. > This > > is the out