Re: [Zope] Database Adapter For Windows DB
Looked at mxODBC but it's not free and MSSQL didn't worked for me either :(. Is there some other free DB Adapter that I could use? Can I do an external method using Perl or a Python script to connect? Thanks. --- On Tue, 4/14/09, Andreas Jung li...@zopyx.com wrote: From: Andreas Jung li...@zopyx.com Subject: Re: [Zope] Database Adapter For Windows DB To: cybercruis...@yahoo.com Cc: zope@zope.org Date: Tuesday, April 14, 2009, 12:22 AM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 13.04.2009 23:33 Uhr, Bobby wrote: Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. mxODBC - -aj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAknkK5gACgkQCJIWIbr9KYxwSwCeNGeygGhPPfcRtT3f1/fvRcEr sKUAoKoU8l49M4OSNhtFFaNnNYQhPvMw =tOvV -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
On Wed, Apr 15, 2009 at 08:33:58AM -0700, Bobby wrote: Looked at mxODBC but it's not free and MSSQL didn't worked for me either :(. Is there some other free DB Adapter that I could use? Can I do an external method using Perl or a Python script to connect? You might want to look at FreeTDS (TDS is the protocol to talk to Sybase and MS SQL servers). I do not know if a Zope adapter exists for FreeTDS. -- __ Nothing is as subjective as reality Reinoud van Leeuwenreinou...@n.leeuwen.net http://reinoud.van.leeuwen.net kvk 27320762 __ ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15.04.2009 17:33 Uhr, Bobby wrote: Looked at mxODBC but it's not free and MSSQL didn't worked for me either :(. It's cheap enough, well supported and worth the mone (please no further discussions about that everything must be free :-)) Andreas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAknmA+AACgkQCJIWIbr9KYymFwCcCejKq8Phe6kHanPgAibreOLB aVgAnRPNly09xUr4JDv9PMjOvf5aTXZs =rdnq -END PGP SIGNATURE- begin:vcard fn:Andreas Jung n:Jung;Andreas org:ZOPYX Ltd. Co. KG adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany email;internet:i...@zopyx.com title:CEO tel;work:+49-7071-793376 tel;fax:+49-7071-7936840 tel;home:+49-7071-793257 x-mozilla-html:FALSE url:www.zopyx.com version:2.1 end:vcard ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
Thanks for the suggested reading Gary. The problem is I'm running Zope on a Linux box and Z ODBC DA only works on a Windows platform :( --- On Tue, 4/14/09, ga...@schoolteachers.co.uk ga...@schoolteachers.co.uk wrote: From: ga...@schoolteachers.co.uk ga...@schoolteachers.co.uk Subject: Re: [Zope] Database Adapter For Windows DB To: zope@zope.org Date: Tuesday, April 14, 2009, 3:17 AM Quoting Bobby cybercruis...@yahoo.com: Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. I found this, I hope it is useful to you http://www.zope.org/Members/roberth/ZMSSQLServer Regards Garry ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev ) ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
Free and OpenSource kinda go together :) Time is tough right now and Obama didn't include software licenses in his stimulus package :). The problem is I'm the only one using Zope and Linux in my company. IT are a bunch of Windows and ASP worshipers, they hate Linux and fear of supporting it because they don't know anything about it. morons! Could have saved the company thousands of dollars by going with open source instead! haha, j/k didn't meant to offend y'all Uncle Gates' cult followers/comrades out there :). So it's mxODBC or nothing at all for the Linux users? --- On Wed, 4/15/09, Andreas Jung li...@zopyx.com wrote: From: Andreas Jung li...@zopyx.com Subject: Re: [Zope] Database Adapter For Windows DB To: cybercruis...@yahoo.com Cc: zope@zope.org Date: Wednesday, April 15, 2009, 9:57 AM -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15.04.2009 17:33 Uhr, Bobby wrote: Looked at mxODBC but it's not free and MSSQL didn't worked for me either :(. It's cheap enough, well supported and worth the mone (please no further discussions about that everything must be free :-)) Andreas -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAknmA+AACgkQCJIWIbr9KYymFwCcCejKq8Phe6kHanPgAibreOLB aVgAnRPNly09xUr4JDv9PMjOvf5aTXZs =rdnq -END PGP SIGNATURE- ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
On Tue, Apr 14, 2009 at 1:22 AM, Andreas Jung li...@zopyx.com wrote: On 13.04.2009 23:33 Uhr, Bobby wrote: Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. mxODBC Here is a free (as in freedom) software created by Andreas Jung: http://pypi.python.org/pypi/z3c.sqlalchemy You will be required to install: 1. SQLAlchemy (Object Relational Mapper) http://www.sqlalchemy.org More details about using M$ SQL Server with SQLAlchemy: http://www.sqlalchemy.org/docs/05/reference/dialects/mssql.html 2. pyodbc (Python DB API 2.0 compatible module) http://pyodbc.sourceforge.net/ 3. FreeTDS (ODBC Driver for M$ SQL Server) http://www.freetds.org/ 4. unixODBC (ODBC Manager) http://www.unixodbc.org/ Well, it's all very easy to setup. More detailed steps: 1. Install Python 2. Install unixODBC While configuring unixODBC use --disable-gui option:: $ ./configure --prefix=/path/to/usr --disable-gui 3. Install FreeTDS While installing FreeTDS use these options:: $ ./configure --prefix=/path/to/usr --with-tdsver=8.0 --with-unixodbc=/path/to/usr/ 4. Configure odbc.ini In the /path/to/usr/etc/odbc.ini file, add something like this:: [db_connections] first_db = MS SQL Server [first_db] Driver = FreeTDS Description = My First Database Trace = No Server = 192.168.1.18 Port = 1433 Database = test_database 5. Configure odbcinst.ini [FreeTDS] Description = v0.68 with protocol v8.0 Driver = /path/to/usr/lib/libtdsodbc.so UsageCount = 1 5. Set environment variables ODBCINI=/path/to/usr/etc/odbc.ini ODBCINSTINI=/path/to/usr/etc/odbcinst.ini LD_LIBRARY_PATH=/path/to/usr/lib export ODBCINI ODBCINSTINI LD_LIBRARY_PATH To test your connection: /path/to/usr/bin/isql first_db username password 6. Isstall pyodbc (Refer: http://www.easysoft.com/developer/languages/python/pyodbc.html) Here is some relevant text: To build pyodbc against unixODBC, you need to tell the compiler and linker where to find the unixODBC include files and libraries. To do this, open setup.py in a text editor and find these lines: extra_compile_args = None extra_link_args= None Edit the second line so that it looks likes this: extra_compile_args = None extra_link_args= ['-L/path/to/usr/lib'] Find this line: extra_compile_args = ['-Wno-write-strings'] Edit the line so that it looks like this: extra_compile_args = ['-Wno-write-strings', '-I/path/to/usr/include'] 7. Install SQLAlchemy 8. Install z3c.sqlalchemy If you succeed with this, can you create a tutorial about how to do it ? :) Regards, Baiju M ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
I use Objet Craft MSSQL zope/python adapter for local Sybase (free, used as DB connector only) in production enviroment for 4.5 years. Please look at google, search for: lukesh mssql zope. I use it with old Zope 2.5.1 and with Zope 2.9.4 without any problems. It is very good and interesting solution, because it have incorporated session/transaction mechanism. Regards, JL. - Original Message - From: Bobby cybercruis...@yahoo.com Looked at mxODBC but it's not free and MSSQL didn't worked for me either :(. Is there some other free DB Adapter that I could use? Can I do an external method using Perl or a Python script to connect? ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 13.04.2009 23:33 Uhr, Bobby wrote: Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. mxODBC - -aj -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (Darwin) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAknkK5gACgkQCJIWIbr9KYxwSwCeNGeygGhPPfcRtT3f1/fvRcEr sKUAoKoU8l49M4OSNhtFFaNnNYQhPvMw =tOvV -END PGP SIGNATURE- begin:vcard fn:Andreas Jung n:Jung;Andreas org:ZOPYX Ltd. Co. KG adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany email;internet:i...@zopyx.com title:CEO tel;work:+49-7071-793376 tel;fax:+49-7071-7936840 tel;home:+49-7071-793257 x-mozilla-html:FALSE url:www.zopyx.com version:2.1 end:vcard ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
Re: [Zope] Database Adapter For Windows DB
Quoting Bobby cybercruis...@yahoo.com: Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. I found this, I hope it is useful to you http://www.zope.org/Members/roberth/ZMSSQLServer Regards Garry ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
[Zope] Database Adapter For Windows DB
Hi, I'm running Zope on a Linux box and need to connect to a Window's SQL Server machine. Which Zope's DB Adapter should I use? Thanks. ___ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )
