[R-sig-DB] help - can't connect to sqlserver with odbc. unixODBC is ok

[gui zhenghui]

O, the error message was :

Warning messages:
1: In odbcDriverConnect("DSN=ocean;UID=sa;PWD=passwd") :
  [RODBC] ERROR: state IM004, code 0, message [unixODBC][Driver
Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed
2: In odbcDriverConnect("DSN=ocean;UID=sa;PWD=passwd") :
  ODBC connection failed

2010/3/5 gui zhenghui <zhgui.pku using gmail.com>

> hi, all:
>
>     I installed freetds and unixODBC, and with unixODBC/bin/isql,  i can
> retrieve data from the sqlserver
>     however, I can't use RODBC, and i got an error message :
>
>    1: In odbcDriverConnect("DSN=ocean;UID=sa;PWD=passwd") :
>   [RODBC] ERROR: state IM002, code 0, message [unixODBC][Driver
> Manager]Data source name not found, and no default driver specified
>
>   2: In odbcDriverConnect("DSN=ocean;UID=sa;PWD=passwd") :
>   ODBC connection failed
>
> Could any one help ?  Thanks~
>
>
>

	[[alternative HTML version deleted]]