8 Replies Latest reply on Nov 28, 2009 5:56 AM by beatrixwillius

    Trouble with ODBC connection to Filemaker



      Trouble with ODBC connection to Filemaker


      I'm trying to connect from Realbasic to Filemaker with ODBC. Some time ago I had this working on PPC, but I can't get it to work on Intel.

      The code is as follows:

          dim theDataSource as String = "Driver=" + DriverPath + ";SDSN=" + theArchiveFolderitem.NameWoExtension + ";HST=;PRT=2399;UID=test;PWD=test;IANAAppCodePage=106"
          theODBC = new ODBCDatabase
          theODBC.DataSource = theDataSource
          if not theODBC.Connect then

      theDataSource has the value of


      The error message is: Cannot open message resource.

      The Sequelink file is installed. There is no DNS as this should work DNSless. Sharing on the Filemaker side is on with the extra privileges set correctly. The iODBC framework is installed. The username/password combination has been checked. When using the latest SequeLink version I get another error message: TCP/IP error, connection refused.
      Am I doing something wrong or do I need to use another version of Filemaker? 

      Using Mac OS 10.5.8 on MacPro with Realbasic 2009R2.1 and Filemaker 8.5.
      Beatrix Willius