Hello, I am a somewhat new but so far very happy user of SQL Alchemy. Today, however, I have run into a problem that has stopped me cold. I need to join two tables that reside on the same MS SQL server but in two different databases. This is trivial to do in MS SQL Server Management Studio, or, for the matter, from my Linux system using 'isql' - I just use the three-element way of specifying the name of the table: databasename.schemaname.tablename. But this does not work in SQL Alchemy - the trivial attempt of specifying the 'schema' parameter of the 'Table' constructor as 'databasename.schemaname' instead of just 'schemaname', using a DSN that does not specify a database name, results in a NoSuchTableError. I have found several older mails discussing this topic - they mostly say that this cannot be done - but no recent - is this really still a problem for the MSSQL dialect, or have I missed the solution somehow? I did do a serious study of the documentation before writing this mail. I use the pyodbc access method from a Kubuntu 12.04 system, using SQL Alchemy 0.7.8-1 (the version from Debian 'sid', not the Kubuntu 12.04 version which is still 0.7.4).
best regards -- Peder Chr. Nørgaard, M.Sc. Senior SW Developer www.actua.dk - *Software that transforms the business of Energy* -- 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/-/EeppWN-SbfwJ. 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.
