Jump to content
View in the app

A better way to browse. Learn more.
FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Moving data with ODBC

bbaliner
in External Data Sources

Featured Replies

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

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.

  • Author

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!!

Create an account or sign in to comment

https://fmforums.com/topic/7348-moving-data-with-odbc/
Go to topic listing

Important Information

By using this site, you agree to our Terms of Use.

I accept

Configure browser push notifications
Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.