Displaying 5 results from an estimated 5 matches for "42s02".
Did you mean:
4202
2007 Jul 17
4
[R-sig-DB] RODBC on Oracle DB
...S_TYP_COLLEGES TABLE <NA>
1320 <NA> ORESTE S_TYP_ENSEIGNEMENT TABLE <NA>
...
> sqlQuery(essai, "select * from S_TYP_COLLEGES")
[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "42S02 942 [Oracle][ODBC][Ora]ORA-00942: Table ou vue inexistante\n"
I have also tried the
essai2 <- odbcDriverConnect(connection="essai2")
But with no succes.
On Lun Juil 16 15:32 , Prof Brian Ripley <ripley at stats.ox.ac.uk> sent:
>The problem could be quoting, if Orac...
2013 Oct 14
1
realtime voicemail asterisk 11
...|
| help [tablename] |
| quit |
| |
+---------------------------------------+
[Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:645
ast_odbc_prepare_and_execute: SQL Execute returned an error -1: 42S02:
[MySQL][ODBC 5.2(w) Driver][mysqld-5.6.12]Table 'asterisk.voicemessages'
doesn't exist (86)
[Oct 14 10:06:16] WARNING[10037][C-00000003]: res_odbc.c:657
ast_odbc_prepare_and_execute: SQL Execute error -1! Verifying connection to
asterisk [asterisk]...
[Oct 14 10:06:16] WARNING[10037][C...
2007 May 24
1
"[RODBC] ERROR: Could not SQLExecDirect"
...Dir=C:\Program Files\R\R-2.5.0
Driver={Microsoft Excel Driver (*.xls)}
DriverId=790
MaxBufferSize=2048
PageTimeout=5
Z>sqlQuery(cnct, "select * from \"Forbes2000\\$\"")
However, I got error like this:
[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "42S02 -1305 [Microsoft][ODBC Excel Driver] Microsoft Jet Êý¾Ý¿âÒýÇæ
ÕÒ²»µ½¶ÔÏó'Forbes2000\\$'¡£ÇëÈ·¶¨¶ÔÏóÊÇ·ñ´æÔÚ£¬²¢ÕýÈ·µØд³öËüµÄÃû³ÆºÍ·
¾¶¡£"
I do can find Forbes2000.xls in directory, C:\Program Files\R\R-2.5.0.
Would anybody help me out?
Thanks for any suggestions!
________________...
2009 May 21
1
Error in importing table from SQL to R
...= TRUE)
NEWDATASQL3
[1] -1
NEWDATASQL4 <- sqlQuery(myconne, "select * from CampaignDataLarge", errors =
TRUE, colnames = FALSE, rownames = TRUE)
NEWDATASQL4
[1] "[RODBC] ERROR: Could not SQLExecDirect"
[2] "42S02 208 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object
name 'CampaignDataLarge'."
Regards,
Madan
--
View this message in context: http://www.nabble.com/Error-in-importing-table-from-SQL-to-R-tp23650489p23650489.html
Sent from the R help mailing list archive at Nabble.com.
2011 Jul 20
1
Problem with RODBC
...001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined."
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM [Data$]'"
> faults <- sqlFetch(channel, sqtable = 'Data$_',
+ colnames = FALSE, as.is = TRUE)
> faults
[1] "42S02 -1305 [Microsoft][ODBC Excel Driver] The Microsoft Jet
database engine could not find the object 'Data$_'. Make sure the
object exists and that you spell its name and the path name correctly."
[2] "[RODBC] ERROR: Could not SQLExecDirect 'SELECT * FROM [Data$_]'"
&...