Re: [R] RODBC - problems using odbcDriverConnect without DSN

As this message is from your (unstated but probably unixODBC) ODBC driver manager, it is nothing to do with RODBC nor R. Most likely the syntax is wrong. As for 'without a DSN needing to be set on every computer that runs it', you need the driver and driver manager installed on every such

[R] RODBC - problems using odbcDriverConnect without DSN

Hi, I'm trying to use RODBC without having to set up a DSN, using hte direct connection string in odbcDriverConnect. My connection attempt looks something like: odbcDriverConnect(connection = SERVER=localhost;DRIVER={/usr/lib/odbc/libmyodbc.so};DATABASE=myDB;UID=reader;PASSWORD=insecure;)