On Jun 20, 2:09 pm, "Rick Morrison" <[EMAIL PROTECTED]> wrote: > The SA MSSQL module currently supports the three DBAPI modules mentioned > above (pyodbc, pymssql, adodbapi). > > You'll need to either get one of those three to import under IronPython, or > add support for the IPCE adaptor.
pyodbc, pymssql, and adodbapi each use binary modules, so they would require some (unknown amount of) conversion to work with IronPython. I wrapped a module around the IPCE adaptor module to meet (more of) the DBAPI 2.0 module level requirements, and duplicated the pyodbc code in databases/mssql.py to use my module. That got me an error on the Table('users', metadata, ... line from the tutorial: Traceback (most recent call last): File D:\Software\IronPython\dbTest\test_sa.py, line 83, in Initialize File D:\Software\IronPython\dbTest\test_sa.py, line 80, in main File D:\Software\IronPython\dbTest\test_sa.py, line 52, in test_users_table File schema, line unknown, in __call__ File D:\Downloads\Python\SQLAlchemy-0.3.8\Lib\sqlalchemy\schema.py, line 156, in __call__ File , line 0, in Make##135 TypeError: Cannot convert _TableSingleton(<class 'sqlalchemy.schema.Table'>) to String This error looks like it might be due to a difference in the type systems between C-Python and IronPython, previously reported as http://www.codeplex.com/IronPython/WorkItem/View.aspx?WorkItemId=7594 That IronPython work item is currently scheduled for the 2.0 alpha 2 release. Note that the community can vote for problems to be fixed on the Codeplex site. Here is my wrapper module, which I called ipodbc.py: import dbapi import odbc as db dbapi._load_type(db.assembly,db.typename) def connect(connectStr): return = db.connect(connectStr) apilevel = '2.0' threadsafety = 0 paramstyle = 'qmark' --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---