On Nov 29, 2012, at 1:25 PM, E.Scott M. wrote:
> I am migrating my accounting from Microsoft Dynamics(Mssql) to Quickbooks
> Enterprise. I have had lots of custom code written to bridge between my
> website and Dynamics. I am trying to port that code over to quickbooks but I
> am having a very difficult time.
> We used sqlAlchemy and python to create out custom code. I am trying to use
> sqlalchemy for the quickbooks port.
> I am using QODBC on the quickbooks side and mxODBC on the python side.
> I can use mxODBC native functions and direct connect to the quickbooks
> database - access the tables and data, but the mxodbc.directconnect()
> function will not work syntactically with sqlalchemy connection strings.
>
> In sqlalchemy this is what I can do:
>
> engine = create_engine('mssql+mxodbc://@QRQBwhoimp')
> >>> metadata = MetaData('mssql+mxodbc://@QRQBwhoimp')
> >>> metadata.bind = engine
> >>> connection = engine.connect()
>
> I dont receive any error messages until I try and connect - then I get:
> sqlalchemy.exc.NotSupportedError: (NotSupportedError) ('IM001', 0,
> '[Microsoft][ODBC Driver Manager] Driver does not sup
> port this function', 12173) None None
>
> Also, if I try to reflect a table, I get the same error message. I have tried
> a lot of different connection strings and this one seems to work without
> error messages that other ones generate.
Make sure you're on the very latest released version of mxodbc, and possibly
also try pyodbc. The error is being emitted from your ODBC driver but I'm
not familiar with its meaning.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
