Displaying 2 results from an estimated 2 matches for "42s01".
Did you mean:
4201
2011 Nov 10
1
Help: sqlSave Error
...ng table at MS SQL Server
database. Previously my code ran smoothly but all of a sudden it stopped
working. Here is my code:
sqlSave(con, highVol, "dbo.futuresHighVol", append=TRUE, rownames=FALSE)
Error: sqlSave(con, highVol, "jrgchis.dbo.futuresHighVol", append = TRUE, :
42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL Server]
'futuresHighVol' already exist
[RODBC] ERROR: Could not SQLExecDirect 'CREATE TABLE
jrgchis.dbo.futuresHighVol ("TradeTime" varchar(255), "vol" float)'
Please Help!!!
--
View this message in context: http:...
2009 Mar 01
1
Temporary tables with Microsoft SQL?
...ame) :
?#x?: table not found on channel
> sqlSave(channel, "#x", verbose=TRUE) #repeat
Query: CREATE TABLE "#x" ("rownames" varchar(255), "x" int)
Error in sqlSave(db_i3_eic, x, "#x", verbose = TRUE) :
[RODBC] ERROR: Could not SQLExecDirect
42S01 2714 [Microsoft][ODBC SQL Server Driver][SQL Server]There is
already an object named '#x' in the database.
> sqlSave(channel, "x", verbose=TRUE) # try without hash
Query: CREATE TABLE "x" ("rownames" varchar(255), "x" int)
Error in sqlSave(db_i3_...