search for: myconn

Hi Friends, I am trying to import a table from SQL server to R(2.9.0), however i am getting errors while running the below codes. Can anyone identify and let me know where did i go wrong??? Thanks in anticipation :) library(RODBC) myconn <- odbcConnect("RDATABASE") myconn RODB Connection 6 Details: case=nochange DSN=RDATABASE Description=Database for R UID=Madana_Babu WSID=IBLPN1B049040 Trusted_Connection=Yes NEWDATASQL1 <- sqlFetch(myconne, CampaignDataLarge) Error in odbcTableExists(channel, sqtab...

Is this warning given on purpose? > myconn<-textConnection("print(11*11)") > source(myconn) [1] 121 Warning message: In source(myconn) : argument 'encoding = "native.enc"' will be ignored Could it be omitted, since the docs state that encoding is only use if the corresponding argument is a file name or ur...

Hi all, I'm using RODBC library to connect to a database. I'm trying to read a table from a database and after manipulating it would like to write to the same database but with a different table P<-data.frame(sqlQuery(myconn,'select? *? from Demographics')) sqlSave(myconn,p,tablename="trial",rownames=FALSE) I'm gettng this error Version:1.0 StartHTML:0000000107 EndHTML:0000001014 StartFragment:0000000127 EndFragment:0000000996 Error in sqlSave(myconn, p, tablename = "trial", r...

...nted=0 order by filename,cat_metric desc,var_metric asc,category,var_name,var_val,id" | isql Asterisk <lot of output from table> SQLRowCount returns 39 39 rows fetched So the odbc thingy works! root@pbx:# cat res_config_odbc.conf [settings] table = ast_config connection = myconn root@pbx:# cat res_odbc.conf [myconn] dsn=Asterisk username=XXXXX password=XXXXX preconnect=yes root@pbx:# cat extconfig.conf [settings] agents.conf => odbc enum.conf => odbc extensions.conf => odbc iax.conf => odbc iaxprov.conf => odbc queues.conf => odbc sip.conf =>...

...ng RODBC with the commands odbcConnect and sqlFetch. There are different data files in the database and in some cases it works without any difficulties. Nevertheless I get an error with some data files. Since I'm not familiar with MySQL I hope to get some ideas here. My code looks as follows: myconn <-odbcConnect("database", uid="user", pwd="password") data1<- sqlFetch(myconn, 'data1') data2 <- sqlFetch(myconn, 'data2') close(myconn) It works fine for data1 but for data2 I get the following error: Error in as.POSIXlt.character(x, tz, ......

...; undeclared (first use in this function) app_meetme2.c:140: `PGresult' undeclared (first use in this function) app_meetme2.c:140: `res' undeclared (first use in this function) app_meetme2.c:142: `MYSQL' undeclared (first use in this function) app_meetme2.c:142: parse error before "myconn" app_meetme2.c:143: `MYSQL_RES' undeclared (first use in this function) app_meetme2.c:143: `result' undeclared (first use in this function) app_meetme2.c:144: `MYSQL_ROW' undeclared (first use in this function) app_meetme2.c:144: parse error before "row" app_meetme2.c:145...

...table, and query it. Despite sqlSave succeeding without error, sqlQuery tells me the table doesn't exist. Also, when I query the database outside of R, I see that the table doesn't exist. However, using sqlFetch works, and (perhaps, as expected) the table is dropped upon evaluating close(myConn). Also, sqlDrop works as expected. Thanks for your time. Any thoughts are appreciated. Dave Mitchell [[alternative HTML version deleted]]

...e, and query it. Despite sqlSave succeeding without error, sqlQuery tells me that the table doesn't exist. Also, when I query the database outside of R, I see that the table doesn't exist. However, using sqlFetch works, and (perhaps, as expected) the table is dropped upon evaluating close(myConn). Also, sqlDrop works as expected. Thanks for your time. Any thoughts are appreciated. Dave Mitchell [[alternative HTML version deleted]]