Re: [dabo-users] classDesigner Data Connection not working

Author: Bob K.

Posted: 2011-06-02 at 08:00:16

Hi Ed,

I've edited the database tag, and it's still not working. here's the

traceback info:

Microsoft Windows [Version 6.1.7601]

Copyright (c) 2009 Microsoft Corporation. All rights reserved.

C:\dabo\ide>c:\python27\python classdesigner.py

C:\dabo\ide>c:\python27\python classdesigner.py

Traceback (most recent call last):

File "c:\python27\lib\site-packages\wx-2.8-msw-unicode\wx\_core.py", line

1464

0, in <lambda>

lambda event: event.callable(*event.args, **event.kw) )

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dDataControlM

ixinBase.py", line 365, in _delayedSetDataSource

self.update()

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dDataControlM

ixinBase.py", line 102, in update

self.__dataUpdate()

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dDataControlM

ixinBase.py", line 154, in __dataUpdate

self.Value = srcatt

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dControl

ItemMixin.py", line 384, in _setValue

self.StringValue = value

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dControl

ItemMixin.py", line 358, in _setStringValue

raise ValueError(_("String must be present in the choices."))

ValueError: String must be present in the choices.

Traceback (most recent call last):

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dControl

Mixin.py", line 27, in _onWxHit

self.raiseEvent(dEvents.Hit, evt, *args, **kwargs)

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\uiwx\dPemMixi

n.py", line 992, in raiseEvent

super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args,

**kwargs)

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\lib\eventMixin.p

y", line 92, in raiseEvent

bindingFunction(event)

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dialogs\Wizar

d.py", line 124, in onNext

self.CurrentPage += pg.nextPage()

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\ui\dialogs\Wizar

d.py", line 291, in _setCurrPage

ok = self._pages[self._currentPage].onLeavePage(direction)

File "C:\dabo\ide\wizards\QuickLayoutWizard.py", line 63, in onLeavePage

return self.Wizard.makeConnection()

File "C:\dabo\ide\wizards\QuickLayoutWizard.py", line 788, in

makeConnection

tbls = crs.getTables()

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dCursorMixin.

py", line 2041, in getTables

return self.BackendObject.getTables(self.AuxCursor, includeSystemTables)

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dbSQLite.py",

line 148, in getTables

cursor.execute("select * from sqlite_master")

File

"c:\python27\lib\site-packages\dabo-0.9.3-py2.7.egg\dabo\db\dCursorMixin.

py", line 355, in execute

raise dException.DBQueryException(errMsg)

dabo.dException.DBQueryException: file is encrypted or is not a database

-----Original Message-----

From: Ed Leafe

Sent: Wednesday, June 01, 2011 4:53 PM

To: Dabo Users list

Subject: Re: [dabo-users] classDesigner Data Connection not working

On Jun 1, 2011, at 4:34 PM, Bob K. wrote:

> In the classdesigner, I’ve added an sqlite data connection, and the test

> works. when selecting the connection and clicking the ‘next’ button,

> nothing is happening (no error, no new screen). I’m using windows 7.

This is almost certainly a pathing problem, since SQLite is a file-based

connection. Can you open the .cnxml file and tell me what's in the

<database> tag? Is it an accurate path from where you're running the Class

Designer app?

-- Ed Leafe

_______________________________________________

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/7803C74E-642F-44C9-AEFD-07B6A018ABB6@leafe.com

_______________________________________________

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/42F30762088B4F6484A22A91F2698160@BobPC

©2011 Bob K.