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.

Import into Mounted SQL Server Table, from Server Advanced

NYPoke
in External Data Sources

Featured Replies

Running FM 12.4 Client & Server Advanced.  Server is Windows 2008.  SQL Server is 2005.  Running Client & Server on a Virtual Machine.

 

I mounted a SQL Server Table, to consolidate Marketing Data.  We have this running in FM.  Wanted to keep the data in SQL Server, for various reasons.

 

I am Importing the data from 5 FileMaker Tables into the SQL Server Table.  Other than it being a complete dog for perfomance (both in FM & SQL Server), it works well when running from the Client.

 

When I try to run it through a Schedule on the Server, I get Error 100 on the Import.  Assume that means "File Not Found".

 

It appears to find the FM Files fine, as I run a Find Script without errors.  The Import, though, is getting Error 100.  Assuming it is having problems finding the SQL Table.

 

ODBC Driver is loaded on the Server.  Has to be for the Client mount SQL Server properly.  ODBC Driver is installed as a System DSN.

 

Schedule is using FM Permissions, which have Admin Permissions.

 

Rather much at a loss on this one.

  • Author

I should have searched more...

 

http://fmforums.com/forum/topic/64713-server-side-imports-and-exports/

 

Did not know Server had an issue with Imports.  Version 12 & we still cannot import FM File-To-File?

 

I hate to move all the data to SQL Server, but if Server is not that important, I guess we can go that way.

 

Admin: This post should probably be moved to Import/Export...or just deleted.

Create an account or sign in to comment

https://fmforums.com/topic/89429-import-into-mounted-sql-server-table-from-server-advanced/
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.