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