[R-SIG-Mac] ODBC Error - Anyone have this working
knussear at mac.com
Tue Jul 15 22:17:25 CEST 2008
Got the solution figured out. Documenting here just in the case anyone
else encounters this. The Acutal Tech drivers recomennded by filemaker
on their website today include ivslk18.dylib as the client driver for
fmpro. The FMserver manual mentioned that it should be using
ivslk20.dylib. So I found a copy of the correct driver here http://fmdl.filemaker.com/drivers/9/xdbc_odbc_mac.dmg
updated the client driver and R is talking now.
On Jul 15, 2008, at 7:45 AM, Ken Nussear wrote:
> Can't find this error in the archives, hoping someone has solved
> this already.
> I'm trying to run ODBC queries to a filemaker database running on FM
> Server. I have the Actual drivers installed, and the query is
> working in Excel and able to import data.
> When I specify the query in R I get the following....
> > channel <- odbcConnect(dsn='Flapjack', uid = "Admin", pwd = "!^%
> There were 50 or more warnings (use warnings() to see the first 50)
> > warnings()
> 1: In odbcDriverConnect(st, ...) :
> [RODBC] ERROR: state 00000, code 0, message [iODBC][Driver
> ivslk18.dylib, 6): no suitable image found. Did find:
> /Library/ODBC/SequeLink.bundle/Contents/MacOS/ivslk18.dylib: mach-
> o, but wrong architecture
> 2: In odbcDriverConnect(st, ...) :
> [RODBC] ERROR: state IM003, code 0, message [iODBC][Driver
> Manager]Specified driver could not be loaded
> 3: In odbcDriverConnect(st, ...) :
> I get something there about the wrong architecture on warning 1, and
> the rest of the warnings are all the same.
> Does anyone know how to fix this?
More information about the R-SIG-Mac