Error reading password-protected FM in SQL Server

[Scott]

I'm trying to pull certain Filemaker 5 tables into SQL Server 2000 in
an automated import job using a file DSN. Everything resides locally
on a Windows XP machine. My process works fine on a test FM file with
no password, but with the real FM files, all password protected, it
fails with this error:

******
Error Source: Microsoft OLE DB Provider for ODBC Drivers

Error Description: Unspecified error
[FileMaker][ODBC FileMaker Pro driver]An error has occurred while
trying to gather a list of available tables.
[FileMaker][ODBC FileMaker Pro driver][FileMaker Pro]Connect failed.

Context: Error calling GetRowSet to get DBSCHEMA_TABLES schema info.
Your provider does not support all the schema rowsets required by DTS.

******

This happens whether or not I supply a password to the SQL Server job.
It has been nagging me for days and I can't find any documentation on
it. Has anyone else encountered this?

Thanks very much.
Scott

[MSgtMark]

Scott,

Do you have Filemaker open on the SQL server desktop? Filemaker 5 requires the file(s) used in OLE be open for the Filemaker supplied driver to see it. This is true even if the files are served out by FM server.

Mark