Thanks for the reply John. I saw something about this while doing my search for a soultion. I'll take a look at your later post and see if I can make heads or tails of it and perhaps give it a try.
Thanks again guys for all your help to date. I'm sure this will get resolved eventually Carey On Wed, Dec 5, 2012 at 7:28 PM, John Fabiani <[email protected]> wrote: > 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<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<http://mail.leafe.com/mailman/listinfo/dabo-users> >>>>> Searchable Archives: >>>>> http://leafe.com/archives/**search/dabo-users<http://leafe.com/archives/search/dabo-users> >>>>> This message: >>>>> http://leafe.com/archives/**byMID/C2AA8310-517D-4C67-8435-** >>>>> [email protected]<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 <http://mail.leafe.com/mailman/listinfo/dabo-users> >>> Searchable Archives: >>> http://leafe.com/archives/**search/dabo-users<http://leafe.com/archives/search/dabo-users> >>> This message: http://leafe.com/archives/**byMID/** >>> CAMGTPFEBVEJKhKsnMWKsUaZMsoov+**j+EMKbeuX21FJOWntHZuA@mail.**gmail.com<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 <http://mail.leafe.com/mailman/listinfo/dabo-users> >> Searchable Archives: >> http://leafe.com/archives/**search/dabo-users<http://leafe.com/archives/search/dabo-users> >> This message: http://leafe.com/archives/**byMID/50BFEE4E.30505@ulmcnett.* >> *com <http://leafe.com/archives/byMID/[email protected]> >> >> > ______________________________**_________________ > Post Messages to: [email protected] > Subscription Maintenance: http://mail.leafe.com/mailman/** > listinfo/dabo-users <http://mail.leafe.com/mailman/listinfo/dabo-users> > Searchable Archives: > http://leafe.com/archives/**search/dabo-users<http://leafe.com/archives/search/dabo-users> > This message: http://leafe.com/archives/**byMID/50BFF4A9.5090707@** > jfcomputer.com<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/CAMGTPFGBK+3HFJsFS9Szy9MkvsRf4F7=qccjjqp8u4i9j-e...@mail.gmail.com
