The scenario:
Working and reliable Sybase SQL Anywhere 10 database (.db and associated .log) work fine with Servoy under either Windows XP or Server 2003 operating systems.
For a trial period, I wish to run the same db under OS X Leopard.
The procedure:
Have stopped Sybase on XP, then copied the db and log files over to Mac, and into a new Servoy install, downloaded 31 March 09. Changed sybase.config to list the db transferred from XP.
The issue:
Problem is that the transferred db is not recognised.
Looking at the db icons in Finder, I see a difference in the icon appearance for the standard Servoy install collection (all the same: Get info shows they are ‘documents’) and the ‘foreign’ (ex Windows) db, which is listed in Get info as ‘Unix executable’.
Have I assumed too much in thinking that the file format for SQL Anywhere 10 dbs is the same under Win and OS X?
More on this issue - now resolved
On another channel, Sybase have confirmed that the db files are binary compatible.
The Unix executable property arose as a result of transferring the dbs using a FAT32 drive. I have changed mode (CHMOD) to 444, removing execute permissions.
The dbs are now recognized.