I am trying to connect sybase sql databast from R using RODBC pkg and
getting the following error ( i chnaged names to my***  but when I actually
execute it, I put down names explicitly not calling some character strings)

> channel = odbcConnect(dsn='mydsn',uid='myid',pwd='mypasswd')
Warning messages:
1: [RODBC] ERROR: state IM002, code 0, message [iODBC][Driver Manager]Data
source name not found and no default driver specified. Driver could not be
loaded
2: ODBC connection failed in: odbcDriverConnect(st, case = case,
believeNRows = believeNRows)
> channel =
odbcDriverConnect('SERVER=mydsn;DATABASE=my_subdb;UID=myid;PWD=mypasswd')
Warning messages:
1: [RODBC] ERROR: state IM007, code 5768012, message [iODBC][Driver
Manager]No data source or driver specified, dialog prohibited
2: ODBC connection failed in:
odbcDriverConnect("SERVER=mydsn;DATABASE=my_subdb;UID=myid;PWD=mypasswd")

I can see the connection by ping the server in a xterm:

 ~ > ping mydsn
mydsn is alive

Can you give me an advice how to create the channel object correctly? Thanks
so much!

Young

	[[alternative HTML version deleted]]

