rivet

ODBC oddity

Discussion created by rivet on Apr 1, 2016
Latest reply on Apr 1, 2016 by rivet

I have a FMP DB that connects to an ODBC data source.  On my dev environment everything is working fine but when I move DB to my production environment there is a strange thing going on.

 

On the production DB, if I take a look under the relationship graph and double click one of the table occurrences that is connected to the ODBC source, the Specify Table dialogue appears but none of the tables are highlighted.  If I hover over that same able occurrence the popup shows all the correct details.  ( source tables, data source, ODBC data source).

 

Now if i were to 're-specify' the correct table for that table occurrences, all the field mapping is lost and all layouts and script are a mess.

 

Has anyone come across this.

 

DEV:

server: mac  10.10.5

FMPS: 14.0.4.414

ODBC DRIVER: actual technologies

FMPA: 14.0.5

 

PRODUCTION (hosted cloud):

server: win  ?

FMPS: 14.0.2.226

ODBC:  mysql driver

FMPA: 14.0.5

Outcomes