On Feb 11, 2009, at 8:43 AM, Clovis Fabricio wrote:
> > 2009/2/11 Clovis Fabricio <nos...@gmail.com>: >> 2009/2/10 Michael Bayer <mike...@zzzcomputing.com>: >>>> Question is: How can I do that in a sa.Table constructor? >>>> sa.Table('DataB.dbo.TableInB', metadata, ....) >>>> sa.Table('TableInB', metadata, ...., schema='DataB.dbo') >>>> And both failed. Is there a way to map tables from both databases >>>> using the same engine? So I can do a JOIN between the tables? >>> you should use the "schema" argument. Define "failed" ? >> Now it works. I was doing something wrong. Sorry for the trouble, >> and thank you. > > No sorry! it is still failing, I though it was working because > declaration didn't yield any errors. But when using it in a query I > got the error: > >>>> tb = sa.Table('TableInB', metadata, ...., schema='DataB.dbo') >>>> print tb.insert() > INSERT INTO [DataB.dbo].[TableInB] ([field1], [field2]) VALUES (?, ?) > > It should be "[DataB].[dbo].[TableInB]" > > I got it to work by using: > > sa.Table('DataB.dbo.TableInB', metadata, ...., quote=False) > > or > > sa.Table('TableInB', metadata, ...., schema='DataB].[dbo') > > but both are damn ugly!! I think perhaps there's a way to configure your database such that you wouldn't need the "dbo" segment ? --~--~---------~--~----~------------~-------~--~----~ 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 sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---