Re: [dabo-users] AppWizard Irregularity
I commented out the init Ed mentioned and here is the traceback for what I am seeing now. I am not certain the (db:dbName) is placing the database name in the select statement (as far as I can tell). When I run the exact query in the query analyzer in Enterprise Manager it returns the file names which is what we are looking for here. The DBQueryExecption class below is raised but that is where the program hangs. The select statement is failing and raising a DBQueryException but it doesn't tell us why the sql failed. C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File appwizard.py, line 305, in onLeavePage tables = cursor.getTables() File c:\pythonprojects\dabo\dabo\db\dCursorMixin.py, line 1956, in getTables return self.BackendObject.getTables(self.AuxCursor, includeSystemTables) File c:\pythonprojects\dabo\dabo\db\dbMsSQL.py, line 87, in getTables {'db':dbName} ) File c:\pythonprojects\dabo\dabo\db\dCursorMixin.py, line 332, in execute raise dException.DBQueryException(errMsg, 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 class DBQueryException(DatabaseException): def __init__(self, err, sql=None): self.err_desc = err.rstrip() self.sql = sql and sql.strip() or None def __str__(self): err = self.err_desc if self.sql: err += '\nSQL: ' + self.sql return err -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab110f2.2000...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
Ed Paul: I discovered the problems, corrected them and tested the changes in the appwizard and creating a bizobject in the class designer. All of the changes involved formatting of three select statements. They are all in dbMsSQL.py I am new at this so I don't know how to report the changes to you for your review. How should I communicate the corrections to you? -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab13b03.8030...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
Ed: I tried to register and got this: Secure Connection Failed trac.dabodev.com uses an invalid security certificate. The certificate is not trusted because the issuer certificate is unknown. (Error code: sec_error_unknown_issuer) * This could be a problem with the server's configuration, or it could be someone trying to impersonate the server. * If you have connected to this server successfully in the past, the error may be temporary, and you can try again later. Or you can add an exception… Ed Leafe wrote: The best way is to create a Trac ticket (http://trac.dabodev.com). This way it won't get lost in a flood of email. -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab140f4.4010...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Sep 16, 2009, at 2:48 PM, Jeff Johnson wrote: Or you can add an exception… It's a self-signed certificate. Firefox is super-paranoid about them. Just add the exception and proceed. -- 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/75a826f1-a694-46d6-8331-9ef53ee0a...@leafe.com
Re: [dabo-users] AppWizard Irregularity
Ed Leafe wrote: On Sep 16, 2009, at 2:48 PM, Jeff Johnson wrote: Or you can add an exception… It's a self-signed certificate. Firefox is super-paranoid about them. Just add the exception and proceed. Well, it's one-step above self-signed. It is signed by CACert. Paul ___ 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/4ab14282.3060...@ulmcnett.com
Re: [dabo-users] AppWizard Irregularity
Jeff Johnson wrote: How should I communicate the corrections to you? As Ed said, start a ticket, and then attach your changes to the ticket. If possible, you should attach a patch file, which is a 'diff -u' of the original file versus the changed file. If you are using subversion, it is easy to get the patch file: cd dabo/dabo/db svn diff mssql.patch and then attach mssql.patch to the ticket. Paul ___ 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/4ab1430d.9010...@ulmcnett.com
Re: [dabo-users] AppWizard Irregularity
Paul: Too late. I will do that next time. I submitted the dbMsSQL.py and identified the line numbers to be changed. If I messed anything else up, let me know. Thanks, Paul McNett wrote: Jeff Johnson wrote: How should I communicate the corrections to you? As Ed said, start a ticket, and then attach your changes to the ticket. If possible, you should attach a patch file, which is a 'diff -u' of the original file versus the changed file. If you are using subversion, it is easy to get the patch file: cd dabo/dabo/db svn diff mssql.patch and then attach mssql.patch to the ticket. Paul -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab149ab.4020...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Sep 16, 2009, at 3:25 PM, Jeff Johnson wrote: Paul: Too late. I will do that next time. I submitted the dbMsSQL.py and identified the line numbers to be changed. If I messed anything else up, let me know. No problem at all. Thanks for taking the time to do this. -- 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/2d030f28-872e-4399-bd04-775b14b54...@leafe.com
Re: [dabo-users] AppWizard Irregularity
C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File appwizard.py, line 305, in onLeavePage tables = cursor.getTables() File C:\PythonProjects\dabo\dabo\db\dCursorMixin.py, line 1932, in getTables return self.BackendObject.getTables(self.AuxCursor, includeSystemTables) File c:\pythonprojects\dabo\dabo\db\dbMsSQL.py, line 79, in getTables {'db':dbName} ) File C:\PythonProjects\dabo\dabo\db\dCursorMixin.py, line 330, in execute raise dException.DBQueryException(errMsg, sql) DBQueryException: pymssqlCnx instance has no attribute 'errmsg' SQL: select table_name from INFORMATION_SCHEMA.TABLES where table_catalog = %(db )s and table_type = 'BASE TABLE' order by table_name Ed Leafe wrote: On Sep 14, 2009, at 7:46 PM, Jeff Johnson wrote: DBQueryException: pymssqlCnx instance has no attribute 'errmsg' Hmmm... that message is passed on to the connection object, but there is no such method in that class. Can you open your copy of pymssql.py, and find this section of code: 290 # Added by EGL for Dabo, 2006.12.28 291 # These methods simply pass the request through to 292 # the actual connection. 293 def connected(self): 294 return self.__cnx.connected() 295 def errmsg(self): 296 return self.__cnx.errmsg() 297 def fetch_array(self): 298 return self.__cnx.fetch_array() Try commenting out lines 295 and 296 (the errmsg method), and let me know if that changes anything. -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aaf9bda.5000...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Sep 15, 2009, at 8:51 AM, Jeff Johnson wrote: DBQueryException: pymssqlCnx instance has no attribute 'errmsg' Is this *after* commenting out the lines I mentioned? -- 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/54f3a41a-4f3a-49da-8047-7c31cebbc...@leafe.com
Re: [dabo-users] AppWizard Irregularity
Ed: Yes. Sorry I did not make that clear. Ed Leafe wrote: On Sep 15, 2009, at 8:51 AM, Jeff Johnson wrote: DBQueryException: pymssqlCnx instance has no attribute 'errmsg' Is this *after* commenting out the lines I mentioned? -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aafa684.3040...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
Ed: I had a problem with interference from the egg. I reinstalled Dabo and ran the appwizard with lines 295 and 296 commented out and here is the traceback: C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File c:\pythonprojects\dabo\dabo\ui\uiwx\dControlMixin.py, line 27, in _onWx Hit self.raiseEvent(dEvents.Hit, evt, *args, **kwargs) File c:\pythonprojects\dabo\dabo\ui\uiwx\dPemMixin.py, line 949, in raiseEve nt super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, **kwargs) File c:\pythonprojects\dabo\dabo\lib\eventMixin.py, line 93, in raiseEvent bindingFunction(event) File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 124, in onNext self.CurrentPage += pg.nextPage() File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 291, in _setCurr Page ok = self._pages[self._currentPage].onLeavePage(direction) File appwizard.py, line 302, in onLeavePage cursor = self.Form.cursor = conn.getDaboCursor(ci.getDictCursorClass()) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 67, in getDaboCurso r crs = bo.getCursor(DaboCursor) File c:\pythonprojects\dabo\dabo\db\dBackend.py, line 72, in getCursor return cursorClass(self._connection) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 64, in __init__ apply(cursorClass.__init__,(self,) + args, kwargs) File c:\pythonprojects\dabo\dabo\db\dbMsSQL.py, line 46, in __init__ self.super(src._cnx) File c:\pythonprojects\dabo\dabo\lib\autosuper\autosuper.py, line 457, in _g etSuper return _super(cur_class, self, name) File c:\pythonprojects\dabo\dabo\lib\autosuper\autosuper.py, line 157, in __ init__ super = builtin_super(klass, obj) TypeError: super() argument 1 must be type, not classobj Ed Leafe wrote: On Sep 15, 2009, at 8:51 AM, Jeff Johnson wrote: DBQueryException: pymssqlCnx instance has no attribute 'errmsg' Is this *after* commenting out the lines I mentioned? -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aaff902.9090...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Monday 14 September 2009 05:52:32 pm Jeff Johnson wrote: Ed: For background on this, I created an app with the appwizard using PostgreSQL and was using the command window to create a connection to the MsSQL database with no problems. I wanted some code from an app built on the MsSQL database so I was attempting to create this app using the appwizard when I ran into this problem. Thanks, Ed Leafe wrote: After you fix that, delete the egg, and then open the easy_install.pth file in the site-packages directory, and delete the line for the dabo egg. -- Ed Leafe Jeff, Where did you get pymssql.py - was it from Dabo? Johnf ___ 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/200909151335.56552.jfabi...@yolo.com
Re: [dabo-users] AppWizard Irregularity
John: Yes. In order to comment out the lines Ed mentioned I had to get a Dabo pymssql.py. John wrote: On Monday 14 September 2009 05:52:32 pm Jeff Johnson wrote: Ed: For background on this, I created an app with the appwizard using PostgreSQL and was using the command window to create a connection to the MsSQL database with no problems. I wanted some code from an app built on the MsSQL database so I was attempting to create this app using the appwizard when I ran into this problem. Thanks, Ed Leafe wrote: After you fix that, delete the egg, and then open the easy_install.pth file in the site-packages directory, and delete the line for the dabo egg. -- Ed Leafe Jeff, Where did you get pymssql.py - was it from Dabo? Johnf -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aafff62.7050...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Tuesday 15 September 2009 01:56:02 pm Jeff Johnson wrote: John: Yes. In order to comment out the lines Ed mentioned I had to get a Dabo pymssql.py. The error appears to be with code that has worked for a very long time. There has to be something different. I'm just wondering where/what that difference is. You did say the code worked with CxmlEditor but not your code. Here is another test. Try using ClassDesigner to create a bizobj using the connection. Johnf ___ 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/200909151412.54588.jfabi...@yolo.com
Re: [dabo-users] AppWizard Irregularity
John: Could not make connection to database with no traceback. John wrote: On Tuesday 15 September 2009 01:56:02 pm Jeff Johnson wrote: John: Yes. In order to comment out the lines Ed mentioned I had to get a Dabo pymssql.py. The error appears to be with code that has worked for a very long time. There has to be something different. I'm just wondering where/what that difference is. You did say the code worked with CxmlEditor but not your code. Here is another test. Try using ClassDesigner to create a bizobj using the connection. Johnf -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab0142c.4060...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Tuesday 15 September 2009 3:24:44 pm Jeff Johnson wrote: John: Could not make connection to database with no traceback. Seemed to me from your first report that the connection did not have the name of the database. This looks like one of those step by step things. 1) Can you make a connection to the MsSQL Server via other means from the computer the Dabo app is running on ? 2) Does the connection (cnxml) file db information look correct? 3) How are passing the connection information into your hand coded app ? 4) Is there a way to log the connection attempts on the MsSQL Server and see if they are even being attempted and if so if there any errors in the logs ? -- Adrian Klaver akla...@comcast.net ___ 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/200909151532.09838.akla...@comcast.net
Re: [dabo-users] AppWizard Irregularity
Jeff Johnson wrote: Ed: I had a problem with interference from the egg. I reinstalled Dabo and ran the appwizard with lines 295 and 296 commented out and here is the traceback: C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File c:\pythonprojects\dabo\dabo\ui\uiwx\dControlMixin.py, line 27, in _onWx Hit self.raiseEvent(dEvents.Hit, evt, *args, **kwargs) File c:\pythonprojects\dabo\dabo\ui\uiwx\dPemMixin.py, line 949, in raiseEve nt super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, **kwargs) File c:\pythonprojects\dabo\dabo\lib\eventMixin.py, line 93, in raiseEvent bindingFunction(event) File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 124, in onNext self.CurrentPage += pg.nextPage() File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 291, in _setCurr Page ok = self._pages[self._currentPage].onLeavePage(direction) File appwizard.py, line 302, in onLeavePage cursor = self.Form.cursor = conn.getDaboCursor(ci.getDictCursorClass()) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 67, in getDaboCurso r crs = bo.getCursor(DaboCursor) File c:\pythonprojects\dabo\dabo\db\dBackend.py, line 72, in getCursor return cursorClass(self._connection) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 64, in __init__ apply(cursorClass.__init__,(self,) + args, kwargs) File c:\pythonprojects\dabo\dabo\db\dbMsSQL.py, line 46, in __init__ self.super(src._cnx) File c:\pythonprojects\dabo\dabo\lib\autosuper\autosuper.py, line 457, in _g etSuper return _super(cur_class, self, name) File c:\pythonprojects\dabo\dabo\lib\autosuper\autosuper.py, line 157, in __ init__ super = builtin_super(klass, obj) TypeError: super() argument 1 must be type, not classobj in dbMsSQL.py, around line 46 of __init__, comment out the self.super() call and replace with: print self:, self print type(self):, type(self) print src._cnx super(dbMsSQL, self).__init__(src._cnx) And let's see the entire output. Paul ___ 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/4ab016bd.8080...@ulmcnett.com
Re: [dabo-users] AppWizard Irregularity
Paul: Here are the results: C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py self: dabo.db.dConnection.DaboCursor (baseclass dabo.db.dConnection.DaboCursor, id:55169104) type(self): class 'dabo.db.dConnection.DaboCursor' Traceback (most recent call last): File c:\pythonprojects\dabo\dabo\ui\uiwx\dControlMixin.py, line 27, in _onWx Hit self.raiseEvent(dEvents.Hit, evt, *args, **kwargs) File c:\pythonprojects\dabo\dabo\ui\uiwx\dPemMixin.py, line 949, in raiseEve nt super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, **kwargs) File c:\pythonprojects\dabo\dabo\lib\eventMixin.py, line 93, in raiseEvent bindingFunction(event) File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 124, in onNext self.CurrentPage += pg.nextPage() File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 291, in _setCurr Page ok = self._pages[self._currentPage].onLeavePage(direction) File appwizard.py, line 302, in onLeavePage cursor = self.Form.cursor = conn.getDaboCursor(ci.getDictCursorClass()) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 67, in getDaboCurso r crs = bo.getCursor(DaboCursor) File c:\pythonprojects\dabo\dabo\db\dBackend.py, line 72, in getCursor return cursorClass(self._connection) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 64, in __init__ apply(cursorClass.__init__,(self,) + args, kwargs) File c:\pythonprojects\dabo\dabo\db\dbMsSQL.py, line 50, in __init__ print src._cnx AttributeError: pymssqlCnx instance has no attribute '_cnx' Paul McNett wrote: in dbMsSQL.py, around line 46 of __init__, comment out the self.super() call and replace with: print self:, self print type(self):, type(self) print src._cnx super(dbMsSQL, self).__init__(src._cnx) And let's see the entire output. Paul -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab01d40.2090...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
Adrian: See in line notes below: Adrian Klaver wrote: On Tuesday 15 September 2009 3:24:44 pm Jeff Johnson wrote: John: Could not make connection to database with no traceback. Seemed to me from your first report that the connection did not have the name of the database. This looks like one of those step by step things. 1) Can you make a connection to the MsSQL Server via other means from the computer the Dabo app is running on ? Yes. Enterprise Manager and VFP ODBC. 2) Does the connection (cnxml) file db information look correct? Yes and it works in the connection editor 3) How are passing the connection information into your hand coded app ? app.dbConnection = app.getConnectionByName(SanDC MsSQL) 4) Is there a way to log the connection attempts on the MsSQL Server and see if they are even being attempted and if so if there any errors in the logs ? I will look. Thanks, -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab01e23.7050...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
Jeff Johnson wrote: AttributeError: pymssqlCnx instance has no attribute '_cnx' Okay, this is likely the root cause of the problems. Ed, why would src._cnx not be defined? Paul ___ 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/4ab01cba.30...@ulmcnett.com
Re: [dabo-users] AppWizard Irregularity
On Tuesday 15 September 2009 4:07:15 pm Jeff Johnson wrote: Adrian: See in line notes below: Adrian Klaver wrote: On Tuesday 15 September 2009 3:24:44 pm Jeff Johnson wrote: John: Could not make connection to database with no traceback. Seemed to me from your first report that the connection did not have the name of the database. This looks like one of those step by step things. 1) Can you make a connection to the MsSQL Server via other means from the computer the Dabo app is running on ? Yes. Enterprise Manager and VFP ODBC. 2) Does the connection (cnxml) file db information look correct? Yes and it works in the connection editor 3) How are passing the connection information into your hand coded app ? app.dbConnection = app.getConnectionByName(SanDC MsSQL) Is there a app.addConnectFile() somewhere before this? 4) Is there a way to log the connection attempts on the MsSQL Server and see if they are even being attempted and if so if there any errors in the logs ? I will look. Thanks, -- Adrian Klaver akla...@comcast.net ___ 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/200909151608.18247.akla...@comcast.net
Re: [dabo-users] AppWizard Irregularity
Adrian Klaver wrote: On Tuesday 15 September 2009 4:07:15 pm Jeff Johnson wrote: 3) How are passing the connection information into your hand coded app ? app.dbConnection = app.getConnectionByName(SanDC MsSQL) Is there a app.addConnectFile() somewhere before this? This works fine. I substituted this for the PostgreSQL named connection to see if it works and it works fine. -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab022ab.7090...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Tuesday 15 September 2009 04:26:35 pm Jeff Johnson wrote: Adrian Klaver wrote: On Tuesday 15 September 2009 4:07:15 pm Jeff Johnson wrote: 3) How are passing the connection information into your hand coded app ? app.dbConnection = app.getConnectionByName(SanDC MsSQL) Is there a app.addConnectFile() somewhere before this? This works fine. I substituted this for the PostgreSQL named connection to see if it works and it works fine. If you only have one cnxml file the above will work fine because Dabo will default to the cnxml file. Also works if there is a default.cnxml. Johnf ___ 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/200909151628.09240.jfabi...@yolo.com
Re: [dabo-users] AppWizard Irregularity
On Tuesday 15 September 2009 3:35:41 pm Paul McNett wrote: Jeff Johnson wrote: Ed: I had a problem with interference from the egg. I reinstalled Dabo and ran the appwizard with lines 295 and 296 commented out and here is the traceback: C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File c:\pythonprojects\dabo\dabo\ui\uiwx\dControlMixin.py, line 27, in _onWx Hit self.raiseEvent(dEvents.Hit, evt, *args, **kwargs) File c:\pythonprojects\dabo\dabo\ui\uiwx\dPemMixin.py, line 949, in raiseEve nt super(dPemMixin, self).raiseEvent(eventClass, nativeEvent, *args, **kwargs) File c:\pythonprojects\dabo\dabo\lib\eventMixin.py, line 93, in raiseEvent bindingFunction(event) File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 124, in onNext self.CurrentPage += pg.nextPage() File c:\pythonprojects\dabo\dabo\ui\dialogs\Wizard.py, line 291, in _setCurr Page ok = self._pages[self._currentPage].onLeavePage(direction) File appwizard.py, line 302, in onLeavePage cursor = self.Form.cursor = conn.getDaboCursor(ci.getDictCursorClass()) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 67, in getDaboCurso r crs = bo.getCursor(DaboCursor) File c:\pythonprojects\dabo\dabo\db\dBackend.py, line 72, in getCursor return cursorClass(self._connection) File c:\pythonprojects\dabo\dabo\db\dConnection.py, line 64, in __init__ apply(cursorClass.__init__,(self,) + args, kwargs) File c:\pythonprojects\dabo\dabo\db\dbMsSQL.py, line 46, in __init__ self.super(src._cnx) File c:\pythonprojects\dabo\dabo\lib\autosuper\autosuper.py, line 457, in _g etSuper return _super(cur_class, self, name) File c:\pythonprojects\dabo\dabo\lib\autosuper\autosuper.py, line 157, in __ init__ super = builtin_super(klass, obj) TypeError: super() argument 1 must be type, not classobj in dbMsSQL.py, around line 46 of __init__, comment out the self.super() call and replace with: print self:, self print type(self):, type(self) print src._cnx super(dbMsSQL, self).__init__(src._cnx) And let's see the entire output. Paul Just out of curiosity what is the file date on your version of dbMsSQL.py ? I am not seeing a self.super() in my version (2009-04-15 04:03 dbMsSQL.py) -- Adrian Klaver akla...@comcast.net ___ 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/200909151714.20136.akla...@comcast.net
Re: [dabo-users] AppWizard Irregularity
On Sep 15, 2009, at 6:01 PM, Paul McNett wrote: AttributeError: pymssqlCnx instance has no attribute '_cnx' Okay, this is likely the root cause of the problems. Ed, why would src._cnx not be defined? Because the code was never fully tested? ;-) Here's the method in question; note the docstring: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - def getDictCursorClass(self): Currently this is not working completely import pymssql class conCursor(pymssql.pymssqlCursor): def __init__(self, src): self.super(src._cnx) def _getconn(self): return self.__source # pymssql doesn't supply this optional dbapi attribute, so create it here. connection = property(_getconn, None, None) return conCursor #return cursors.Connection.cursor #return self._connection.cursor() - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - I suggest removing the entire __init__() method - it doesn't seem like it's needed. -- 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/0574f1f1-c861-4021-b53b-0f9c88bcd...@leafe.com
Re: [dabo-users] AppWizard Irregularity
On Tuesday 15 September 2009 5:14:19 pm Adrian Klaver wrote: On Tuesday 15 September 2009 3:35:41 pm Paul McNett wrote: Just out of curiosity what is the file date on your version of dbMsSQL.py ? I am not seeing a self.super() in my version (2009-04-15 04:03 dbMsSQL.py) Just realized I was looking at the wrong version of the file (from 0.9.1) in my editor. Though I do have another question. The FAQ says the most recent Web Update is 5241. My version seems to be stuck on 5240. Am I doing something wrong? -- Adrian Klaver akla...@comcast.net ___ 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/200909151729.42050.akla...@comcast.net
Re: [dabo-users] AppWizard Irregularity
On Tuesday 15 September 2009 5:29:41 pm Adrian Klaver wrote: On Tuesday 15 September 2009 5:14:19 pm Adrian Klaver wrote: On Tuesday 15 September 2009 3:35:41 pm Paul McNett wrote: Just out of curiosity what is the file date on your version of dbMsSQL.py ? I am not seeing a self.super() in my version (2009-04-15 04:03 dbMsSQL.py) Just realized I was looking at the wrong version of the file (from 0.9.1) in my editor. Though I do have another question. The FAQ says the most recent Web Update is 5241. My version seems to be stuck on 5240. Am I doing something wrong? Time to go get something to eat. My version is at 5340 not 5240 and all is well. -- Adrian Klaver akla...@comcast.net ___ 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/200909151734.52084.akla...@comcast.net
Re: [dabo-users] AppWizard Irregularity
Thank Ed - and Paul and John and Adrian: I will get into this tomorrow and follow it through. The only time it fails is when it tries to gather all of the tables in the class designer or the app wizard. I have no problems with the connection or accessing the connection in code. Thanks for all of your help! Ed Leafe wrote: On Sep 15, 2009, at 6:01 PM, Paul McNett wrote: AttributeError: pymssqlCnx instance has no attribute '_cnx' Okay, this is likely the root cause of the problems. Ed, why would src._cnx not be defined? Because the code was never fully tested? ;-) Here's the method in question; note the docstring: - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - def getDictCursorClass(self): Currently this is not working completely import pymssql class conCursor(pymssql.pymssqlCursor): def __init__(self, src): self.super(src._cnx) def _getconn(self): return self.__source # pymssql doesn't supply this optional dbapi attribute, so create it here. connection = property(_getconn, None, None) return conCursor #return cursors.Connection.cursor #return self._connection.cursor() - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - I suggest removing the entire __init__() method - it doesn't seem like it's needed. -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4ab049d8.3060...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
Jeff Johnson wrote: I used the connection editor to create a connection to MsSQL. The connection tested fine. Then I went to the appwizard to create an application. The appwizard could not connect to the database using the connection that tested fine. H? Any output to the terminal? Paul ___ 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/4aaed4c5.3030...@ulmcnett.com
Re: [dabo-users] AppWizard Irregularity
I was running pythonw so here is what I found: C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File appwizard.py, line 305, in onLeavePage tables = cursor.getTables() File C:\Python25\lib\site-packages\dabo-0.9.1-py2.5.egg\dabo\db\dCursorMixin. py, line 1947, in getTables return self.BackendObject.getTables(self.AuxCursor, includeSystemTables) File c:\python25\lib\site-packages\Dabo-0.9.1-py2.5.egg\dabo\db\dbMsSQL.py, line 79, in getTables {'db':dbName} ) File C:\Python25\lib\site-packages\dabo-0.9.1-py2.5.egg\dabo\db\dCursorMixin. py, line 330, in execute raise dException.DBQueryException(errMsg, sql) DBQueryException: pymssqlCnx instance has no attribute 'errmsg' SQL: select table_name from INFORMATION_SCHEMA.TABLES where table_catalog = %(db )s and table_type = 'BASE TABLE' order by table_name Why is it running the egg? I have a dabo.pth that has c:\pythonprojects\dabo\dabo in it. -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aaedc8d.9080...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Monday 14 September 2009 5:15:09 pm Jeff Johnson wrote: I was running pythonw so here is what I found: C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File appwizard.py, line 305, in onLeavePage tables = cursor.getTables() File C:\Python25\lib\site-packages\dabo-0.9.1-py2.5.egg\dabo\db\dCursorMixin. py, line 1947, in getTables return self.BackendObject.getTables(self.AuxCursor, includeSystemTables) File c:\python25\lib\site-packages\Dabo-0.9.1-py2.5.egg\dabo\db\dbMsSQL.py, line 79, in getTables {'db':dbName} ) File C:\Python25\lib\site-packages\dabo-0.9.1-py2.5.egg\dabo\db\dCursorMixin. py, line 330, in execute raise dException.DBQueryException(errMsg, sql) DBQueryException: pymssqlCnx instance has no attribute 'errmsg' SQL: select table_name from INFORMATION_SCHEMA.TABLES where table_catalog = %(db )s and table_type = 'BASE TABLE' order by table_name Why is it running the egg? I have a dabo.pth that has c:\pythonprojects\dabo\dabo in it. The egg is in sys.path before c:\pythonprojects\dabo\dabo ? -- Adrian Klaver akla...@comcast.net ___ 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/200909141717.36894.akla...@comcast.net
Re: [dabo-users] AppWizard Irregularity
On Sep 14, 2009, at 7:15 PM, Jeff Johnson wrote: Why is it running the egg? I have a dabo.pth that has c:\pythonprojects\dabo\dabo in it. Why do you have an egg installed if you are using a separate copy, as referenced by your dabo.pth file? Also, it looks like the .pth file is incorrect: it should be the path to the folder that contains the dabo module, not the path to the module. IOW, find the path that contains dApp.py: that's the module path. Your .pth file should be the folder in which the module sits. E.g.: if you have c:\pythonprojects\dabo\dabo\dApp.py ... your dabo.pth file should read: c:\pythonprojects\dabo After you fix that, delete the egg, and then open the easy_install.pth file in the site-packages directory, and delete the line for the dabo egg. -- 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/a7d407b6-3fc2-4cbf-9e9f-3ad92aabb...@leafe.com
Re: [dabo-users] AppWizard Irregularity
Ed: I did not want to install the egg. I deleted it from my Linux machine but forgot to delete it from my XP machine. Here is what I get now after following your instructions below C:\PythonProjects\dabo\ide\wizards\AppWizardpython appwizard.py Traceback (most recent call last): File appwizard.py, line 305, in onLeavePage tables = cursor.getTables() File C:\PythonProjects\dabo\dabo\db\dCursorMixin.py, line 1932, in getTables return self.BackendObject.getTables(self.AuxCursor, includeSystemTables) File c:\pythonprojects\dabo\dabo\db\dbMsSQL.py, line 79, in getTables {'db':dbName} ) File C:\PythonProjects\dabo\dabo\db\dCursorMixin.py, line 330, in execute raise dException.DBQueryException(errMsg, sql) DBQueryException: pymssqlCnx instance has no attribute 'errmsg' SQL: select table_name from INFORMATION_SCHEMA.TABLES where table_catalog = %(db )s and table_type = 'BASE TABLE' order by table_name Ed Leafe wrote: On Sep 14, 2009, at 7:15 PM, Jeff Johnson wrote: Why is it running the egg? I have a dabo.pth that has c:\pythonprojects\dabo\dabo in it. Why do you have an egg installed if you are using a separate copy, as referenced by your dabo.pth file? Also, it looks like the .pth file is incorrect: it should be the path to the folder that contains the dabo module, not the path to the module. IOW, find the path that contains dApp.py: that's the module path. Your .pth file should be the folder in which the module sits. E.g.: if you have c:\pythonprojects\dabo\dabo\dApp.py ... your dabo.pth file should read: c:\pythonprojects\dabo After you fix that, delete the egg, and then open the easy_install.pth file in the site-packages directory, and delete the line for the dabo egg. -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aaee3ca.4080...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
Ed: For background on this, I created an app with the appwizard using PostgreSQL and was using the command window to create a connection to the MsSQL database with no problems. I wanted some code from an app built on the MsSQL database so I was attempting to create this app using the appwizard when I ran into this problem. Thanks, Ed Leafe wrote: After you fix that, delete the egg, and then open the easy_install.pth file in the site-packages directory, and delete the line for the dabo egg. -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aaee550.2020...@dcsoftware.com
Re: [dabo-users] AppWizard Irregularity
On Sep 14, 2009, at 7:46 PM, Jeff Johnson wrote: DBQueryException: pymssqlCnx instance has no attribute 'errmsg' Hmmm... that message is passed on to the connection object, but there is no such method in that class. Can you open your copy of pymssql.py, and find this section of code: 290 # Added by EGL for Dabo, 2006.12.28 291 # These methods simply pass the request through to 292 # the actual connection. 293 def connected(self): 294 return self.__cnx.connected() 295 def errmsg(self): 296 return self.__cnx.errmsg() 297 def fetch_array(self): 298 return self.__cnx.fetch_array() Try commenting out lines 295 and 296 (the errmsg method), and let me know if that changes anything. -- 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/c5497c6f-7e95-4216-9156-8fd890cab...@leafe.com
Re: [dabo-users] AppWizard Irregularity
On Monday 14 September 2009 06:02:56 pm Ed Leafe wrote: On Sep 14, 2009, at 7:46 PM, Jeff Johnson wrote: DBQueryException: pymssqlCnx instance has no attribute 'errmsg' Hmmm... that message is passed on to the connection object, but there is no such method in that class. Can you open your copy of pymssql.py, and find this section of code: 290 # Added by EGL for Dabo, 2006.12.28 291 # These methods simply pass the request through to 292 # the actual connection. 293 def connected(self): 294 return self.__cnx.connected() 295 def errmsg(self): 296 return self.__cnx.errmsg() 297 def fetch_array(self): 298 return self.__cnx.fetch_array() Try commenting out lines 295 and 296 (the errmsg method), and let me know if that changes anything. -- Ed Leafe I recall that there is a new version of pymssql.py. Maybe the new version is causing the issue? What is the version of pymssql.py being used? Johnf ___ 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/200909141824.07482.jfabi...@yolo.com
Re: [dabo-users] AppWizard Irregularity
On Sep 14, 2009, at 8:24 PM, John wrote: I recall that there is a new version of pymssql.py. Maybe the new version is causing the issue? What is the version of pymssql.py being used? I don't think we actually versioned it. Just make sure that it's the same as this: http://cdn.cloudfiles.mosso.com/c118811/dabo/pymssql.py -- 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/b22e63ed-5d14-401b-823d-ad8da820a...@leafe.com
Re: [dabo-users] AppWizard Irregularity
Ed: That may be a problem. The only pymssql.py I have is in site-packages and there is no mention of dabo. Ed Leafe wrote: On Sep 14, 2009, at 7:46 PM, Jeff Johnson wrote: DBQueryException: pymssqlCnx instance has no attribute 'errmsg' Hmmm... that message is passed on to the connection object, but there is no such method in that class. Can you open your copy of pymssql.py, and find this section of code: 290 # Added by EGL for Dabo, 2006.12.28 291 # These methods simply pass the request through to 292 # the actual connection. 293 def connected(self): 294 return self.__cnx.connected() 295 def errmsg(self): 296 return self.__cnx.errmsg() 297 def fetch_array(self): 298 return self.__cnx.fetch_array() Try commenting out lines 295 and 296 (the errmsg method), and let me know if that changes anything. -- Ed Leafe -- Jeff Jeff Johnson j...@dcsoftware.com Phoenix Python User Group - sunpigg...@googlegroups.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/4aaef31e.7080...@dcsoftware.com