Thanks for the welcome and the help! I can create a connection file in the Connection Editor, and it passes the built-in test without error. I get a dialog that says "The connection was successful!" However, from within the Class Designer, I attempted to use this same connection file with the Add Controls from Data Environment option, and got a dialog with the following message: "Could not make connection to 'MyData'" after the first Next in the wizard. There was no traceback, or any other output in the command window.
In the tutorials I've been following, there is a more manual method to connect to the database, which I will attempt when I have a little more time. Would that make a difference? Jamie Adams ________________________________________________________ Liquis, Inc. 400 Parker Drive, Suite 1110, Austin, TX 78728 phone 512.299.9634, ext 103 -- fax 512.873.0575 _______________________________________________________ http://www.liquis.com/ http://www.liquisbi.com/ http://stores.ebay.com/Liquis-High-Tech-Equipment ----- Original Message ----- From: "John" <[email protected]> To: "Dabo Users list" <[email protected]> Sent: Friday, December 4, 2009 4:10:46 PM GMT -06:00 US/Canada Central Subject: Re: [dabo-users] TypeError when running AppWizard On Friday 04 December 2009 01:50:53 pm Jamie Adams wrote: > I had the list set to Digest by mistake, so I didn't catch all of the > conversation. > > I got the error using the non-Ed-Leafe-approved version of pymssql.py. It > is version 1.0.2. > > I decided to try Ed's pymssql.py, which says it is for version 0.8.0, and I > get an invalid connection error. Reprinted below: > > C:\Python25\lib\site-packages\dabo-0.9.2-py2.5.egg\dabo\lib\SimpleCrypt.py: >32: U serWarning: > WARNING: > Your application uses SimpleCrypt, which is fine for testing but should > not be used in production, because: > > 1) Anyone with a copy of Dabo could decrypt your password. > > 2) It isn't portable between 32-bit and 64-bit python. See the trac > ticket at http://trac.dabodev.com/ticket/1179 for more information. > > """, UserWarning) > Traceback (most recent call last): > File > "c:\python25\lib\site-packages\Dabo-0.9.2-py2.5.egg\dabo\ui\uiwx\dControl > Mixin.py", line 27, in _onWxHit > self.raiseEvent(dEvents.Hit, evt, *args, **kwargs) > File > "C:\Python25\lib\site-packages\dabo-0.9.2-py2.5.egg\dabo\ui\uiwx\dPemMixi > n.py", line 949, in raiseEvent > super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, > **kwargs) File > "C:\Python25\lib\site-packages\dabo-0.9.2-py2.5.egg\dabo\lib\eventMixin.p > y", line 93, in raiseEvent > bindingFunction(event) > File > "c:\python25\lib\site-packages\Dabo-0.9.2-py2.5.egg\dabo\ui\dialogs\Wizar > d.py", line 124, in onNext > self.CurrentPage += pg.nextPage() > File > "c:\python25\lib\site-packages\Dabo-0.9.2-py2.5.egg\dabo\ui\dialogs\Wizar > d.py", line 291, in _setCurrPage > ok = self._pages[self._currentPage].onLeavePage(direction) > File "C:\Program Files\Dabo\ide\wizards\AppWizard\AppWizard.py", line > 301, in onLeavePage > conn = dabo.db.dConnection(ci) > File > "C:\Python25\lib\site-packages\dabo-0.9.2-py2.5.egg\dabo\db\dConnection.p > y", line 32, in __init__ > self._connection = self._openConnection(**kwargs) > File > "C:\Python25\lib\site-packages\dabo-0.9.2-py2.5.egg\dabo\db\dConnection.p > y", line 79, in _openConnection > return self._connectInfo.getConnection(forceCreate=self._forceCreate, > **kwar gs) > File > "c:\python25\lib\site-packages\Dabo-0.9.2-py2.5.egg\dabo\db\dConnectInfo. > py", line 105, in getConnection > return self._backendObject.getConnection(self, **kwargs) > File > "C:\Python25\lib\site-packages\dabo-0.9.2-py2.5.egg\dabo\db\dbMsSQL.py", > line 37, in getConnection > database=database, **kwargs) > File "C:\Python25\lib\site-packages\pymssql.py", line 352, in connect > return pymssqlCnx(con) > File "C:\Python25\lib\site-packages\pymssql.py", line 251, in __init__ > raise OperationalError, "invalid connection." > pymssql.OperationalError: invalid connection. > > > > > > Jamie Adams First welcome to Dabo - Jamie. I doubt we can use Ed's version with all the changes dbMsSQL.py has at this time. I was just suggesting that the error you reported reminded me of the old errors we got. Can you make a connection using the CxnEditor.py (use the latest pymssql.py)? If so can you try using ClassDesigner.py and see if you can get a listing of the tables. Provide the traceback if there is an error. Of course if all works then it's something we have forgotten to provide for AppWizard. Johnf _______________________________________________ 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] _______________________________________________ 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/492640.681260223016093.javamail.sys...@jamie-mobile
