I realize that this bit of info is late and I'm sorry - have you
considered using pyODBC? I have used it in the past and others have
posted special setups to allow the use of ODBC. It requires hand coding
a connection file and creating a new dbODBC.py in dabo/db. I have
posted my solution and I believe two others posted their ODBC solutions
on this list. Unfortunately I can't find my solution or I would post
it. But I know it has been posted and I believe you should be able to
find it in the archives.
I used pyodbc to import 54 gigs of data into Postgres without any issues.
Johnf
On 12/05/2012 05:01 PM, Paul McNett wrote:
Unfortunately Dabo ate the original exception so it's impossible to know what
the
callstack is making it hard to pinpoint. Do this:
1) edit dabo/dabo/db/dCursorMixin.py
2) search for "error fetching records", there should be 1 occurence at about
line 414.
3) go up to about line 407 (the 'except Exception, e:' line)
4) right after that line, indent 3 tabs and type "raise" without the quotes
5) save
6) now run your script and you should see a full stacktrace now. Post that.
Thanks
Paul
On 12/5/12 4:17 PM, Carey Gagnon wrote:
Bump
Anyone? This doesn't seem to be a pymssql problem as it works fine on it's
own. Once Dabo is involved I get the error:
Error fetching records: (<type 'exceptions.UnboundLocalError'>, local
variable 'row' referenced before assignment)
There are several references to the variable row (row = blahblah..) in
dCursorMixin.py, 14 to be exact, but I don't know enough about python to do
much about it.
Can anyone help please?
Thanks
Carey
On Mon, Dec 3, 2012 at 7:20 PM, Carey Gagnon <[email protected]>wrote:
That was pretty much the full traceback Ed, but here's the entire
enchilada:
C:\src\ide\wizards\AppWizard>AppWizard.py
C:\src\dabo\lib\SimpleCrypt.py:52: UserWarning: WARNING: SimpleCrypt is
not secu
re. Please see http://wiki.dabodev.com/SimpleCrypt for more information
warnings.warn("WARNING: SimpleCrypt is not secure. Please see
http://wiki.dabo
dev.com/SimpleCrypt for more information")
2012-12-03 19:14:37 - ERROR - Error fetching records: (<type
'exceptions.UnboundLocalError'>, local variable 'row' referenced before
assignment)
Thanks
Carey
On Mon, Dec 3, 2012 at 7:04 PM, Ed Leafe <[email protected]> wrote:
On Dec 3, 2012, at 6:35 PM, Carey Gagnon <[email protected]>
wrote:
Then I run the appwizard (all installed Dabo components at revision
7288).
It connects to the database but doesn't show tables or anything
throwing
the following error:
Error fetching records: (<type 'exceptions.UnboundLocalError'>, local
variable 'row' referenced before assignment)
Is this a Dabo error or a pymssql error?
Could you post the full traceback? That will show where the error
originated.
-- Ed Leafe
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance:
http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/[email protected]
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/camgtpfebvejkhksnmwksuazmsoov+j+emkbeux21fjownth...@mail.gmail.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.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://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
