Ed Leafe wrote: > On Jan 11, 2009, at 1:07 PM, Djole Mijatovic wrote: > >> Next I created connection with cxnEditor.py, using same connection >> parameters. It passes ok, with "The connection was successful" on Test >> button. I saved conecction. Next I started ClassDesigner.py, >> selected saved >> connection, but on Next button Dabo stopped, with information: >> "... dabo.dException...: select table_name from >> INFORMATION_SCHEMA.TABLES >> where ....". >> >> I tried to find solution in message archives but did not successed. >> Why it >> worked through Python but did not from ClassDesigner ? > > The query on INFORMATION_SCHEMA.TABLES is designed to get internal > information about the structure and content of the database. You said > that you are using SQL Server 2000; perhaps the internal queries have > changed in more recent versions of the database?
I am pretty sure I used INFORMATION_SCHEMA.TABLES with mssql2000 - (thats the only version of mssql I have ever used.) > > John Fabiani did the original testing with this. John, what version > of SQL Server were you running? And does anyone else out there have an > instance of MS SQL 2000 that they can test with? I do, but I don't have the mssql python modules installed, so testing is going to be a pain. But I don't mind exposing my box to the nasty internets, so if anyone wants to test using my box, let me know and I'll open the door. Carl K _______________________________________________ Post Messages to: Dabo-users@leafe.com 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/496a4d63.2030...@personnelware.com
