RODBC Error: 'getCharCE' must be called on a CHARSXP

I am trying to connect to an internal database and use the sqlQuery command to reduce and retrieve data using the following code:

channel<-odbcConnect("some_dsn", uid="", pwd="")
txt<-'SELECT Date, Region, Price FROM TableXYZ WHERE Type="Domestic"'
sqlQuery(channel, cat(txt,"\n"),errors=TRUE,)

close(channel)

However, I get the following error immediately after sqlQuery command:

Error in odbcQuery(channel, query, rows_at_time) :
   'getCharCE' must be called on a CHARSXP

I believe my connection is good because I used the following commands to successfully view the columns:

sqlColumns(channel, TableXYZ)

There doesn't seem to be much info on "getCharCE" and/or "CHARSXP.  Any guidance the group could provide this vey new user to R, would be greatly appreciated




	[[alternative HTML version deleted]]

I am trying to connect to an internal database and use the sqlQuery command to reduce and retrieve data using the following code:

channel<-odbcConnect("some_dsn", uid="", pwd="") txt<-'SELECT Date, 
Region, Price FROM TableXYZ WHERE Type="Domestic"'
sqlQuery(channel, cat(txt,"\n"),errors=TRUE,)

close(channel)

However, I get the following error immediately after sqlQuery command:

Error in odbcQuery(channel, query, rows_at_time) :
   'getCharCE' must be called on a CHARSXP

I believe my connection is good because I used the following commands to successfully view the columns:

sqlColumns(channel, TableXYZ)

There doesn't seem to be much info on "getCharCE" and/or "CHARSXP.  
Any guidance the group could provide this vey new user to R, would be 
greatly appreciated




	[[alternative HTML version deleted]]

Thanks.   But if I do as you suggested...

	txt<-'SELECT Date,  Region, Price FROM TableXYZ WHERE Type="Domestic"'

returns...

	"SELECT TradeDate, Hub, SettlementPrice FROM PowerSettlements WHERE Contract=\"ERN\""

Which because of the extra "\"' is improper SQL form.

Maybe I should be asking what is the proper way to return "" inside of a char string?

-----Original Message-----
From: Uwe Ligges [mailto:ligges at statistik.tu-dortmund.de]
Sent: Tuesday, December 20, 2011 8:46 AM
To: Mike Pfeiff
Cc: 'r-help at r-project.org'
Subject: Re: [R] RODBC Error: 'getCharCE' must be called on a CHARSXP



On 20.12.2011 14:55, Mike Pfeiff wrote:

I am trying to connect to an internal database and use the sqlQuery command to reduce and retrieve data using the following code:

channel<-odbcConnect("some_dsn", uid="", pwd="") txt<-'SELECT Date,
Region, Price FROM TableXYZ WHERE Type="Domestic"'
sqlQuery(channel, cat(txt,"\n"),errors=TRUE,)

sqlQuery(channel, txt, errors=TRUE)

seems more plausible (since cat returns NULL).

Uwe Ligges

close(channel)

However, I get the following error immediately after sqlQuery command:

Error in odbcQuery(channel, query, rows_at_time) :
    'getCharCE' must be called on a CHARSXP

I believe my connection is good because I used the following commands to successfully view the columns:

sqlColumns(channel, TableXYZ)

There doesn't seem to be much info on "getCharCE" and/or "CHARSXP.
Any guidance the group could provide this vey new user to R, would be
greatly appreciated




	[[alternative HTML version deleted]]