I don't think so, not directly. Short-term, here's a couple of things to try:
-- you may be able to create views in the local database that reference the warehouse tables, and access these views as if they were local tables. -- you may be able to hack up something by using the schema support in SA, where the "schema" would be a string consisting of "database.owner". If SA ignores the dot in the string and passes it through to the DB-API, and if the DB-API also ignores the string, it might work. (^H^H^H -- I see you tried this already) Longer term, this is going to need support on both the DB-API and the SA level. AFAIK, only MSSQL has this kind of feature, and adding it will probably risk breaking a lot of other things. So, if it is going to need a lot of changes to SA to make it happen, it probably won't. On 6/5/07, desmaj <[EMAIL PROTECTED]> wrote: > > > Hi Folks, > > In my current environment, I get one database connection per web > application. That connection has to access tables in a data warehouse > as well as an application specific database. Both databases live on > the same SQL Server instance. > > It seems as though I can't use the sql generation component to access > tables from both databases at the same time. I am able to do this in > my hand-written SQL by fully qualifying the tables names as > "database.owner.table". I have tried using this fully qualified name > as the table name and also using "database.owner" as the schema > argument to the constructor, but neither works. I also noticed that > there is an owner argument to the constructor, but that doesn't seem > to do the trick. > > Is this at all possible right now? > > Thanks, > Matthew > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---