just use cursor.close() to close the cursor. is leaking in the sample... Henrik
>reply to message: >date: 25.10.2010 13:51:12 >from: "Steven L Smith" <ssmit...@naz.edu> >to: "Django users" <django-users@googlegroups.com> >subject: Connecting to Multiple MSSQL Databases... I've hit an edge case. >Help, please! > >For one of our apps, I'm using django-pyodbc to connect to an MS SQL >2005 database (not my choice...) This database contains, among other >things, rows for the Person model. I've written a function to connect >to "Lenel", an access-card system used by our campus security >department, which pulls the photos (stored as blobs in their MS SQL >2008 database). > >Both the Person model queries, and the Lenel-photo-pulling function >work great... by themselves. But when they're put together, they don't >work. Basically, if I've loaded *anything* from myapp.models, the >get_photo_from_lenel function fails. > >From what I can tell, Django (or django-pyodbc) isn't cleaning up its >connection to MSSQL DB #1, and when I use pyodbc to connect to MSSQL >DB #2, it seems to be routing it somewhere else. But that's just a >guess? > >I read that the connection persists as long as the object exists, so I >tried "del me" and "del Person", but the error message still shows up, >unless I restart my python shell. > >This is my function: >http://dpaste.com/hold/263816/ > >And this is what happens when I use it: >>>> from naz.directories.getphotos import get_photo_from_lenel >>>> nazid = u'1237946' >>>> tuple(get_photo_from_lenel(naz_id=nazid)) >(14439, '1234567', <read-only buffer for 0x18482b0, size 11387, offset >0 at 0x1a04fb0>) > > >>>> from naz.directories.getphotos import get_photo_from_lenel >>>> from naz.directories.models import Person >>>> me = Person.objects.get(nazid=1234567) >>>> nazid = me.nazid >>>> nazid = u'1234567' >>>> get_photo_from_lenel(naz_id=nazid) >>>> tuple(get_photo_from_lenel(naz_id=nazid)) >Traceback (most recent call last): > File "<console>", line 1, in <module> > File "/var/django/naz/../naz/directories/getphotos.py", line 112, in >get_photo_from_lenel > cursor.execute(query) >Error: ('IM001', '[IM001] [unixODBC][Driver Manager]Driver does not >support this function (0) (SQLColAttribute)') > >-- >You received this message because you are subscribed to the Google Groups >"Django users" group. >To post to this group, send email to django-us...@googlegroups.com. >To unsubscribe from this group, send email to >django-users+unsubscr...@googlegroups.com. >For more options, visit this group at >http://groups.google.com/group/django-users?hl=en. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
