Some time ago this group gave me great help with connecting Realbasic to Filemaker with ODBC. Now, I'm doing a test of my application before releasing it and just can't get this to work again.
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. The iODBC framework is installed. The username/password combination has been checked. The internet says that I had this problem once before. As I remember I solved this by adding the username/password combination. But today it doesn't want to work.
Using Mac OS 10.5.8 on MacPro with Realbasic 2009R2.1 and Filemaker 8.5.
