ODBC Import Problem-From Sybase SQL Anywhere to FMPro
I try to import data from an SQL Anywhere database using FMPRO12 in Windows7. I have installed client odbc driver, iAnywhere 12 (both 64bit and 32 bit) which I have succeded to use in for example excel and ms access queries.
I am able to log in to the server and I get the tables and fieldnames during import, but when it comes to executing the query I get the error " ODBC Error: [Sybase][ODBC driver][SQL Anywhere] Table 'YYY not found.
Do you have any idea what could be wrong? I saw an old post regarding fm5 that you needed to set charset to iso_1 for sybase, I have tried that also without any result.
Thanks in advance,