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

[gui zhenghui]

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]]