5 Replies Latest reply on Oct 15, 2012 12:37 AM by Sorbsbuster

    ODBC Import Problem-From Sybase SQL Anywhere to FMPro

    SimonGranit

      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