Moving data with ODBC

[bbaliner]

Hi there,

I must admit I'm new to this ODBC driver in File Maker, and I turn to for help on thisa issue.

I would like to be able to move data in and out of File Maker with a client app called "Progeny". That's a program that itseld in turn uses Sybase to draw pedigrees.

1.Since we have FM Server 5.0, I understand I should create DSN on the machine that has Progeny, enable Remote Data Access and point it to the FM Server. That will allow me to get data FROM FM Server into Progeny.

Can I also import data from Progeny INTO FM SErver in this fasion?

2. I'm reading that FM Pro is Level 1 complient, but not Level 2. What does this mean in English?

Thanks for your help

[Anatoli]

You have to get the data from FileMaker Client with ODBC. Client can be connected to FileMaker Server.

To second part – hmm -- read as FM is behind current ODBC development.

[bbaliner]

I hear ya Tolya,

So you're saying that the server doesn't have the Local Data Access Companion plug-in, so I need to create DSN on the client FM Pro machine, right?

I think Level 1 just means very basic SQL commands, no DDL. Correct me if I'm wrong.

Thanks for the input!!