AnsweredAssumed Answered

Trouble with ODBC connection to Filemaker

Question asked by beatrixwillius on Oct 22, 2009
Latest reply on Nov 28, 2009 by 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 

Outcomes