I am using FM PRO 5.0.
I have tried accessing a FM5.0 file using ODBC and EXCEL, ACCESS and another ODBC compliant application.
All attempts have failed.
I have set up the ODBC data source and am able to select it. I have enabled LDAP in the FM file and opened and minized the file.
In all cases I see the field names in the FM file but I cannot retrieve any data!
ACCESS seems to start importing the data then throws off an error message saying that one particular field is an invalid format. This field is the same number format as dozens of other fields that come before it!
Excel will just chug away for a couple of minutes and never return any data. A third application (WEBFOCUS) can also read the field names but returns an open cursor error and will not retrieve any records.
Anyone got a clue?
Thanks!