> You need to install the pymssql module to access MS SQL Server. You > can get it at: http://sourceforge.net/project/showfiles.php?group_id=40059 > > There is a bug in this released version, so we created a patched > version that should work correctly. This is available at > http://leafe.com/dls/dabo > - look for the entry labeled 'Modified pymssql.py'
Thank all fo you for good advices. I successfuly installed support for MSSQL 2000. As beginner it was hard to me to find all requirements about MSSQL on one place. For other who begin using DABO 0.9 and MSSQL on Windows XP/SP2 machines, I will repeat what you adviced me: 1-Install pymssql support for 0.8.0 version, from http://sourceforge.net/project/showfiles.php?group_id=40059 2-Because of a bug in this released version, there is patched version that should work correctly. This is available at http://leafe.com/dls/dabo . Look for the entry labeled 'Modified pymssql.py'. 3-Copy patched pymssql.py file into your site-packages directory, overwriting the one that was installed. In this way I successfuly installed support for MSSQL 2000. But I found another problem. After installing MSSQL support, a entered python and typed next set of commands: >>>import pymssql >>>con=pymssql.connect(host="DORDIJE\SQLEXPRESS",user="sa".password="some",database="FINMAN") >>>cur=con.cursor() >>>sql="select * from ACCVAL" >>>cur.execute(sql) >>>print cur.fetchall() >>>con.close() This worked ok ! 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 ? Thank you in advance. _______________________________________________ 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/d63698d4445a4f1087b3b147dc901...@dordije
