hi, So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join). J.
Hello J. 1) For MS SQL access from Linux see FreeTDS (http://www.freetds.org) 2) You then need ODBC (I use the unixodbc, version from SuSE CD) 3) You then need ODBC access from Zope, Here I use the EGenix drivers (Payware), cause when I first setup my stuff up I was not to happy with the free ODBC stuff for Zope. I suspect that now (2 years later) the ODBC stuff could be better? Maybe some will give you some ODBC tips here that I can use? Jerry On Wed, 2004-04-07 at 00:12, Jason C. Leach wrote:
hi,
So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join).
J.
_______________________________________________ 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 )
Much gnashing of teeth is heard over the Zope open source ODBC Da on Zope-DB mailing list. eGenix MxODBC is the answer. That is. . . until someone is willing to fix the open source one. On Tue, 2004-04-06 at 18:28, Jerome R. Westrick wrote:
Hello J.
1) For MS SQL access from Linux see FreeTDS (http://www.freetds.org) 2) You then need ODBC (I use the unixodbc, version from SuSE CD) 3) You then need ODBC access from Zope, Here I use the EGenix drivers (Payware), cause when I first setup my stuff up I was not to happy with the free ODBC stuff for Zope. I suspect that now (2 years later) the ODBC stuff could be better?
Maybe some will give you some ODBC tips here that I can use?
Jerry
On Wed, 2004-04-07 at 00:12, Jason C. Leach wrote:
hi,
So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join).
J.
_______________________________________________ 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 )
Why not just connect to the MySQL Server directly? Check the MySQL manual on-line. On Tue, 6 Apr 2004, Jason C. Leach wrote:
hi,
So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join).
J.
_______________________________________________ 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 )
On Wed, 2004-04-07 at 00:55, Dennis Allison wrote:
Why not just connect to the MySQL Server directly? Check the MySQL manual on-line.
From Linux?
On Tue, 6 Apr 2004, Jason C. Leach wrote:
hi,
So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join).
J.
_______________________________________________ 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 )
Jerome R. Westrick wrote:
On Wed, 2004-04-07 at 00:55, Dennis Allison wrote:
Why not just connect to the MySQL Server directly? Check the MySQL manual on-line.
MS-SQL, not My-SQL
From Linux?
Did you browse all possible zope products at both www.zope.org and old.zope.org?
On Tue, 6 Apr 2004, Jason C. Leach wrote:
hi,
So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join).
Look at: http://www.google.com/search?q=zope%20mssql%20OR%20%22ms%20sql%22&ie=UTF-8&o... -- Jaroslav Lukeš -- Tento e-mail nemůže obsahovat VIRY jelikož nepocházi z virózního systému M$ Windows!
Not MySQL, MS-SQL, i.e. Microsoft SQL Server. Dennis Allison wrote:
Why not just connect to the MySQL Server directly? Check the MySQL manual on-line.
On Tue, 6 Apr 2004, Jason C. Leach wrote:
hi,
So I'm looking for a cost effective way to connect Zope on Linux to MS SQL Server 2K on Windows. I know about the ODBC-ODBC bridge, but that is a bit expensive for what I need. Any other ideas? I really just need the basics from SQL (Select, Update, Join).
J.
_______________________________________________ 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 )
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
participants (6)
-
Cormac McClean -
davdunc -
Dennis Allison -
Jaroslav Lukesh -
Jason C. Leach -
Jerome R. Westrick