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"
> 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. -- John Fabiani _______________________________________________ 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]
