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.

ODBC and Queries/Finds

grumbachr
in External Data Sources

Featured Replies

My server has crashed a few times when someone has remotely connected to my FM Server that has been rock solid for prior to switching on ODBC connections.

I'm curious if anyone could help me try and determine a cause. As I don't know much about ODBC (my fault there I need to get up to speed on this) and was wondering if there a difference in where the queries or finds are coming from. Is a Find from FM to the SQL db significantly different than a query from SQL to FM. Would one be be more taxing on my server than another? (the SQL file is on a different server)

The other thing that is odd is that these crashes only seem to happen when the person is working offsite. When she is in the office these crashes have never occurred.

I know this could be to complex to really determine the cause but if anyone could point me in the right direction it would be greatly appreciated.

Server is FMS Advanced on Windows 2003 64bit. It is a virtual machine but has tons of memory and processors dedicated to it. I'm wonder if the 64bit might be the troubles now that I type that detail in.

Create an account or sign in to comment

https://fmforums.com/topic/63572-odbc-and-queriesfinds/
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.