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=127.0.0.1;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.