Displaying 7 results from an estimated 7 matches similar to: "Error in importing table from SQL to R"
2018 Jan 24
1
Help with SQLsave
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
2009 Oct 19
1
source and textConnection
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 url?
--
Erich Neuwirth, University of Vienna
2013 Nov 25
0
Fetching data from MySQL via odbcConnect - Error in as.POSIXlt.character(x, tz, ...) :
Hi!
I am trying to retrieve data from a MySQL Database using 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
2004 Jun 08
1
Meetme2
Hi!!
I try to install meetme2....i follow instructions that i found in
http://www.areski.net/asterisk-meetme/about.php?s=0
but, when i modify the "Asterisk/apps/Makefile" and i run the "make" command,
I have this type of error:
[root@obelix apps]# make
cc -pipe -fPIC -DUSEMYSQLVM -c -o app_meetme2.o app_meetme2.c
app_meetme2.c:31:22: libpq-fe.h: No such file or directory
2004 Dec 31
1
Help With Configuration From Odbc
Hi. I can't figure this one out. Hope someone can help me.
root@pbx:# cat /etc/odbc.ini
[Asterisk]
Description=PostgreSQL asterisk
Driver=PostgreSQL
Trace=No
TraceFile=/tmp/odbc.log
Database=asterisk
ServerName=localhost
UserName=XXXX
Password=XXXX
Port=5432
Protocol=7.4
ReadOnly=No
RowVersioning=No
ShowSystemTables=Yes
ShowOidColumn=Yes
FakeOidIndex=Yes
ConnSettings=
2013 Apr 03
1
sqlSave writes, but only for sqlFetch
I've been having some issues with sqlSave, and I think I've found an clue
that may identify the problem. In the code at
http://pastebin.com/vTAKt4bL<http://pastebin.com/W6UGKep9>,
I connect to a Netezza instance, make a simple 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
2013 Apr 02
0
sqlFetch works but sqlQuery doesn't
I've been having some issues with sqlSave, and I think I've found an clue
that may identify the problem. In the code at http://pastebin.com/W6UGKep9,
I connect to a Netezza instance, make a simple table, 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