Thanks. Yes, I am indeed connecting to MS SQL. I got everything working after upgrading to SQLAlchemy 0.6.3. This required some rework, to rip out collective.lead (which does not support recent versions of SQLAlchemy) and replace it with z3c.saconfig. I am still using unixodbc, though, installed from buildout.
Thanks again. Fulvio On Jul 20, 1:24 pm, Michael Bayer <[email protected]> wrote: > On Jul 20, 2010, at 3:34 PM, fulv wrote: > > > > > > > I have the following stack, which works fine on two different Linux > > systems, but produces the error below on a Mac OS X 10.6.4 machine: > > > - Ubuntu 10.04 / Fedora 8 (works) - Mac OS X 10.6.4 (does not > > work) > > - freeTDS 0.82 > > - unixODBC 2.3.0 > > - pyodbc 2.1.7 > > - collective.lead 1.0 > > - SQLAlchemy 0.4.8 > > - Zope 2.10.11 > > - Plone 3.3.5 > > > From the debugger (bin/instance debug) I can make simple connections > > and execute simple queries, both using pyodbc and sqlalchemy. > > Basically, it looks like it's breaking at this line in _setup_tables > > (which overrides collective.lead.Database's): > > > tables['WebRegions'] = Table('lut_WebRegions', metadata, > > autoload=True) > > MS-SQL (I am guessing you're using MS-SQL based on the error message and the > quoting style) support is extremely poor in SQLAlchemy 0.4.8, though this > appears to be at least partially a FreeTDS issue. Also OSX does not use > unixODBC as far as I know, it uses iODBC. You should at once be using > SQLAlchemy 0.6.3 where our reflection tests pass just fine using FreeTDS + > OSX + default iODBC install + MS-SQL. > > > > > > > Any assistance or leads on where to go next would be greatly > > appreciated! > > > Thanks! > > > 2010-07-14 20:40:33 ERROR Zope.SiteErrorLog > > 1279165233.140.347153571577 > > <a href="http://localhost:8080/mysite/@@database-controlpanel";>http:// > > localhost:8080/mysite/@@database-controlpanel</a> > > Traceback (innermost last): > > Module ZPublisher.Publish, line 119, in publish > > Module ZPublisher.mapply, line 88, in mapply > > Module Products.PDBDebugMode.runcall, line 70, in pdb_runcall > > Module ZPublisher.Publish, line 42, in call_object > > Module zope.formlib.form, line 769, in __call__ > > Module Products.Five.formlib.formbase, line 55, in update > > Module zope.formlib.form, line 750, in update > > Module zope.formlib.form, line 594, in success > > Module plone.app.controlpanel.form, line 41, in handle_edit_action > > Module mysite.content.browser.dbsettings, line 40, in _on_save > > Module collective.lead.database, line 49, in invalidate > > Module collective.lead.database, line 95, in _initialize_engine > > Module mysite.content.db, line 61, in _setup_tables > > Module sqlalchemy.schema, line 110, in __call__ > > Module sqlalchemy.schema, line 226, in __init__ > > Module sqlalchemy.engine.base, line 1275, in reflecttable > > Module sqlalchemy.databases.mssql, line 570, in reflecttable > > Module sqlalchemy.engine.base, line 844, in execute > > Module sqlalchemy.engine.base, line 895, in execute_clauseelement > > Module sqlalchemy.engine.base, line 907, in _execute_compiled > > Module sqlalchemy.engine.base, line 916, in __execute_raw > > Module sqlalchemy.engine.base, line 960, in _cursor_execute > > Module sqlalchemy.engine.base, line 942, in _handle_dbapi_exception > > ProgrammingError: (ProgrammingError) ('The SQL contains 0 parameter > > markers, but 2 parameters were supplied', 'HY000') u'SELECT > > [COLUMNS_1].[TABLE_SCHEMA], [COLUMNS_1].[TABLE_NAME], [COLUMNS_1]. > > [COLUMN_NAME], [COLUMNS_1].[IS_NULLABLE], [COLUMNS_1].[DATA_TYPE], > > [COLUMNS_1].[ORDINAL_POSITION], [COLUMNS_1]. > > [CHARACTER_MAXIMUM_LENGTH], [COLUMNS_1].[NUMERIC_PRECISION], > > [COLUMNS_1].[NUMERIC_SCALE], > > [COLUMNS_1].[COLUMN_DEFAULT] \nFROM [INFORMATION_SCHEMA].[COLUMNS] AS > > [COLUMNS_1] \nWHERE [COLUMNS_1].[TABLE_NAME] = ? AND > > [COLUMNS_1].[TABLE_SCHEMA] = ? ORDER BY [COLUMNS_1]. > > [ORDINAL_POSITION]' ['lut_WebRegions', 'dbo'] > >> /Users/fulvio/plone/mysite/buildout/eggs/SQLAlchemy-0.4.8-py2.4.egg/sqlalch > >> emy/engine/base.py(944)_handle_dbapi_exception() > > -> del self._reentrant_error > > > -- > > 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 > > athttp://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 [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.
