Jump to content

Recommended Posts

Hi all

I'm trying to connect to an Azure SQL database from FileMaker 16. I've added the DSN via ODBC 32bit (see pic). However, when I go to File>Manage>External Data Sources, it doesn't show the DSN.

Where am I going wrong?

Thanks in advance

 

Untitled.png.d6ed3bf535cbd1ba68c554abf9fe5816.png

Share this post


Link to post
Share on other sites

Is your FileMaker Pro also 32-bit? The app and the driver have to match.

Share this post


Link to post
Share on other sites

My FileMaker client is 64-bit. So i deleted the ODBC 32-bit DSN and added it to the 64-bit version instead. But it is still not showing in the external data source list.

Share this post


Link to post
Share on other sites

I'm still nowhere further on this. Is there a (very simple) guide somewhere for setting up ODBC?

Thanks

Share this post


Link to post
Share on other sites

I can see the DSNs in a newly created local blank database. However when i upload this to our server the DSNs no longer appear. I've enabled ODBC in filemaker server but no joy.

Share this post


Link to post
Share on other sites

No i just ticked the Enable ODBC/JDBC checkbox on the server. I tried to add the DSN from my client machine. The DSN is on my local machine.....Aaaaand I've just set up the DSN on the server instead and I can now see it!

I take it this is the correct and only way for it to work for a hosted database?

Untitled.png.9049a05653f41df9c9c74eef1462e449.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Who Viewed the Topic

    9 members have viewed this topic:
    ddinisco  Josh Ormond  BruceR  Lee Smith  doughemi  MikeKD  Ocean West  bcooney  LaRetta 
  • Similar Content

    • By losferwords@outgun.com
      I've been working with SQL databases for about 12 years now, and have stumbled across this monstrosity in a new position - and I really don't get the translation between Filemaker and SQL.
       
      This should work according to the documentation:
      ExecuteSQL ( " SELECT Customer_EVENT::Inv_dollars )  FROM Customer_Event WHERE Customer_EVENT::FlagReview = \" " ; "" ; "" )
      ...or something. I really can't even get a simple SQL Statement just pulling anything more than 1 field to work. Is there a reference out there (not Filemaker or FM14 Bible) that actually explains in detail WHY FQL statements are made the way they are and how each piece interacts?
      I'm not sure I can do this with a calculation, but it's entirely possible. I'm just trying to get a SUM on a certain set of records to display SOMEWHERE in a layout. The fields are from a related table, but have nothing to do with the related records. It's just a way to SUM the objects in a portal by "filtering" the amount.
       
       
    • By Hrcap
      Greetings All
       
      I am looking to add a line into the following code into the 'prepare payload for client' section to select only records that match the following criteria
      I have a variable set called: $additional_settings The field that needs to match with $additional_settings is called _kf_uuid_companys the code that i have already is as follows, i need to add a line into this code to pick records where the field _kf_uuid_companys matches $additional Settings.
      Any help would be greatly appreciated:
       
      "SELECT "
      & $dyn_sql & ", '"
      & $$record_delimiter & "'"
      & " FROM \\"" & $sync_table & "\\""
      & " WHERE " &
       
       
       
      // Exclude records flagged for sync exclusion.
      "( COALESCE ( BS_Exclude, 0 ) = 0 ) " &
       
       
       
       
      // If the client is merging new/updated data with data already on the device...
      // Only include records that have been added/updated since the last pull...
      // And only include data that they did not just push (i.e. no "round tripping!")...
       
      If ( ( $$sync_method = "Merge" )
      and
      ( $last_pull_utc > 0 ) ;
       
      "AND ( BS_UTC_Time > " & $last_pull_utc & " ) " &
       
      "AND ( COALESCE ( BS_Device_ID, 'X' ) <> '" & $client_persistent_id & "') "; "" )
    • By sal88
      Hi all
      I'm trying to find the Client that has the most Job time over the last 30 days, divided by the number of seats that they have. The tables are:
      Clients
      Client_ID, Seats
      Jobs
      Client_IDF, Job_time, Job_Date
      The best I've managed so far is to find the distinct Client_IDF from all Jobs:
      ExecuteSQL ( "SELECT DISTINCT j.log_client_IDF FROM Jobs J WHERE j.Log_date >= ?"; ""; "";  $date_30_days_ago) And then loop through the list and perform the 'divide by seats' calculation for each line
      Or to do something similar but from the Clients table:
      ExecuteSQL ( "SELECT SUM (j.labour_units), c.Name FROM Clients C JOIN Jobs J ON j.log_client_IDF = c.Client_ID WHERE l.Log_date >= ?"; ""; ""; $date_30_days_ago) But no joy in either case when it comes to actually performing calculations within SQL.
      Is this possible in FM SQL?
      Many thanks
    • By Mark Stuller
      Hello
      We are going to take the plunge and setup a sync between our Oracle tables and 'shadow' FileMaker tables and we're seeking input.
      One thing we are wondering about is a 'one-way' sync. We don't want changes to be sync'd back to Oracle. The bigger issue is that we don't want deletions in the Oracle table to be deleted in the FileMaker table. There often are children to these records we don't want deleted or orphaned.
      As well, are there any gotchas we should consider? I've read the Advanced topics and feel mostly comfortable but you never know what you don't know!
      Thanks, Mark
    • By ggt667
      How can I get ESS access to PostgreSQL from FM11SA?
×

Important Information

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