there might not be a choice here as the QODBC driver might not support some of
the operations that table reflection needs. It's also critical that this
database is in fact Microsoft SQL Server, and not something more like Access,
because it won't work at all if not.
You'd want to set echo=True on create_engine(), and observe the queries being
emitted to see which one is failing. From there, you'd have to seek help with
the specific quirks of QODBC. These "lesser" ODBC drivers, like the one for
Microsoft Access, frequently have a lot of these "dead end" situations where
not enough functionality is provided to perform the tasks SQLAlchemy needs to
do.
Is this truly a Microsoft SQL Server database ? if so, I'd look into setting
up a traditional SQL Server ODBC connection which has full capabilities. If
QuickBooks does *not* use Microsoft SQL Server, then this definitely won't work
at all as SQLAlchemy's MSSQL driver is coded to the views and functions that
are specific to SQL Server.
On Dec 18, 2012, at 3:13 PM, ScottyMac wrote:
> pyodbc version = 2.1.9-beta16
> Trying to connect sqlalchemy to quickbooks enterprise database. Have a DSN
> setup with Qodbc called "quickbooks"
> This connection string works for pyodbc
> cnxn = pyodbc.connect(‘dsn=quickbooks’, autocommit=True) #Must set autocommit
> flag or get error message found below.
> I can open tables and query database - everything seems to be ok.
> However, I cannot get the sqlAlchemy connection working.
> Here is my consolidated code
> (__iint__.py)
> import tables
> from session import getSession
> (session.py)
> engine = create_engine('mssql+pyodbc://ADMIN@Quickbooks')
> Session = sessionmaker(bind = engine, autocommit=True)
> (tables.py)
> metaData = MetaData()
> metaData.bind = engine
> vendorTable = Table('vendor', metaData, autoload=True)
> Which yields this error message:
> sqlalchemy.exc.DBAPIError: (Error) ('IM001', '[IM001] [QODBC] Driver not
> capable
> (11010) (SQLSetConnnectAttr(SQL_ATTR_AUTOCOMMIT))') None None
> >>>
> I have tried all manner of connection strings in sqlalchemy and also
> different kinds of autocommit syntax and so far I cannot get it to work. I am
> sure some smart folks out there can help me out!!
> Thanks,
> Scott
>
> --
> 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/-/cOhqTKsDv94J.
> 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.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
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.
