Statalist


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

st: ODBC Access Problems in Stata 10 (Mac OS X)


From   Moonhawk Kim <Moonhawk.Kim@Colorado.EDU>
To   statalist@hsphsun2.harvard.edu
Subject   st: ODBC Access Problems in Stata 10 (Mac OS X)
Date   Fri, 3 Jul 2009 13:13:00 -0600

I have set up a FileMaker Pro 10 database as an ODBC source on my  
machine (Mac OS X 10.5.7). Issuing the command in Terminal.app  
confirms that the FileMaker ODBC driver and the database are  
configured correctly,

iodbctest "dsn=FMMain;uid=Admin;pwd=*****"

as that results in the SQL prompt ("SQL>") being displayed and my  
ability to run SQL queries. However, in Stata, issuing "odbc list"  
shows an empty list of Data Source Names, and issuing "odbc query  
"FMMain", username(Admin) password(*****)" results in the following  
error messages:

[iODBC][Driver Manager]Specified driver could not be loaded,  
SQLSTATE=IM003
[iODBC][Driver Manager]dlopen(/Library/ODBC/SequeLink.bundle/Contents/ 
MacOS/ivslk20.dylib, 6): no suitable image found.  Did find:
                 /Library/ODBC/SequeLink.bundle/Contents/MacOS/ 
ivslk20.dylib: no matching architecture in universal wrapper,  
SQLSTATE=00000

Does anyone know how to address this problem?

Thanks!
Moonhawk

Moonhawk Kim - Assistant Professor
Department of Political Science - University of Colorado at Boulder
http://spot.colorado.edu/~moonhawk | moonhawk.kim@colorado.edu |  
303-492-8601

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/statalist/faq
*   http://www.ats.ucla.edu/stat/stata/



© Copyright 1996–2014 StataCorp LP   |   Terms of use   |   Privacy   |   Contact us   |   What's new   |   Site index