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.

FMP connection problems to SQL, for a SQL newb.

DrRoebuck
in External Data Sources

Featured Replies

I've had very little experience with MS SQL Server, but I understand the basic concepts of it.

Enough so that I set up a Windows 2012r2 server this weekend and installed SQL Server 2014.

I installed it in mixed mode, so that users could use Windows authentication or SQL authentication to access a test database I created.

I figured out how to create a user properly so that the test database I created will show up in the Windows ODBC setup System DSN box when I change the default database.

However, once I open FMPA 12 and try to add one of my tables to the relationship diagram, none of my tables show up.

I've added the same username to Database\Security\Users and made what I can tell are any appropriate settings to this account, but I still can't see my tables.

I understand this is probably SQL 101 but any assistance would be greatly appreciated.

When you set up the External Data Source in FM, do you actually see the DSN you've set up for your SQL server?

If not then it is because you did that in the 64-bit control panel.  FM12 is 32-bit so it needs a DSN in the 32-bit ODBC control panel.

  • Author

Thanks, I do see it, just not the tables.

I figured out the whole 32-bit thing after a lot of trial-and-error.

Edited by DrRoebuck

If you try the same DSN from say Excel.  Do you see the tables then?

  • Author

If you try the same DSN from say Excel.  Do you see the tables then?

​Nope. I feel like this is a permissions issue on the SQL server, but I can't figure out where.

Create an account or sign in to comment

https://fmforums.com/topic/96508-fmp-connection-problems-to-sql-for-a-sql-newb/
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.