[Zope] ODBC + Linux

ratem@censanet.com.br ratem@censanet.com.br
Wed, 14 May 2003 10:17:06 -0300


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 wor=
k
> with FreeTDS hasn't been easy. If I were to purchase a 8 thousand dolla=
r
> 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 enoug=
h
> 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=B4t checked Zdataquerykit, I=B4ve been thinking of a thi=
rd one=20
(nothing elegant...):
3)Since I only need to read the DB and my application, and I can do that =
using=20
batches, I can write an extract program that runs from time to time, uplo=
ad the=20
results via FTP to Linux in some Zope/Python friendly format (CSV for ins=
tance)=20
and do my queries... Quite ugly, quite slow, isn=B4t it?

On the other hand, the Zdataquerykit page=20
(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 q=
uery=20
an ODBC Socket Server from Zope. This, finally, allows Zope running on an=
y=20
platform to query Microsoft ODBC Databases on a Windows PC."

I think I=B4ll give a try...

Anyway, thanks everyone.

Rogerio



-------------------------------------------------
E-mail enviado pelo Webmail CensaNET
http://www.censanet.com.br/webmail