Mailing List Archive: Zope: DB

FileMaker with Zope

Index | Next | Previous | View Threaded

ahumboldt at humboldt

May 22, 2007, 5:54 AM

Post #1 of 8 (1627 views)
Permalink

FileMaker with Zope

Hello,

I'm trying to connect FileMaker with Zope through ODBC, but I'm not
sure if I could do this for free, without buying any driver or
software. Can anyone explain to me how to do it or if it isn't
possible?

Thanks very much!

_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

lists at zopyx

May 22, 2007, 6:28 AM

Post #2 of 8 (1562 views)
Permalink

Re: FileMaker with Zope [In reply to]

--On 22. Mai 2007 13:54:14 +0100 David Daniel EstÃ©vez Durey
<ahumboldt[at]humboldt.e.telefonica.net> wrote:

> Hello,
>
> I'm trying to connect FileMaker with Zope through ODBC, but I'm not sure
> if I could do this for free, without buying any driver or software. Can
> anyone explain to me how to do it or if it isn't possible?
>

You ask that already two weeks ago and got several advices...did you take
them into account? If yes and if they don't fulfill your requirements,
spend 95 Euro for mxODBC from Egenix and be a happy man. 95 Euro don't
justify a week-long research with zero results.

-aj

dieter at handshake

May 22, 2007, 10:49 AM

Post #3 of 8 (1543 views)
Permalink

Re: FileMaker with Zope [In reply to]

David Daniel Estévez Durey wrote at 2007-5-22 13:54 +0100:
> ...
>I'm trying to connect FileMaker with Zope through ODBC, but I'm not
>sure if I could do this for free, without buying any driver or
>software. Can anyone explain to me how to do it or if it isn't
>possible?

To access any database via ODBC, you need an ODBC driver for this
database.

Usually, you also need an ODBC manager (one comes with Windows, I assume).

Finally, you need a Python-ODBC bridge and a Zope database adapter.
I think, under Windows, the ActiveState Python comes with a
Python-ODBC bridge.

There used to be a "ZODBCDA" database adapter as Zope product.
However, maintenance by "zope.com" stopped and some interested
people took it over. Maybe, you try to search for it.
Or you pay the XXX Euro and buy the eGenix "mxZODBDA", as suggested
by Andreas.

--
Dieter
_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

ahumboldt at humboldt

May 23, 2007, 2:50 AM

Post #4 of 8 (1572 views)
Permalink

Re: FileMaker with Zope [In reply to]

>
>> Hello,
>>
>> I'm trying to connect FileMaker with Zope through ODBC, but I'm not
>> sure
>> if I could do this for free, without buying any driver or software.
>> Can
>> anyone explain to me how to do it or if it isn't possible?
>>
>
> You ask that already two weeks ago and got several advices...did you
> take
> them into account? If yes and if they don't fulfill your requirements,
> spend 95 Euro for mxODBC from Egenix and be a happy man. 95 Euro don't
> justify a week-long research with zero results.
>
> -aj

Hello Andreas! First of all, thank you very much for answering.
Yes! of course I took all advices into account, and then someone told
me that I could make an ODBC connection.

At the begining, I thought that that choice would be free, but I think
now that I was in a mistake. I think now that I have to pay for the
FileMaker ODBC driver, and possibly for the Zope DA, and in my case
that is impossible, I have to get it without any cost.

The choice I am implementing now is exporting FileMaker to a plain text
file, and then using MySQLdb.py to import the data into mySQL. Finally,
I have my Zope connected with MySQL and I can access my data for free.

Anyway, it would be better to get the FileMaker/Zope connection for
free... but I'm realizing that is no possible.

_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

ahumboldt at humboldt

May 23, 2007, 2:52 AM

Post #5 of 8 (1539 views)
Permalink

Re: FileMaker with Zope [In reply to]

El 22/05/2007, a las 18:49, Dieter Maurer escribió:

> David Daniel Estévez Durey wrote at 2007-5-22 13:54 +0100:
>> ...
>> I'm trying to connect FileMaker with Zope through ODBC, but I'm not
>> sure if I could do this for free, without buying any driver or
>> software. Can anyone explain to me how to do it or if it isn't
>> possible?
>
> To access any database via ODBC, you need an ODBC driver for this
> database.
>
> Usually, you also need an ODBC manager (one comes with Windows, I
> assume).
>
> Finally, you need a Python-ODBC bridge and a Zope database adapter.
> I think, under Windows, the ActiveState Python comes with a
> Python-ODBC bridge.
>
>
> There used to be a "ZODBCDA" database adapter as Zope product.
> However, maintenance by "zope.com" stopped and some interested
> people took it over. Maybe, you try to search for it.
> Or you pay the XXX Euro and buy the eGenix "mxZODBDA", as suggested
> by Andreas.
>
Thank you very much for answering, Dieter, but the same I explained to
Andreas, money is a very big problem in my case.

_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

lists at zopyx

May 23, 2007, 2:59 AM

Post #6 of 8 (1543 views)
Permalink

Re: FileMaker with Zope [In reply to]

--On 23. Mai 2007 10:52:42 +0100 David Daniel EstÃ©vez Durey
<ahumboldt[at]humboldt.e.telefonica.net> wrote:
>>
> Thank you very much for answering, Dieter, but the same I explained to
> Andreas, money is a very big problem in my case.
>

Then the final answer is: No, there is no suitable for solution for you.

-aj

lists at zopyx

May 23, 2007, 3:12 AM

Post #7 of 8 (1566 views)
Permalink

Re: FileMaker with Zope [In reply to]

--On 23. Mai 2007 10:50:40 +0100 David Daniel EstÃ©vez Durey
<ahumboldt[at]humboldt.e.telefonica.net> wrote:
>
> Hello Andreas! First of all, thank you very much for answering.
> Yes! of course I took all advices into account, and then someone told me
> that I could make an ODBC connection.

Have you tried SQLAlchemy?
Have you tried z3c.sqlalchemy together with SQLAlchemy?
Have you tried SQLAlchemyDA together with SQLAlchemy?

If yes, why did it work? We would like to hear feedback and informations
about errors *in order* to improve our software. So please be a bit more
helpful...

>From what I heard: SQLAlchemy is working on several systems over ODBC.
So if your DB speaks ODBC then there is a good chance to make it work.
If it does not work then please explain what the problems are.

-aj

dieter at handshake

May 23, 2007, 10:39 AM

Post #8 of 8 (1542 views)
Permalink

Re: FileMaker with Zope [In reply to]

David Daniel Estévez Durey wrote at 2007-5-23 10:52 +0100:
> ...
>> There used to be a "ZODBCDA" database adapter as Zope product.
>> However, maintenance by "zope.com" stopped and some interested
>> people took it over. Maybe, you try to search for it.
>> Or you pay the XXX Euro and buy the eGenix "mxZODBDA", as suggested
>> by Andreas.
>>
>Thank you very much for answering, Dieter, but the same I explained to
>Andreas, money is a very big problem in my case.

Then, you need to read very carefully!

I sketched an option that does not cost money:
"Maybe, you try to search for it (ZODBCDA)".

I do not know how good the new maintenance is or in what
state ZODBCDA currently is. You need to invest time (as you
cannot invest money) to find this out.

--
Dieter
_______________________________________________
Zope-DB mailing list
Zope-DB[at]zope.org
http://mail.zope.org/mailman/listinfo/zope-db

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact lists@gossamer-threads.com