Geek Answers Handbook

RODBC to connect to SQL Server on Mavericks

Can I use RODBC for OSX 10.9.2 Mavericks to connect to SQL Server (free)?

I want to:

    dB <- odbcConnect("dataBase",pwd="password",uid="userID")
    t <- sqlQuery(dB,"SELECT * FROM myTable")

but odbcConnect issues this warning again and again and never returns ...

    50: In odbcDriverConnect("DSN=dataBase;UID=userID;PWD=password") : [RODBC] ERROR: state IM002, code 1408279968, message [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded

Now, to be honest, I have not installed a DSN with iODBC with the correct DSN, because I do not have a free SQL Server driver.

The few people who report using RODBC to connect to SQL Server under OSX 10.9.2 Mavericks were a bit obscure. Without naming drivers, or noting that they compiled RODBC or iODBC manually.

Update: now on these issues: Installing RODBC on OS X Yosemite and also Installing RODBC / ROracle packages on OS X Mavericks

+1
1

, , , , () RODBC Mavericks.

, DSN. Actual Technologies ( ) . iODBC unixODBC .

RODBC, iODBC, Apple, -, .

iODBC, , /usr/include libiodbc.a /usr/lib. RODBC .

, Mavericks RODBC, RODBC.

0

More articles:


All Articles