[Bug 918896] Re: returns no data from SQL server
distribution package python-pymssql 1.0.2+dfsg-1 for amd64 architecture in raring (Ubuntu 13.04) still does the very same. I have previously compiled the sources downloaded from http://code.google.com/p/pymssql/downloads/detail?name=pymssql-2.0.0b1-dev-20111019.tar.gzcan=2q= and set PYTHONPATH environment variable to point also to the folders containing the so binaries. By doing so it works for me. (I just realized there is a newer tarball http://code.google.com/p/pymssql/downloads/detail?name=pymssql-2.0.0b1-dev-20130403.tar.gzcan=2q= same version number, but have not tested that one yet.) note also another problem with the pymssql shipped with distro, though you get an empty result, the nextresult() method of the cursor will always return True, so you can easily jump in an endless loop -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/918896 Title: returns no data from SQL server To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 633882] Re: nextresult method in _mssql connect always returns True, and never points to next result set if there is any more
Dear Peter, thanks much for being helpful and prompt on my notice so fast. I compiled the shared objects of the module for my environments, so my wish is of lower priority ;) Although, honestly, I have tested my compilation only for few cases and did not do it so professional. So still, if you find time later to nicely package it I'm pretty sure to move for it. :) Thank you again in advance. I see the package is not maintained actively any longer and even the sources of the code are updated quite long ago... I wonder how to stress in a forum to replace the not working stuff with the latest one, otherwise having a not working package in a distribution is rather deluding ;) Bests, Józsi -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/633882 Title: nextresult method in _mssql connect always returns True, and never points to next result set if there is any more To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/633882/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 633882] Re: nextresult method in _mssql connect always returns True, and never points to next result set if there is any more
Dear Peter, I happen to need working python-pymssql package again with which long ago you helped me out. I was upgrading to Ubuntu oneiric, and have access to Ubuntu precise machines, where in either cases this original problem is still there, and I guess your fixes did not penetrate either. ;( I was wondering if you have resources or do you think it'd make sense supporting this package for new(er) versions of Ubi? Please, let me know. Best regards, S.J. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/633882 Title: nextresult method in _mssql connect always returns True, and never points to next result set if there is any more To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/633882/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 633882] [NEW] nextresult method in _mssql connect always returns True, and never points to next result set if there is any more
Public bug reported:
Dear Maintainer,
I am struggling with a strange issue concerning python-pymssql package,
which may be related to bux #463830 The problem questions the usability
of the module. It occurs when importing and using the native _mssql
module from the up-to-date (python-pymssql 1.0.2+dfsg-1) version of the
package.
Problems:
* It seems that only the first result set of a query is retrievable,
* The nextresult() method of the connection will always return True and will
not point to the next result set if any.
System:
$ lsb_release -rd
Description:Ubuntu 10.04.1 LTS
Release:10.04
$ apt-cache policy python-pymssql
python-pymssql:
Installed: 1.0.2+dfsg-1
Candidate: 1.0.2+dfsg-1
Version table:
*** 1.0.2+dfsg-1 0
500 http://hu.archive.ubuntu.com/ubuntu/ lucid/universe Packages
100 /var/lib/dpkg/status
Note, I tried to compile the new version of python-pymssql from
http://code.google.com/p/pymssql/downloads/detail?name=pymssql-1.9.908.tar.gzcan=2q=
but the cython package required and available in the distribution
conflicts in version.
The sequence of commands to generate erronous behaviour:
#
$ python
Python 2.6.5 (r265:79063, Apr 16 2010, 13:57:41)
[GCC 4.4.3] on linux2
Type help, copyright, credits or license for more information.
import _mssql
C=_mssql.connect(user='d2ruser', password='XXX', server='XXX',
database='XXX')
C.execute_query('SELECT current_user; SELECT GETDATE();') for r in C:
print r
...
{0: 'd2ruser'}
C.nextresult()
1
for r in C: print r
...
C.nextresult()
1
C.nextresult()
1
#
As a comparison the same command set works in debian lenny (with python-pymssql
1.0.1+dfsg-1):
#
$ python
Python 2.5.2 (r252:60911, Jan 4 2009, 17:40:26)
[GCC 4.3.2] on linux2
Type help, copyright, credits or license for more information.
import _mssql
C=_mssql.connect(user='d2ruser', password='XXX', server='XXX',
database='XXX')
C.execute_query('SELECT current_user; SELECT GETDATE();')
for r in C: print r
...
{0: 'd2ruser'}
C.nextresult()
1
for r in C: print r
...
{0: datetime.datetime(2010, 9, 9, 9, 50, 47, 27000)}
C.nextresult()
print C.nextresult()
None
#
Please consider packaging a newer version of the sources.
Thanks. Kind regards,
S.J.
** Affects: pymssql (Ubuntu)
Importance: Undecided
Status: New
--
nextresult method in _mssql connect always returns True, and never points to
next result set if there is any more
https://bugs.launchpad.net/bugs/633882
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 633882] Re: nextresult method in _mssql connect always returns True, and never points to next result set if there is any more
I found a binary package that was required to successfully compile the up-to-date pymssql sources. (https://launchpad.net/ubuntu/+source/cython/0.12.1-1.1/+build/1723320/+files/cython_0.12.1-1.1_amd64.deb) Now in pymssql-1.9.908 this issue is not there any more, nextresult() operates as expected, and one can perfectly iterate over all result sets. So presumably re-packaging python-pymssql will solve this sort of bug. Kind regards, S.J. -- nextresult method in _mssql connect always returns True, and never points to next result set if there is any more https://bugs.launchpad.net/bugs/633882 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 387816] [NEW] cannot parse for more than one -O/-o options; cannot use -i option
Public bug reported: Binary package hint: pssh Problem description: parallel-scp and parallel-ssh are not able to accept 1./ more than one -O options and translate them to -o options of the corresponding applications. 2./ -i (identity) option. A patch (for parallel-scp) is attached, which solves the issue, though not all possible combination of the optional arguments are implemented and/or tested. A similar workaround is available for the parallel-ssh. Maybe, the argument parsing of the parallel-scp/ssh needs some reconsiderations... Another problem with the current version of parallel-scp is that one cannot retrieve files from many hosts. I have a workaround, though a single use of : in the path arguments could indicate the direction of the transfers. Version info: 1./ lsb_release -rd Description:Ubuntu 9.04 Release:9.04 2./ pssh 1.4.3-1 python 2.6.2-0ubuntu1 python-support 0.8.7ubuntu4 Bests, Józsi ** Affects: pssh (Ubuntu) Importance: Undecided Status: New -- cannot parse for more than one -O/-o options; cannot use -i option https://bugs.launchpad.net/bugs/387816 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 387816] Re: cannot parse for more than one -O/-o options; cannot use -i option
** Attachment added: more than 1 -O options passed; -I (identity) options added http://launchpadlibrarian.net/27988465/pscp.diff -- cannot parse for more than one -O/-o options; cannot use -i option https://bugs.launchpad.net/bugs/387816 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 387816] Re: cannot parse for more than one -O/-o options; cannot use -i option
introducing the use of ':' in the folder description can assign file transfer direction. Of course from remote-local direction the source files shall have different names to avoid overwriting them. As a wish this could be avoided by the use of hostname folders for the local target... ** Attachment added: transfer from remote to local direction http://launchpadlibrarian.net/27989763/pscp.diff -- cannot parse for more than one -O/-o options; cannot use -i option https://bugs.launchpad.net/bugs/387816 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 231436] Re: Ubuntu 8.04 mic input in XPS M1330
After installing Ubuntu 8.04 from scratch on the Dell XPS M1330 neither the internal microphone(s) nor the microphone input work. Adding the line options snd-hda-intel model=dell-3stack OR options snd-hda-intel model=5stack to the /etc/modprobe.d/alsa-utils and trying to modify the input source with the gnome mixer application does not solve the problem as expeced from https://help.ubuntu.com/community/HdaIntelSoundHowto, http://www.mjmwired.net/kernel/Documentation/sound/alsa/ALSA-Configuration.txt and http://gentoo-wiki.com/Dell_XPS_M1330#Intel_Corporation_HD_Audio_Controller. I have 2.6.24-18-generic kernel running and alsa-base 1.0.16-0ubuntu. -- Ubuntu 8.04 mic input in XPS M1330 https://bugs.launchpad.net/bugs/231436 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
