gmane.comp.python.egenix.user

ANN: eGenix mxODBC Connect Database Interface for Python 0.9.2 (beta)

eGenix Team: M.-A. Lemburg — 2008-10-01T17:49:41

________________________________________________________________________ ANNOUNCING eGenix.com mxODBC Connect Database Interface for Python Version 0.9.2 (beta) Our new client-server product for connecting Python applications to relational databases - from all major platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mxODBC-Connect-0.9.2-beta.html ________________________________________________________________________ INTRODUCTION The mxODBC Connect Database Interface for Python allows users to easily connect Python applications to all major databases on the market today in a highly portable and convenient way. Unlike our mxODBC Python extension, mxODBC Connect is designed as client-server application, so you no longer need to find production quality ODBC drivers for all the platforms you target with your Python application. Instead you use an easy to install Python client library which connects directly to the mxODBC Connect database server over the network. This makes mxODBC Connect the ideal basis for writing cross-platform database programs and utilities in Python, especially if you run applications that need to communicate with databases such as MS SQL Server, Oracle or DB2 that run on Windows or Linux machines. By removing the need to install and configure ODBC drivers on the client side, mxODBC Connect greatly simplifies setup and configuration of database driven client applications, while at the same time making the network communication between client and database server more efficient and more secure. For more information, please have a look at the product page: http://www.egenix.com/products/python/mxODBCConnect/ * About Python: Python is an object-oriented Open Source programming language which runs on all modern platforms (http://www.python.org/). By integrating ease-of-use, clarity in coding, enterprise application connectivity and rapid application design, Python establishes an ideal programming platform for todays IT challenges. * About eGenix: eGenix is a consulting and software product company focused on providing professional quality services and products to Python users and developers (http://www.egenix.com/). ________________________________________________________________________ NEWS mxODBC Connect 0.9.2 is our second public beta release of the new mxODBC Connect product. It comes with improved documentation, enhanced SQL Server support on Linux and now runs on Python 2.6 as well (in addition to Python 2.3, 2.4 and 2.5). *SPECIAL OFFER* If you would like to participate in the beta as tester, please see our beta program page: http://www.egenix.com/products/python/mxODBCConnect/beta.html In order to make participation in the beta program more interesting for our users, we will be giving out *free discount coupons* to all participants who report back bugs in the product. ________________________________________________________________________ DOWNLOADS The download archives as well as instructions for installation and configuration of the product can be found on the product page: http://www.egenix.com/products/python/mxODBCConnect/ _______________________________________________________________________ SUPPORT Commercial support for this product is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings. Enjoy,

ANN: eGenix pyOpenSSL Distribution 0.7.0-0.9.8i-1

eGenix Team: M.-A. Lemburg — 2008-09-25T13:57:12

