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 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.