My German friend has told me that the code works. He uses unicode so I
thought it might help if we went over the information that we have as of
today. I'm also starting a new thread.
The issue is the method getTables() in dbMsSQL.py.
We know that the connection information is being passed correctly. You added
debug statements to the code and print statements reflected that the
information was correct.
If you copy the getTables() code and then replace dbName with a hard coded
string it works. You used dShell to run the experiment.
If you replace the {'db':dbName} with {'db':str(dbName)} in the code it works.
It was pointed out that psmssql.py wants a tuple. So we changed the code to:
cursor.execute("select table_name from INFORMATION_SCHEMA.TABLES where
table_catalog = '%s' and table_type = 'BASE TABLE' order by table_name" %
(dbName,))
The above code uses a tuple but did not work. And again you needed to change
the dbName to str(dbName) to get it to work.
I know the code works for me on linux and windows.
The traceback you get is
Traceback (most recent call last):
File "C:\Documents and Settings\raraoz\dabo\ui\uiwx\dControlMixin.py",
line 27
, in _onWxHit
File "C:\Python25\lib\site-packages\dabo\dabo\ui\uiwx\dPemMixin.py",
line 940,
in raiseEvent
super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,
**kwargs)
File "C:\Python25\lib\site-packages\dabo\lib\eventMixin.py", line 93,
in raise
Event
File "C:\Documents and Settings\raraoz\dabo\ui\dialogs\Wizard.py",
line 124, i
n onNext
File "C:\Documents and Settings\raraoz\dabo\ui\dialogs\Wizard.py",
line 291, i
n _setCurrPage
File
"C:\Python25\Lib\site-packages\dabo\IDE\wizards\QuickLayoutWizard.py", li
ne 63, in onLeavePage
return self.Wizard.makeConnection()
File
"C:\Python25\Lib\site-packages\dabo\IDE\wizards\QuickLayoutWizard.py", li
ne 788, in makeConnection
tbls = crs.getTables()
File "C:\Python25\lib\site-packages\dabo\db\dCursorMixin.py", line
1947, in ge
tTables
File "C:\Python25\lib\site-packages\dabo\dabo\db\dbMsSQL.py", line 79,
in getT
ables
{'db':dbName} )
File "C:\Python25\lib\site-packages\dabo\db\dCursorMixin.py", line
330, in exe
cute
dabo.dException.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
Ricardo have I covered everything?
--
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]
