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]]
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
