Hello,
I have just downloaded and installed Dabo 0.8.3 for Windows XP
(dabo-0.8.3.zip) The installation worked perfectly and I have run some of
the demo programs and they work. I'm using Python 2.5
Since I'm working with Microsoft SQL-server, I'm using MSDE 2000 as my
server and since I have multiple servers I run it on port 2816
I have installed pymssql and using it I can connect to my database and do
all kinds of database things. E.g.
import pymssql
con = pymssql.connect(host="AME1\MESQL", user="sa", password="hemligt",
database="Northwind") cur = con.cursor() sql = "select * from Orders"
cur.execute(sql)
print cur.fetchall()
Now I want to use AppWizard to create a new application. I start Appwizard
and I get these messages:
Dabo Info Log: Mon May 05 08:18:25 2008: 0 database connection
definition(s) loaded.
Dabo Info Log: Mon May 05 08:18:25 2008: User interface already set to
'wx', so dApp didn't touch it.
Dabo Info Log: Mon May 05 08:18:26 2008: wxPython Version: 2.8.7.1 wxMSW
(unicode)
I then fill in the form with these values:
DbType: MsSQL
Name: myDbApp1
Host: AME1\MESQL
Database: Northwind
User: sa
Password: hemligt
Port: 2816
I press Next and I get a dialog saying
"Could not connect to the database server. Please check your parameters and
try again."
And this traceback:
Traceback (most recent call last):
File "E:\dabo\ide\wizards\AppWizard\AppWizard.py", line 305, in
onLeavePage tables = cursor.getTables()
File
"e:\Python25\lib\site-packages\dabo-0.8.3-py2.5.egg\dabo\db\dCursorMixin.py",
line 1716, in getTables
return self.BackendObject.getTables(self.AuxCursor,
includeSystemTables)
File
"E:\Python25\lib\site-packages\dabo-0.8.3-py2.5.egg\dabo\db\dbMsSQL.py",line
79, in getTables {'db':dbName} )
File
"e:\Python25\lib\site-packages\dabo-0.8.3-py2.5.egg\dabo\db\dCursorMixin.py",
line 314, in execute
raise dException.DBQueryException(e, sql)
DBQueryException: internal error: None
SQL: select table_name from INFORMATION_SCHEMA.TABLES where table_catalog =
%(db)s and table_type = 'BASE TABLE' order by table_name
Any clue on what is wrong and how I fix it?
Anders Eriksson
--
"For every complex problem, there is a solution that is simple, neat, and
wrong." H.L. Mencken
_______________________________________________
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]
