AnsweredAssumed Answered

ODBC Import Problem-From Sybase SQL Anywhere to FMPro

Question asked by SimonGranit on Oct 14, 2012
Latest reply on Oct 15, 2012 by Sorbsbuster

Title

ODBC Import Problem-From Sybase SQL Anywhere to FMPro

Post

     Hello!

     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,

     Simon

Outcomes