________________________________________________________________________ ANNOUNCING eGenix.com pyOpenSSL Distribution Version 0.7.0-0.9.8i-1 An easy to install and use repackaged distribution of the pyOpenSSL Python interface for OpenSSL - available on Windows and Unix platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-pyOpenSSL-Distribution-0.7.0-0.9.8i-1-GA.html ________________________________________________________________________ INTRODUCTION The eGenix.com pyOpenSSL Distribution includes everything you need to get started with SSL in Python. It comes with an easy to use installer that includes the most recent OpenSSL library versions in pre-compiled form. pyOpenSSL is an open-source Python add-on (http://pyopenssl.sf.net/) that allows writing SSL aware networking applications as well as certificate management tools. OpenSSL is an open-source implementation of the SSL protocol (http://www.openssl.org/). * About Python: Python is an object-oriented Open Source programming language which runs on all modern platforms (http://www.python.org/). By integrating ease-of-use, clarity in coding, enterprise application connectivity and rapid application design, Python establishes an ideal programming platform for todays IT challenges. * About eGenix: eGenix is a consulting and software product company focused on providing professional quality services and products to Python users and developers (http://www.egenix.com/). ________________________________________________________________________ NEWS This second release of the eGenix.com pyOpenSSL Distribution upgrades the included OpenSSL library version to the latest 0.9.8i, which includes several bug fixes over the previously included 0.9.8h version. The release also includes Python 2.6 support for the first time. Binaries are available for Linux x86 and x64 as well as Windows x86. ________________________________________________________________________ DOWNLOADS The download archives and instructions for installing the package can be found at: http://www.egenix.com/products/python/pyOpenSSL/ ________________________________________________________________________ UPGRADING Before installing this version of pyOpenSSL, please make sure that you uninstall any previously installed pyOpenSSL version. Otherwise, you could end up not using the included OpenSSL libs. _______________________________________________________________________ SUPPORT Commercial support for these packages is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings. Enjoy,

Getting mxODBCZopeDA connector to pick-up environment ODBC DNSs

2008-09-18T21:37:43

_______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

Speeding up ODBC Connection

Minh-Long Pham — 2008-09-12T19:49:52

Hi, I'm running mxODBC on a machine that remotely connects to the server, and when I'm executing scripts, it takes 20 minutes longer than it would on the server itself. Is there any way to speed up the connection? Thanks, Minh _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

How to bypass ODBC Manager (iODBC or unixODBC) to use freetds driver Connector?

2008-09-11T19:21:45

_______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

cursor.executedirect configurable?

Brad Allen — 2008-09-10T02:18:55

Hello, I am using mxODBC 3 with the Storm ORM, which makes use of cursor.execute. I would like to find a way to configure mxODBC to use executedirect without having to change or override Storm's call to cursor.execute. Is there some way to configure mxODBC to use the executedirect behavior when cursor.execute is called? Thanks.

[mxTidy/MacOSX] _CleanTree error

Darryl Cousins — 2008-09-05T12:08:31

Hi, I have struck an error on MacOS Leopard similar to this post. http://www.egenix.com/mailman-archives/egenix-users/2007-July/114231.html My error is as follows: Python 2.5.2 (r252:60911, Sep 5 2008, 23:29:08) [GCC 4.0.1 (Apple Inc. build 5465)] on darwin Type "help", "copyright", "credits" or "license" for more information. Traceback (most recent call last): File "", line 1, in File "/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/__init__.py", line 7, in from Tidy import * File "/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/Tidy.py", line 7, in from mxTidy import * File "/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/mxTidy/__init__.py", line 7, in from mxTidy import * ImportError: dlopen(/Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/mxTidy/mxTidy.so, 2): Symbol not found: _CleanTree Referenced from: /Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/mxTidy/mxTidy.so Expected in: dynamic lookup In the aforementioned post Mr Lemburg points to a fix in a future 3.0.1 version of the experimental package. Would this be the solution or is there another way I can solve the problem for myself. For further reference I've included the build output below. Kind regards, Darryl Cousins darrylcousins theshire:egenix-mx-experimental-3.0.0$ ~/Python/Python-2.5.2/bin/python2.5 setup.py install running install running build running build_clib building 'tidy' library creating build creating build/temp.macosx-10.5-i386-2.5_ucs2 creating build/temp.macosx-10.5-i386-2.5_ucs2/tidy creating build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx creating build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy creating build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy creating build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/attrs.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/attrs.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/clean.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/clean.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/config.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/config.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/entities.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/entities.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/istack.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/istack.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/lexer.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/lexer.o mx/Tidy/mxTidy/libtidy/lexer.c:282: warning: 'AddStringToLexer' defined but not used gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/localize.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/localize.o mx/Tidy/mxTidy/libtidy/localize.c: In function 'tidy_out': mx/Tidy/mxTidy/libtidy/localize.c:45: warning: pointer targets in assignment differ in signedness mx/Tidy/mxTidy/libtidy/localize.c:50: warning: pointer targets in passing argument 1 of 'vsnprintf' differ in signedness gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/parser.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/parser.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/pprint.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/pprint.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/tags.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/tags.o gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DCOMPILING_TIDY=1 -Imx/Tidy/mxTidy/libtidy -c mx/Tidy/mxTidy/libtidy/tidy.c -o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/tidy.o mx/Tidy/mxTidy/libtidy/tidy.c: In function 'InputStreamFromBuffer': mx/Tidy/mxTidy/libtidy/tidy.c:236: warning: pointer targets in assignment differ in signedness mx/Tidy/mxTidy/libtidy/tidy.c: In function 'OutputStreamFromBuffer': mx/Tidy/mxTidy/libtidy/tidy.c:702: warning: pointer targets in assignment differ in signedness mx/Tidy/mxTidy/libtidy/tidy.c:708: warning: pointer targets in assignment differ in signedness mx/Tidy/mxTidy/libtidy/tidy.c: In function 'WriteCharToStream': mx/Tidy/mxTidy/libtidy/tidy.c:744: warning: pointer targets in assignment differ in signedness mx/Tidy/mxTidy/libtidy/tidy.c:750: warning: pointer targets in assignment differ in signedness mx/Tidy/mxTidy/libtidy/tidy.c: In function 'WriteStringToStream': mx/Tidy/mxTidy/libtidy/tidy.c:766: warning: pointer targets in assignment differ in signedness mx/Tidy/mxTidy/libtidy/tidy.c:773: warning: pointer targets in assignment differ in signedness ar -cr build/temp.macosx-10.5-i386-2.5_ucs2/libtidy.a build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/attrs.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/clean.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/config.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/entities.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/istack.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/lexer.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/localize.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/parser.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/pprint.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/tags.o build/temp.macosx-10.5-i386-2.5_ucs2/tidy/mx/Tidy/mxTidy/libtidy/tidy.o ranlib build/temp.macosx-10.5-i386-2.5_ucs2/libtidy.a running mx_autoconf gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -D_GNU_SOURCE=1 -I/opt/local/include -I/Users/darrylcousins/Python/Python-2.5.2/include -c _configtest.c -o _configtest.o _configtest.c: In function 'main': _configtest.c:4: warning: statement with no effect gcc -I/opt/local/include -L/opt/local/lib _configtest.o -L/opt/local/lib -L/Users/darrylcousins/Python/Python-2.5.2/lib -o _configtest success! removing: _configtest.c _configtest.o _configtest gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -D_GNU_SOURCE=1 -I/Users/darrylcousins/Python/Python-2.5.2/include/python2.5 -I/opt/local/include -I/Users/darrylcousins/Python/Python-2.5.2/include -c _configtest.c -o _configtest.o success! removing: _configtest.c _configtest.o macros to define: [('HAVE_STRPTIME', '1')] macros to undefine: [] running build_ext building extension "mx.Tidy.mxTidy.mxTidy" (required) building 'mx.Tidy.mxTidy.mxTidy' extension creating build/temp.macosx-10.5-i386-2.5_ucs2/mx-Tidy-mxTidy-mxTidy creating build/temp.macosx-10.5-i386-2.5_ucs2/mx-Tidy-mxTidy-mxTidy/mx creating build/temp.macosx-10.5-i386-2.5_ucs2/mx-Tidy-mxTidy-mxTidy/mx/Tidy creating build/temp.macosx-10.5-i386-2.5_ucs2/mx-Tidy-mxTidy-mxTidy/mx/Tidy/mxTidy gcc -I/opt/local/include -L/opt/local/lib -fno-strict-aliasing -Wno-long-double -no-cpp-precomp -mno-fused-madd -DNDEBUG -g -fwrapv -O3 -Wall -Wstrict-prototypes -DHAVE_STRPTIME=1 -Imx/Tidy/mxTidy -Imx/Tidy/mxTidy/libtidy -I/Users/darrylcousins/Python/Python-2.5.2/include/python2.5 -I/opt/local/include -I/Users/darrylcousins/Python/Python-2.5.2/include -c mx/Tidy/mxTidy/mxTidy.c -o build/temp.macosx-10.5-i386-2.5_ucs2/mx-Tidy-mxTidy-mxTidy/mx/Tidy/mxTidy/mxTidy.o creating build/lib.macosx-10.5-i386-2.5_ucs2 creating build/lib.macosx-10.5-i386-2.5_ucs2/mx creating build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy creating build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy gcc -I/opt/local/include -L/opt/local/lib -bundle -undefined dynamic_lookup build/temp.macosx-10.5-i386-2.5_ucs2/mx-Tidy-mxTidy-mxTidy/mx/Tidy/mxTidy/mxTidy.o -Lmx/Tidy/mxTidy/libtidy -Lbuild/temp.macosx-10.5-i386-2.5_ucs2 -L/opt/local/lib -L/Users/darrylcousins/Python/Python-2.5.2/lib -ltidy -ltidy -o build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy/mxTidy.so building extension "mx.Number.mxNumber.mxNumber" (optional) looking for header files needed by extension "mx.Number.mxNumber.mxNumber" *** WARNING: Building of extension "mx.Number.mxNumber.mxNumber" failed: needed include file "gmp.h" not found running build_py copying mx/__init__.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx creating build/lib.macosx-10.5-i386-2.5_ucs2/mx/Number copying mx/Number/__init__.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Number copying mx/Number/LazyModule.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Number copying mx/Number/Number.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Number creating build/lib.macosx-10.5-i386-2.5_ucs2/mx/Number/mxNumber copying mx/Number/mxNumber/__init__.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Number/mxNumber copying mx/Number/mxNumber/test.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Number/mxNumber copying mx/Tidy/__init__.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy copying mx/Tidy/Tidy.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy copying mx/Tidy/mxTidy/__init__.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy copying mx/Tidy/mxTidy/test.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy copying mx/Tidy/mxTidy/testMadjakarta.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy copying mx/Tidy/mxTidy/testMateusz.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy copying mx/Tidy/mxTidy/testWalter.py -> build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy running install_lib copying build/lib.macosx-10.5-i386-2.5_ucs2/mx/Tidy/mxTidy/mxTidy.so -> /Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/mx/Tidy/mxTidy writing byte-compilation script '/var/folders/rV/rVAGWhmsHWSmKVQIPwGHhk+++TI/-Tmp-/tmpSQ9KQN.py' /Users/darrylcousins/Python/Python-2.5.2/bin/python2.5 -O /var/folders/rV/rVAGWhmsHWSmKVQIPwGHhk+++TI/-Tmp-/tmpSQ9KQN.py removing /var/folders/rV/rVAGWhmsHWSmKVQIPwGHhk+++TI/-Tmp-/tmpSQ9KQN.py running install_data running install_egg_info Removing /Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/egenix_mx_experimental-3.0.0-py2.5.egg-info Writing /Users/darrylcousins/Python/Python-2.5.2/lib/python2.5/site-packages/egenix_mx_experimental-3.0.0-py2.5.egg-info _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

mxODBC doesn't support LIMIT in SELECT?

Minh-Long Pham — 2008-09-02T18:43:37

Hi, I've connected to my database through mx.ODBC.Windows functions connect() and DriverConnect(). I was able to execute sql.execute("""SELECT count(*) FROM IM1_InventoryMasterfile""") but not sql.execute("""SELECT * FROM IM1_InventoryMasterfile LIMIT 5"""). This is the error that I get: mx.ODBC.Error.InterfaceError: ('3700', 1017, '[Best Canada][PUX ODBC Driver]Unexpected extra token: 5', 7089) Windows ODBC version: 3.525.11.32.0 Windows Python version: 2.5 Why does a simple LIMIT 5 not work? Thanks,

ANN: eGenix mx Base Distribution 3.1.1

eGenix Team: M.-A. Lemburg — 2008-08-05T12:46:37

________________________________________________________________________ ANNOUNCING eGenix.com mx Base Distribution Version 3.1.1 Open Source Python extensions providing important and useful services for Python programmers. This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.1.1-GA.html ________________________________________________________________________ ABOUT The eGenix.com mx Base Distribution for Python is a collection of professional quality software tools which enhance Python's usability in many important areas such as fast text searching, date/time processing and high speed data types. The tools have a proven record of being portable across many Unix and Windows platforms. You can write applications which use the tools on Windows and then run them on Unix platforms without change due to the consistent platform independent interfaces. Contents of the distribution: * mxDateTime - Date/Time Library for Python * mxTextTools - Fast Text Parsing and Processing Tools for Python * mxProxy - Object Access Control for Python * mxBeeBase - On-disk B+Tree Based Database Kit for Python * mxURL - Flexible URL Data-Type for Python * mxUID - Fast Universal Identifiers for Python * mxStack - Fast and Memory-Efficient Stack Type for Python * mxQueue - Fast and Memory-Efficient Queue Type for Python * mxTools - Fast Everyday Helpers for Python All available packages have proven their stability and usefulness in many mission critical applications and various commercial settings all around the world. * About Python: Python is an object-oriented Open Source programming language which runs on all modern platforms (http://www.python.org/). By integrating ease-of-use, clarity in coding, enterprise application connectivity and rapid application design, Python establishes an ideal programming platform for todays IT challenges. * About eGenix: eGenix is a consulting and software product company focused on providing professional quality services and products to Python users and developers (http://www.egenix.com/). ________________________________________________________________________ NEWS The 3.1.1 release of the eGenix mx Base Distribution is a patch level release which fixes an installation problem with our pre-built packages on Mac OS X and some older Linux platforms. This is also the first release with Python 2.6 support ! For now, we only ship Linux pre-built versions for Python 2.6. Once the final version of Python 2.6 is released, we will also provide Windows installers and pre-build packages for the other platforms that we support. For a list of changes compared to the older version 3.0 of the package, please see the eGenix mx Base 3.0 release announcement: http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.1.0-GA.html ________________________________________________________________________ DOWNLOADS The download archives and instructions for installing the packages can be found on the eGenix mx Base Distribution page: http://www.egenix.com/products/python/mxBase/ ________________________________________________________________________ LICENSE The eGenix mx Base package is distributed under the eGenix.com Public License 1.1.0 which is a CNRI Python License style Open Source license. You can use the package in both commercial and non-commercial settings without fee or charge. The package comes with full source code ________________________________________________________________________ SUPPORT Commercial support for these packages is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings. Enjoy,

Problems deploying mx.DateTime

Weverton Gomes — 2008-07-22T15:53:53

_______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

ANN: eGenix EuroPython 2008 Presentations & Videos

eGenix Team: M.-A. Lemburg — 2008-07-21T21:26:54

________________________________________________________________________ eGenix EuroPython 2008 Presentations & Videos ________________________________________________________________________ We have uploaded our EuroPython 2008 presentations to our website. Learn the concepts behind the Python DB-API and how to design large-scale applications. This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/EuroPython-2008-Presentations.html ________________________________________________________________________ INTRODUCTION The EuroPython Conference is the one of the premier conferences for Python & Zope users and developers. This year it was being held from the 7th to 9th July in Vilnius, Lithuania. eGenix was one of the founding members of the EuroPython conference team and played a major role in organizing the first EuroPython conference in the year 2002. Since then we have attended every EuroPython conference to meet up face-to-face with the people from the Python & Zope communities and have given regular talks at these conferences. ________________________________________________________________________ TALKS AT EUROPYTHON 2008 We gave the following two talks at the conference. The presentations are available for viewing and download from our Presentations and Talks section: http://www.egenix.com/library/presentations/ As special feature, we have added talk videos in addition to providing the slide PDFs. You can view the talks online if you have the Adobe Flash Player 8 or later installed. * Using the Python Database API The Python Database API (DB-API) is a specification of a module interface that allows interfacing from Python to a relational database. The talk gives a high-level introduction to the concepts used in the Python DB-API and relational databases in general. Connection, cursors and transactions are discussed, and their use in Python database applications is explained. * Designing Large-Scale Applications in Python Python is widely and somewhat inaccurately referred to as a scripting language. While Python is an ideal platform for small scripting tasks, it does in fact cover all the concepts needed for large scale object oriented application development. However, complex applications bring different challenges. This talk draws on eGenix' many years experience with large scale application development using Python as central implementation language and provides a cookbook approach to many of the the problems you face when designing and organizing complex application frameworks. Enjoy,

insert fails with no error

Joel Bard — 2008-07-17T19:49:44

Hi- I'm connecting from linux x86_64 to a sqlserver2005 instance using mxODBC 3.0.1 with unixODBC. I'm able to retrieve data with no problem. When I try a simple insert: c=db.cursor() p1="test" p2="mxodbc test" c.execute("insert into bug" + \ " (UIElement,Description)" + \ "values (?,?)" \ ,(p1,p2) \ ) c.rowcount is 1 but the row is not present in the table. If I execute the same sql command using isql it works. The table uses an autoincrement key column and values for the key are consumed even though the record is not being created. c.messages is empty. The same behavior is seen regardless of whether parameters are used and regardless of wether I use execute or executedirect. Any help would be appreciated. Thanks, Joel _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

Simple mx.ODBC Update question

Greg Corradini — 2008-06-23T16:20:59

_______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

ANN: eGenix mx Base Distribution 3.1.0

eGenix Team: M.-A. Lemburg — 2008-06-18T16:26:54

________________________________________________________________________ ANNOUNCING eGenix.com mx Base Distribution Version 3.1.0 Open Source Python extensions providing important and useful services for Python programmers. This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mx-Base-Distribution-3.1.0-GA.html ________________________________________________________________________ ABOUT The eGenix.com mx Base Distribution for Python is a collection of professional quality software tools which enhance Python's usability in many important areas such as fast text searching, date/time processing and high speed data types. The tools have a proven record of being portable across many Unix and Windows platforms. You can write applications which use the tools on Windows and then run them on Unix platforms without change due to the consistent platform independent interfaces. Contents of the distribution: * mxDateTime - Date/Time Library for Python * mxTextTools - Fast Text Parsing and Processing Tools for Python * mxProxy - Object Access Control for Python * mxBeeBase - On-disk B+Tree Based Database Kit for Python * mxURL - Flexible URL Data-Type for Python * mxUID - Fast Universal Identifiers for Python * mxStack - Fast and Memory-Efficient Stack Type for Python * mxQueue - Fast and Memory-Efficient Queue Type for Python * mxTools - Fast Everyday Helpers for Python All available packages have proven their stability and usefulness in many mission critical applications and various commercial settings all around the world. * About Python: Python is an object-oriented Open Source programming language which runs on all modern platforms (http://www.python.org/). By integrating ease-of-use, clarity in coding, enterprise application connectivity and rapid application design, Python establishes an ideal programming platform for todays IT challenges. * About eGenix: eGenix is a consulting and software product company focused on providing professional quality services and products to Python users and developers (http://www.egenix.com/). ________________________________________________________________________ NEWS The 3.1.0 release of the eGenix mx Base Distribution has a number of enhancements over the previous version 3.0.0. Apart from a few minor bug fixes, it provides a few new features: Some highlights: * mxTools now has a new mx.Tools.dlopen() function which allow loading shared libraries explicitly and from a specific path. This allows working around problems with not being able to dynamically set LD_LIBRARY_PATH on Unix platforms. * mxTools can be configured to expose a new API called mx.Tools.setproctitle() which allows setting the process title on Unix platforms. * mxBeeBase comes with a new on-disk dictionary version called BeeFixedLengthStringDict, which allows using keys with embedded \0 characters. * mxSetup, our Python distutils extension, can now build prebuilt archives that no longer require the "... build --skip ..." command to skip the build process. The uninstall command now also works for prebuilt archives and the bdist_prebuilt command has been enhanced to be able to build pure Python distributions as well. * mxSetup now also works together with setuptools to e.g. build and install the packages as eggs. Run setup.py with --use-setuptools to enable this support. For a more detailed description of changes, please see the respective package documentation on our web-site. As always, we are providing pre-compiled versions of the package for the most popular Python platforms. For all others, you can compile the package from source using "python setup.py install". ________________________________________________________________________ DOWNLOADS The download archives and instructions for installing the packages can be found on the eGenix mx Base Distribution page: http://www.egenix.com/products/python/mxBase/ ________________________________________________________________________ LICENSE The eGenix mx Base package is distributed under the eGenix.com Public License 1.1.0 which is a CNRI Python License style Open Source license. You can use the package in both commercial and non-commercial settings without fee or charge. The package comes with full source code ________________________________________________________________________ SUPPORT Commercial support for these packages is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings. Enjoy,

ANN: eGenix mxODBC Connect Database Interface for Python 0.9.1 (beta)

eGenix Team: M.-A. Lemburg — 2008-06-16T10:12:26

________________________________________________________________________ ANNOUNCING eGenix.com mxODBC Connect Database Interface for Python Version 0.9.1 (beta) Our new client-server product for connecting Python applications to relational databases - on all major platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-mxODBC-Connect-0.9.1-beta.html ________________________________________________________________________ INTRODUCTION The mxODBC Connect Database Interface for Python allows users to easily connect Python applications to all major databases on the market today in a highly portable and convenient way. This makes mxODBC Connect the ideal basis for writing cross-platform database programs and utilities in Python. mxODBC Connect extends our eGenix mx Python Extension series with a new client-server based product, that removes the need to install and configure ODBC drivers on the client side. This greatly simplifies setup and configuration of database driven client applications, while at the same time making the network communication between client and database server more efficient and more secure. * About Python: Python is an object-oriented Open Source programming language which runs on all modern platforms (http://www.python.org/). By integrating ease-of-use, clarity in coding, enterprise application connectivity and rapid application design, Python establishes an ideal programming platform for todays IT challenges. * About eGenix: eGenix is a consulting and software product company focused on providing professional quality services and products to Python users and developers (http://www.egenix.com/). ________________________________________________________________________ HOW IT WORKS mxODBC Connect consists of two parts: a server installation which typically runs directly on the database server and a client Python package which is installed on the client machine that runs the Python application. The server part uses our high-performance database adapter mxODBC to connect to the database server. The client package communicates with the server part over a TCP/IP network, optionally using SSL encryption, advanced authentication and access controls - a feature that many database drivers fail to deliver. By separating the client application database interface from the server and using mxODBC Connect, you gain several benefits: * high portability and flexibility * centralized configuration and administration * added security * automatic fail-over * scalability * lower costs For more information, please have a look at the product page: http://www.egenix.com/products/python/mxODBCConnect/ ________________________________________________________________________ NEWS mxODBC Connect 0.9 is a public beta release of our new mxODBC Connect product. If you would like to participate in the beta, please see our beta program page: http://www.egenix.com/products/python/mxODBCConnect/beta.html *SPECIAL OFFER* In order to make participation in the beta program more interesting for our users, we will be giving out *free discount coupons* to all participants who report back bugs in the product. ________________________________________________________________________ DOWNLOADS The download archives as well as instructions for installation and configuration of the product can be found on the product page: http://www.egenix.com/products/python/mxODBCConnect/ _______________________________________________________________________ SUPPORT Commercial support for this product is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings.

ANN: eGenix pyOpenSSL Distribution 0.7.0-0.9.8h-1

eGenix Team: M.-A. Lemburg — 2008-06-12T20:04:46

________________________________________________________________________ ANNOUNCING eGenix.com pyOpenSSL Distribution Version 0.7.0-0.9.8h-1 An easy to install and use repackaged distribution of the pyOpenSSL Python interface for OpenSSL - available on Windows and Unix platforms This announcement is also available on our web-site for online reading: http://www.egenix.com/company/news/eGenix-pyOpenSSL-Distribution-0.7.0-0.9.8h-1-GA.html ________________________________________________________________________ INTRODUCTION The eGenix.com pyOpenSSL Distribution includes everything you need to get started with SSL in Python. It comes with an easy to use installer that includes the most recent OpenSSL library versions in pre-compiled form. pyOpenSSL is an open-source Python add-on (http://pyopenssl.sf.net/). OpenSSL is an open-source implementation of the SSL protocol (http://www.openssl.org/). * About Python: Python is an object-oriented Open Source programming language which runs on all modern platforms (http://www.python.org/). By integrating ease-of-use, clarity in coding, enterprise application connectivity and rapid application design, Python establishes an ideal programming platform for todays IT challenges. * About eGenix: eGenix is a consulting and software product company focused on providing professional quality services and products to Python users and developers (http://www.egenix.com/). ________________________________________________________________________ NEWS This is the first release of the eGenix.com pyOpenSSL Distribution. It includes pyOpenSSL 0.7.0 and the OpenSSL 0.9.8h libraries on all supported platforms. ________________________________________________________________________ DOWNLOADS The download archives and instructions for installing the package can be found at: http://www.egenix.com/products/python/pyOpenSSL/ ________________________________________________________________________ UPGRADING Before installing this version of pyOpenSSL, please make sure that you uninstall any previously installed pyOpenSSL version. Otherwise, you could end up not using the included OpenSSL libs. _______________________________________________________________________ SUPPORT Commercial support for these packages is available from eGenix.com. Please see http://www.egenix.com/services/support/ for details about our support offerings. Enjoy,

Installing mxODBC Zope DA for use in Plone 3.x

M.-A. Lemburg — 2008-06-06T20:14:28

The Plone universal installer ships with its own Python and Zope installation. As a result the installation procedure for our Zope DA has to be adapted to the Plone setup. The following assumes that you are using the unified Plone 3.1 installer and its default standalone configuration. For a Plone 3.1 standalone installation: ---------------------------------------- cd /opt/Plone-3.1/ # Unzip the mxODBC Zope DA ZIP file in the instance directory unzip -d zinstance/parts/instance \ egenix-mxodbc-zopeda-1.0.10.*-py2.4_ucs2.zip # Move the product package into place mv zinstance/parts/instance/lib/python/Products/mxODBCZopeDA \ zinstance/products/ # Remove the no longer needed Products/ directory to avoid # confusion rmdir zinstance/parts/instance/lib/python/Products then install the license files into /opt/Plone-3.1/zinstance/parts/instance/lib/python/mx/ODBC and restart Plone. Regards,

mx.odbc segmentation fault on fetching string

Wouter van Atteveldt — 2008-06-03T00:49:58

Dear list, I am evaluating mx.odbc for connecting to a MS SQL server from my Linux machine using freetds 0.82. I can connect and query using isql without problem, but I get a segmentation fault if I fetch using the mx.odbc interface. wva< at >amcat:~/tmp$ isql -v AmcatDB +---------------------------------------+ | Connected! [...] +---------------------------------------+ SQL> select top 1 projectid, name from projects [...] | 1 | test [...] SQLRowCount returns 1 1 rows fetched wva< at >amcat:~/tmp$ python testodbc.py connected to Microsoft SQL Server 08.00.2039 Executed, fetching... [(1,)] Executed, fetching... Segmentation fault wva< at >amcat:~/tmp$ cat testodbc.py import mx.ODBC db = mx.ODBC.unixODBC.connect("AmcatDB", "", "") print "connected to %s %s" % (db.dbms_name, db.dbms_version) c = db.cursor() c.executedirect("select top 1 projectid from projects") print "Executed, fetching..." print c.fetchall() c.executedirect("select top 1 projectid, name from projects") print "Executed, fetching..." print c.fetchall()wva< at >amcat:~/tmp$ uname -a Linux amcat 2.6.18-6-amd64 #1 SMP Sun Feb 10 17:50:19 UTC 2008 x86_64 GNU/Linux wva< at >amcat:~/tmp$ python -c "import sys;print(sys.maxunicode<66000)and'UCS2'or'UCS4'" UCS4 As you can see, it returns the MS SQL version number so it has some contact with the remote db. I installed using egenix-mxodbc-3.0.1.linux-x86_64-py2.5_ucs4.prebuilt.zip, which I think should be OK as x86_64 == AMD64 (right?). projected is int, name is a varchar(255) column, and the table should have a couple hundred entries at most. The relevant etc files: wva< at >amcat:~/tmp$ tail -4 /usr/local/freetds/etc/freetds.conf [amcatdb] host = localhost port = 1433 tds version = 8.0 wva< at >amcat:~/tmp$ cat /etc/odbc.ini [AmcatDB] Driver = FreeTDS Description = amcatdb MS SQL Database Trace = No Servername = amcatdb Database = anoko wva< at >amcat:~/tmp$ cat /etc/odbcinst.ini [FreeTDS] Description = v0.63 with protocol v8.0 Driver = /usr/local/freetds/lib/libtdsodbc.so UsageCount = 1 Note that I am using an SSH tunnel to connect to the sql server, hence the localhost. This does not give trouble using either tsql, isql, or python-sybase (on a previous install), so I am not expecting this to be the cause of the problem. Any help greatly appreciated!

Plone 3.1, Buildout, and MX ODBC Zope DA

Eric S Tyrer II — 2008-05-22T14:49:47

_______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

Still can't install mxODBCZopeDA on plone 3.1.1buildout

Cliff Quinn — 2008-05-22T04:35:37

_______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users

Newlines and VARBINARY

Alexandre Pigolkine — 2008-05-14T06:37:12

Hello all, I try to use mx.ODBC in the following environment: mx.ODBC, Linux, iODBC, FreeTDS-Library, Microsoft SQL Server. I get an error message when I try to insert a string with new lines into a table with a TEXT field: import mx.ODBC con = mx.ODBC.iODBC.DriverConnect("DRIVER={SQL Server};SERVER=;DATABASE=;UID=;PWD=") cur = con.cursor() cur.execute("CREATE TABLE #test (t text)") cur.close() cur = con.cursor() cur.execute("INSERT INTO #test(t) VALUES(?)", ('test\n',)) cur.close() con.close() /etc/odbcinst.ini: [ODBC Drivers] TDS MSSQL = installed [SQL Server] Description = TDS MSSQL ODBC Driver v 4.2 Driver = /usr/local/lib/libtdsodbc.so after the line cur.execute("INSERT ... ") I get an error: Traceback (most recent call last): File "", line 1, in ? mx.ODBC.Error.ProgrammingError: ('22018', 206, '[FreeTDS][SQL Server]Operand type clash: varbinary is incompatible with text', 7028) Part of freetds-Log: token.c:2159:tds_process_end() state set to TDS_IDLE util.c:119:Changing query state from READING to IDLE util.c:119:Changing query state from IDLE to PENDING token.c:514:tds_process_tokens() state is COMPLETED sql2tds.c:151:type=-3 sql2tds.c:157:trace sql2tds.c:344:trace odbc.c:2506:Creating prepared statement util.c:119:Changing query state from IDLE to QUERYING mem.c:519:tds_free_all_results() write.c:134:tds_put_string converting 3 bytes of "< at >P1" write.c:162:tds_put_string wrote 6 bytes util.c:119:Changing query state from QUERYING to PENDING net.c:673:Sending packet 0000 03 01 00 9c 00 00 01 00-ff ff 0b 00 00 00 00 01 |........ ........| 0010 26 04 00 00 00 63 20 00-00 00 09 04 c0 00 69 20 |&....c . ......i | 0020 00 00 00 40 00 50 00 31-00 20 00 56 00 41 00 52 |...< at >.P.1 . .V.A.R| 0030 00 42 00 49 00 4e 00 41-00 52 00 59 00 28 00 39 |.B.I.N.A .R.Y.(.9| 0040 00 29 00 00 00 63 40 00-00 00 09 04 c0 00 69 40 |.)...c< at >. ......i< at >| 0050 00 00 00 49 00 4e 00 53-00 45 00 52 00 54 00 20 |...I.N.S .E.R.T. | 0060 00 49 00 4e 00 54 00 4f-00 20 00 23 00 74 00 65 |.I.N.T.O . .#.t.e| 0070 00 73 00 74 00 28 00 74-00 29 00 20 00 56 00 41 |.s.t.(.t .). .V.A| 0080 00 4c 00 55 00 45 00 53-00 28 00 40 00 50 00 31 |.L.U.E.S .(.< at >.P.1| 0090 00 29 00 00 00 26 04 04-01 00 00 00 |.)...&.. ....| util.c:119:Changing query state from PENDING to READING net.c:446:Received header 0000 04 01 01 18 00 3b 01 00- |.....;..| net.c:542:Received packet 0000 aa 8c 00 ce 00 00 00 02-10 37 00 4f 00 70 00 65 |........ .7.O.p.e| 0010 00 72 00 61 00 6e 00 64-00 20 00 74 00 79 00 70 |.r.a.n.d . .t.y.p| 0020 00 65 00 20 00 63 00 6c-00 61 00 73 00 68 00 3a |.e. .c.l .a.s.h.:| 0030 00 20 00 76 00 61 00 72-00 62 00 69 00 6e 00 61 |. .v.a.r .b.i.n.a| 0040 00 72 00 79 00 20 00 69-00 73 00 20 00 69 00 6e |.r.y. .i .s. .i.n| 0050 00 63 00 6f 00 6d 00 70-00 61 00 74 00 69 00 62 |.c.o.m.p .a.t.i.b| 0060 00 6c 00 65 00 20 00 77-00 69 00 74 00 68 00 20 |.l.e. .w .i.t.h. | 0070 00 74 00 65 00 78 00 74-00 09 54 00 52 00 56 00 |.t.e.x.t ..T.R.V.| 0080 4d 00 53 00 52 00 56 00-30 00 31 00 00 01 00 aa |M.S.R.V. 0.1.....| 0090 64 00 f4 1f 00 00 01 10-23 00 53 00 74 00 61 00 |d....... #.S.t.a.| 00a0 74 00 65 00 6d 00 65 00-6e 00 74 00 28 00 73 00 |t.e.m.e. n.t.(.s.| 00b0 29 00 20 00 63 00 6f 00-75 00 6c 00 64 00 20 00 |). .c.o. u.l.d. .| 00c0 6e 00 6f 00 74 00 20 00-62 00 65 00 20 00 70 00 |n.o.t. . b.e. .p.| 00d0 72 00 65 00 70 00 61 00-72 00 65 00 64 00 2e 00 |r.e.p.a. r.e.d...| 00e0 09 54 00 52 00 56 00 4d-00 53 00 52 00 56 00 30 |.T.R.V.M .S.R.V.0| 00f0 00 31 00 00 01 00 79 f4-1f 00 00 ac 09 00 00 01 |.1....y. ........| 0100 00 00 00 00 26 04 00 fe-02 00 e0 00 00 00 00 00 |....&... ........| Is there a way to avoid such behavior and force mxODBC to always pass strings as a varchar-type? Thanks a lot in advance. Alexander Pigolkin _______________________________________________________________________ eGenix.com User Mailing List http://www.egenix.com/ https://www.egenix.com/mailman/listinfo/egenix-users