AnsweredAssumed Answered

odbc record issue

Question asked by alindco on Sep 25, 2012

Summary

odbc record issue

Product

FileMaker Pro

Version

12

Operating system version

mac 10.7 and windows 7

Description of the issue

with Mysql odbc drivers on both mac and pc i get different results. on mac 10.7 i get 3 records with data and garbage for rest of records. on pc i get every record. counts are also different for records on mysql db.

Steps to reproduce the problem

use odbc manage external connections. connect to mysql on godady server instance (ip address) create table connection in manage relations. view records as table. on mac 10.7 see data in first 3 rows and "?" for all others, record count changes with time (less records) . connect on PC same way record count 2038, table view  has data in 2038 rows.

Expected result

there are 2038 records, I expect Mac to connect and dispaly all data not just 3 records

Exact text of any error message(s) that appear

none

Workaround

what, use a pc instead?

Screen_Shot_2012-09-25_at_7.58.57_AM.png

Outcomes