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

    Trouble with ODBC connection to Filemaker

    beatrixwillius

      Title

      Trouble with ODBC connection to Filemaker

      Post

      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=127.0.0.1;PRT=2399;UID=test;PWD=test;IANAAppCodePage=106"
          theODBC = new ODBCDatabase
          theODBC.DataSource = theDataSource
          
          if not theODBC.Connect then
            etc.

      theDataSource has the value of

      Driver=/Users/beatrixwillius/Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk18.dylib;SDSN=eMailViewerX;HST=127.0.0.1;PRT=2399;UID=Admin;PWD=test;IANAAppCodePage=106

      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.
       
      Regards
       
      Beatrix Willius