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'*<mssql+mxodbc://@QRQBwhoimp'/>
)
>>> metadata =
>>> MetaData('*mssql+mxodbc://@QRQBwhoimp'*<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.
Any ideas?
--
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/-/dlCkS0hzEDgJ.
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.
