Skip to content

ODBC Error - Anyone have this working

2 messages · knussear

Original
knussear
# 
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
knussear
# 
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: