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]
