[R-SIG-Mac] ODBC Error - Anyone have this working

[Ken Nussear]

All
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.


Ken


On Jul 15, 2008, at 7:45 AM, Ken Nussear wrote:

> Hi
>
> 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 = "!^% 
> $#jjs")
>
> 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  
> Manager]dlopen(/Library/ODBC/SequeLink.bundle/Contents/MacOS/ 
> 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?
>
> Thanks
>
> Ken
>
>