Re: [MacPerl] MacPerl and FileMaker via DBI?

[Bruce Van Allen <bva@cruzio.com>]

At 7:18 PM 11/12/00, Axel Rose wrote:
>On Sun, 12 Nov 2000 09:15:42 -0500 Chris Nandor <pudge@pobox.com> wrote:
>>  Well, in theory, DBD::ODBC could be made to work; I think FM Pro does
>>  ODBC now.
>
>Could please anybody clearly state whether FM Pro can access other ODBC
>databases or is *accessible* from other clients through ODBC.
>
>If I only knew the latter works I would risk some experiments.
>

Sez this in the FMP 5.0 docs:

#####
You can use the ODBC support in FileMaker Pro to:
  - work with FileMaker Pro data from ODBC-compliant applications to 
create charts, construct ad-hoc queries, and analyze your data with a 
variety of software applications
  - construct SQL queries in FileMaker Pro to import data from other 
ODBC data sources like Microsoft Access or Oracle databases
Notes about sharing FileMaker Pro data via ODBC:
  - FileMaker Pro is Level 1 ODBC compliant, with limited Level 2 support.
  - FileMaker Pro files support a single connection and multiple 
statements per connection.
  - Access FileMaker Pro data from a number of Windows ODBC client 
applications, like Microsoft Office 97, BrioQuery 5.5, Net Objects 
Fusion 3.0, and more.
  - Access FileMaker Pro data from Mac OS ODBC client applications 
like Microsoft Query, Microsoft Excel 98, and BrioQuery 5.0.

Note	The FileMaker ODBC driver can't pull data from a related 
FileMaker Pro file. To access data from multiple tables, construct 
your SQL query accordingly.

Notes about importing ODBC data into FileMaker Pro:
Use one of the included ODBC drivers to import data from one of these 
data sources:
  - Text (Windows and Mac OS)
  - Oracle 8 (Windows)
  - Oracle 7 (Mac OS)
  - SQL Server 7 (Windows)
You can also import ODBC data using a third-party ODBC driver.
#####


Go for it!

1;

- Bruce

__Bruce_Van_Allen____831__429_1688__
__PO_Box_839__Santa_Cruz_CA__95061__


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