Re: [MacPerl] Filemaker Pro DB

[Thomas Wegner <toms_email@gmx.de>]

>Um 20:05 Uhr +0200 13.09.2000, schrieb Thomas Wegner:
>>I' ve recently downloaded DBD::ODBC from CPAN. The distribution
>>contains .xs and .h files. This normally indicates that the module
>>has to be ported to or at least compiled for the Mac (see
>><http://pudge.net/macperl/macperlmodinstall.html>). Because it can't
>>be found on http://pudge.net/mmp/, we are out of luck, I guess (until
>>someone does the port, of course).
>
>Well - I'm thinking about it.
>I doubt though whether accessing FM Pro via ODBC is effecitve
>nor possible from remote. Perhaps somebody on the list can grab
>out the manual and report about experiences.
>
>ODBC support for the Mac is still dreadful.
>Oracle captain and (once?) member of the Apple board Larry Ellison
>some years ago promised the release of all Oracle software for Apple
>machines. Try to get a Mac ODBC driver for Oracle!
>Or try to connect from MS Office applications with remote
>databases ...
>
>Ideally I would like to see a DBD::ProxyServer running on Macs,
>connecting via (?) to FM Pro.
>This on the other hand would need to have Storable, Net-Daemon,
>PlRPC + DBD::ODBC/DBD::FMPro or DBD::Glue::FMpro
>(german readers may read the iX article 
>http://www.heise.de/ix/artikel/2000/10/176/ )
>
>It's a pity that Mac database programmers live in such a limited
>world.
>
>
>Cheerio
>
>
>Axel
>
>P.S.: Sorry for complaining about non MacPerl issues.

Hi Axel, Hi all,

have you or has someone else already tried Primebase DB (I have not)? 
It's one of the few Mac DBs that comes with an ODBC driver. Primebase 
DB (a client/server DB) is part of a Web application-server, which 
the company has developed (German readers see c't-magazin 16/2000, 
page 17). As far as I know, there is a free (limited) version for 
Linux. For other OSs including Mac OS it's possible to download a 3 
month evaluation version. Developers can get an unlimited developer 
key, if they provide (from Primebase's web site):

- A brief description of your project
- Estimated duration of the project
- The platform you plan to develop on
- Number of users/connections you need for development and testing

See

[de]: http://www.primebase.com/indexd.html
[en]: http://www.primebase.com/indexe.html

for details and let me know how it works.


There may be another way of how a ODBC connection could be done, but 
I'm not sure if it will work (I don't own FileMaker or another ODBC 
capable DB):

DBI with DBD::JDBC driver <--> SUNs JDBC-ODBC Bridge <--> any DB with 
ODBC driver

I was just about to prepare an (fairly long) article for this mailing 
list, when the Filemaker Pro DB thread came up. I've just finished 
this article (in a hurry :). Please read the "When Perl meets Java 
... " posting.

See you there ...

Ciao

-- Thomas

# ===== Want to unsubscribe from this list?
# ===== Send mail with body "unsubscribe" to macperl-request@macperl.org