Hi, I need to read an M$-SQLServer database from an conectiva linux machine. Is there an free alternative to mxODBC or a simpler way to do that then the one described on: http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver Thanks in advance, Rogerio ------------------------------------------------- E-mail enviado pelo Webmail CensaNET http://www.censanet.com.br/webmail
I need to read an M$-SQLServer database from an conectiva linux machine.
Is there an free alternative to mxODBC or a simpler way to do that then the one described on: http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver
Nope. Pay or prepare to do some gymnastics. Maybe someday there will be a free cross-platform ODBC, but that day is not today. I've not tried the setup in the howto, but it doesn't seem unreasonably complex for what it does. --jcc
I purchased the mxZODBC DA from www.egenix.com. I have not got it to work on my Linux installation due to the fact that getting iODBC to work with FreeTDS hasn't been easy. If I were to purchase a 8 thousand dollar MSSQL ODBC driver for Linux all of that would probably change. If you find a driver that is less cost-prohibitive let me know. It isn't enough to fork out the dough for SQLServer. I do have it working on the Windows server which is running Zope. It works well, other than running Zope on Windows. :( Scott -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org] On Behalf Of ratem@censanet.com.br Sent: Tuesday, May 13, 2003 11:18 AM To: zope@zope.org Subject: [Zope] ODBC + Linux Hi, I need to read an M$-SQLServer database from an conectiva linux machine. Is there an free alternative to mxODBC or a simpler way to do that then the one described on: http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver Thanks in advance, Rogerio ------------------------------------------------- E-mail enviado pelo Webmail CensaNET http://www.censanet.com.br/webmail _______________________________________________ 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 )
Scott,
I purchased the mxZODBC DA from www.egenix.com. I have not got it to work on my Linux installation due to the fact that getting iODBC to work with FreeTDS hasn't been easy. If I were to purchase a 8 thousand dollar MSSQL ODBC driver for Linux all of that would probably change. If you find a driver that is less cost-prohibitive let me know. It isn't enough to fork out the dough for SQLServer. I do have it working on the Windows server which is running Zope. It works well, other than running Zope on Windows. :(
Now I can see that I have two alternatives: 1)Buy mxODBC or 2)Struggle to configure freeTDS and SQLRelay... Although I haven´t checked Zdataquerykit, I´ve been thinking of a third one (nothing elegant...): 3)Since I only need to read the DB and my application, and I can do that using batches, I can write an extract program that runs from time to time, upload the results via FTP to Linux in some Zope/Python friendly format (CSV for instance) and do my queries... Quite ugly, quite slow, isn´t it? On the other hand, the Zdataquerykit page (http://www.zope.org/Members/haqa/ZDataQueryKit/readme) says: "ZODBCClient Query ODBC Socket Servers This object, formerly part of my XMLKit product provides the ability to query an ODBC Socket Server from Zope. This, finally, allows Zope running on any platform to query Microsoft ODBC Databases on a Windows PC." I think I´ll give a try... Anyway, thanks everyone. Rogerio ------------------------------------------------- E-mail enviado pelo Webmail CensaNET http://www.censanet.com.br/webmail
ratem@censanet.com.br wrote at 2003-5-13 15:17 -0300:
I need to read an M$-SQLServer database from an conectiva linux machine.
Is there an free alternative to mxODBC or a simpler way to do that then the one described on: http://www.zope.org/Members/zorton/zope_linux_to_mssqlserver
Please search the mailing list archives: Some times ago, I posted a summary. Meanwhile, there is an additional approach that uses MS-SQL XML query facilities. When I remember right, the project is hosted at SourceForge. However, I no longer remember any details. Dieter
participants (4)
-
Dieter Maurer -
J Cameron Cooper -
ratem@censanet.com.br -
Scott Burton