johnf wrote: > On Tuesday 10 February 2009 01:35:58 am Ricardo Aráoz wrote: > >> If I go to the connection editor and open this connection and test it, >> it tells me the connection was successful. >> > Which version of pymssql? I'll assume "pymssql-0.8.0" >
Yes, It is 0.8.0. (see below) > >> Went into SQLServer and this select works ok : >> """select table_name from INFORMATION_SCHEMA.TABLES >> where table_type = 'BASE TABLE' >> order by table_name""" . >> If I perform >> """select table_name, table_catalog from INFORMATION_SCHEMA.TABLES >> where table_type = 'BASE TABLE' >> order by table_name""" >> I can see table_catalog == 'master' for all lines, and none of the >> table_name's are my tables. >> Maybe what you want to do is >> """select table_name from %(db)sINFORMATION_SCHEMA.TABLES >> where table_catalog = %(db)s >> and table_type = 'BASE TABLE' >> order by table_name""" >> or even : >> """select table_name from %(db)sINFORMATION_SCHEMA.TABLES >> where table_type = 'BASE TABLE' >> order by table_name""" >> Which would work in my system (if variable db=='SomeDB' (see cited post >> above for what 'SomeDB' stands for)). >> > Are you doing these queries from enterprise manager? If so you need to > select > the database. Which is different from using the Dabo connection which > already has selected the database from the connection string. > > Of course you are right. But then I'm at a complete loss about the error message. Today I even tried brute force and searched all my hard drive looking for the string "getTables" which is the name of the method which produces the error, but I did not find it. It would seem unlikely that it is my error as it appears whilst in a wizard. Ricardo. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
