search for: temp_pass

Hi, I am trying to query a Sybase database on my new windows 7 machine. I am using native sybase driver "Adaptive server Enterprise" following is example code conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is) odbcClose(chan) I am able to connect to the database and get the data using above code. But when the data is more than couple of hundred lines (4 columns.. its not much), i get garbage data. I usually ge...

...d all, I am trying to connect to sybase from R with the RODBC package. I am using native sybase driver "Adaptive server Enterprise" and using the following example code. conn <- sprintf("driver=Adaptive server Enterprise;server=PHKSESMD01;database=smd_live;uid=temp_user;password=temp_pass;port=2301") chan <- odbcDriverConnect(conn) x <- sqlQuery(chan,sql,as.is=as.is) odbcClose(chan) However I am not able to connect to the database and I get the following error. 1: In odbcDriverConnect(conn) [RODBC] ERROR: state IM002, code 0, message [Microsoft][ODBC Driver Manager] Da...