Initializing ODBC Access to FMP 5

[jadekyrn]

I am using a microsoft product to attempt to access an
FMP 5 database file ( .fp5 ) on a LAN Server.

SQLCONNECT( 'FileMaker Pro v5' ) returns a positive indicator showing a successful connect.

SQLEXEC( nFMHndl,
'Select * FROM "\\Filemaker\FilemakerDatabases\test"',
'cResult' ) generates ODBC Error from FMP-> "Open Failed"

I have all passwords,
I have set sharing on,
I have initialized both local and remote plugins.

I suspect I am not correctly identifying the table.
( Export is not an option as some of the fields are being
truncated. )

Any suggestions?

 

[dsimpson1]

The following Perl program does something similar to the query you have listed here:

http://www.dotcomsolutionsinc.net/p...e_files/fmpro_migrator_oracle_xfer_odbc1.html

However in SQL queries to FileMaker you need to list the database name with no spaces and not give the file path to the database file as you might do when creating an Access DSN entry. David Simpson