[Date Prev][Date Next][Thread Prev][Thread Next] [Search] [Date Index] [Thread Index]

Re: [MacPerl] MacPerl and FileMaker via DBI?



Hi Axel,

>Hello Thomas,
>
>thanks for the summary.
>
>I'm thinking about a different way:
>
>If I have DBD::ODBC running on a Unix machine shouldn't it be
>possible to access the ODBC Server FileMaker Pro database from
>there??

I don't know exactly, now I'm confused. This means that ODBC is a 
transmission protocol? But why must it be linked against a vendor 
specific library, when you build the DBD::ODBC  driver extension? I 
guess you will need this library (i.e. a FM lib) for the Unix box.

>Unix as the client, TCP/IP network, FMPro on Mac with ODBC service
>in short.

[Pssst. Don't tell anybody. Usually, the Unix machine is the server. ;-) ]

>The need to access FMPro through ODBC stems from non Mac platforms,
>doesn't it? (a web server e.g.)

Not necessarily, I guess. As I understand ODBC (and I may be wrong), 
it's just a standardized API which a DB vendor may support or not. A 
client program that relies on ODBC calls should be able (after 
dynamically loading the correct library) to connect to a DB from 
vendor A or vendor B, if both support ODBC and supply a ODBC driver/ 
library. Whether the connection is made over a network or not depends 
on the DSN, the data source name. It's either some sort of local 
filename or some sort of a network filename (e.g. 
tcp://host:port;db=myDatabase).

>Axel
>just some thoughts

May be, a ODBC guru can clearify things?

Tschüss,

--Thomas

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