Disappointed in the fact that FM5.5 server does not support ODBC, I'm now creating a client-app to insert FM-data into a M$ Access database.

It's easy to create a ODBC for a plain FMP 6 data file (often referred to as a database, but it's just one simple table really). But now this data file has a password on it. So when i choose the ODBC to use for M$ Access it does show the tablename, but gives an error on using it. This does not apply if there is no password on the data file.

Can anyone tell me how and where to specify the password in using the ODBC?

I do not have any idea, sinceI mainly work on MacOS but a quick search at google revealed

http://forums.devshed.com/archive/46/2003/03/2/54777

where you probably find more info about this.

Found this one as well...

But again, it's a problem that's been registrated, NOT a solution!

there should be an option or checkbox in the dialog where you define DSNs , "specify password" or something..., OR ....

FileMaker is using your windows login by default ....

dunno ...

try

http://www.firebridge.com.au/odbc.htm

Disappointed in the fact that FM5.5 server does not support ODBC, I'm now creating a client-app to insert FM-data into a M$ Access database.

why should it have that? FM Server does nothing with fm files other than serving them to clients fast and do an occasional backup. Absolutely no interface to access the data in the file. Every full FM Client, however, can serve databases ...

Hi,

don't know if that's what you're looking for, but to access a password protected DB using PHP (ODBC), just use the following :

$odbcFMP = odbc_connect("FileMaker", $user, $password) or die("CAN'T CONNECT");

$result = odbc_exec($odbcFMP, $Query);

Jerry

P.S : $user is probably optional for FileMaker

side note:

ODBC (DSN)...is not that great in ENTIRE FM family....so do expect performance lags or hope that FM makes another DB engine

<!- HENS->

"I'm now creating a client-app to insert FM-data into a M$ Access "

- why are you mixing Access with FM-if you use Access as a primary data storage?

good luck alta'