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.

FM9 Server Link to SQL Failure

systwo
in External Data Sources

Featured Replies

Hi Guys!

I'm struggling! I have a FM 9.03 Windows Server 2003. I am attempting to drop in some tables from an external SQL server database (on my web server) so that users can dynamically update records on the SQL server.

I have no problem creating a System DSN and putting the required tables into the ralationship graph, then creating the link to the FM tables and then updating the required fields in SQL.

BUT, it will only work for one user. I can create the external data source in FM I can only crete it with the 'Prompt user for username and password" option because if I try to use the "Specify username.... (applies to all users)" option it gives me an error "The specified table cannot be found".

There seems no way around it as I cannot enter a table in the fields as I get the same error.

I have spoken to support and all the say is that I need the correct SQL native client 2005.90.3042.00, but where do I find this?

Any help gratefully received.

  • 3 weeks later...

Chris, we are having the same issue, just found some information at:

http://msdn.microsoft.com/en-us/library/ms131321.aspx

Create an account or sign in to comment

https://fmforums.com/topic/63260-fm9-server-link-to-sql-failure/
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.