search for: odbctableexists

...ion :) 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, sqtable) : object 'CampaignDataLarge' not found NEWDATASQL2 <- sqlFetch(myconne, CampaignDataLarge, colnames = FALSE, rownames = TRUE) Error in odbcTableExists(channel, sqtable) : object 'CampaignDataLarge' not found NEWDATASQL3 <- sqlFetchMore(myconne, CampaignD...

...N seems to be properly set up using the PostgreSQL Unicode ODBC driver, and sqlTables(chnl) works OK and produces a list of tables in the database (they are all in a schema called 'source'). But > seiz.df <- sqlFetch(chnl, 'source.MAIN') fails with the error message Error in odbcTableExists(channel, sqtable) : 'source.main': table not found on channel This occurs even though the table 'MAIN' is listed in schema 'source' in the output of sqlTables(chnl). I am using PostgreSQL version 9.0 and the database is installed on a local server (localhost) on a PC runn...

...t; sqlFetch(channel, "ABTGRNAMEN") [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S0002 942 [Oracle][ODBC][Ora]ORA-00942: table or view does not exist\n" > # I also tried: > sqlFetch(channel, "TKF.ABTGRNAMEN") Error in odbcTableExists(channel, sqtable) : TKF.ABTGRNAMEN : table not found on channel What am I doing wrong here? It doesn't work with other tables as well; on the other hand, connecting to the table(s) in MS Access works fine using the same ODBC driver. Best regards, Heinrich.

...pattern of my code, nothing spectacular: library(RODBC) channel2<-odbcDriverConnect('DSN=xxx') #table names with up to 11 characters still work sqlFetch(channel2, 'abcdefghijk') #table names with 13 or more characters do not sqlFetch(channel2, 'abcdefghijklm') Fehler in odbcTableExists(channel, sqtable) : ?abcdefghijklm?: table not found on channel I do not have any tables with 12 character names, to check where exactly the borderline is. Of course, the table ?abcdefghijklm? exist on the channel, even if I feed it directly t osqlFetch via sqlFetch(channel2, sqlTables(chann...

...a_With_CMPL_EXCL") This returns a dataframe of 24445 rows and two columns (as intended), but the following command testout <- sqlFetch(channel,"dbo.vwC1198_2006_RawData_With_CMPL_EXCL",colnames = TRUE,rownames = "idSchedule") returns the error message in odbcTableExists(channel, sqtable) : 'dbo.vwC1198_2006_RawData_With_CMPL_EXCL': table not found on channel The value of channel did not change between the two commands. Based on the help files for sqlFetch and sqlQuery, it is not clear to me why one command would find the table and the oth...

...quot;, sep="")) datafiles[[i]] <- as.matrix(sqlFetch(channel, "Data")) close(channel) } I'm not sure how to alter the code to allow for the fact that some files may not exist - these files should be ignored. Currently, I get the following error Error in odbcTableExists(channel, sqtable) : 'Data': table not found on channel - it however creates an empty file for the first occurance of a non-existing file then stops. I would very much apprepriate any help. Thanks in advance. Dave __________________________________ Get on-the-go sports s...

...sheet name Publication exists. The error is coming. Can anyone help? library("RODBC") cdb_cnct <- odbcConnectExcel("Copy of AZIF_DC_GVK_NSCLC_MSALL_287papers_02072012_141450_v1_4.xls") cdb_frame <- sqlFetch(cdb_cnct, "Publication") odbcClose(cdb_cnct) Error in odbcTableExists(channel, sqtable) : 'Publication': table not found on channel rm(cdb_cnct) ________________________________ Notice: The information contained in this electronic mail message is intended only for the use of the designated recipient. This message is privileged and confidential. and the pro...

Your error message was >> d <- sqlFetch(channel, District) > Error in odbcTableExists(channel, sqtable) : > object "District" not found and as you had not defined an object 'District' in that session, it seems perfectly plain. If you want to refer to table "District" you have to give a character string (with quotes), not the name of an R obj...

...row.names) sqlTables also returns back an empty table: > sqlTables(con) [1] TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS <0 rows> (or 0-length row.names) And sqlFetch doesn't work either: > sqlFetch(con, "PRICES.DB_PRICES") Error in odbcTableExists(channel, sqtable) : 'PRICES.DB_PRICES': table not found on channel Are their other options I should be using with RODBC to pull the data? I have tested the connection in MS Access and can successfully display data (using File->Get External Data...->ODBC->...) Any suggestions...

...l, at least no outright errors gets chunked out to the console. Now what? Here's where I get stuck. There is a table in the test.dbf file called TEST. But, the following tester <- sqlFetch(import_dat,"TEST") blows up - I get the following error message in the console: Error in odbcTableExists(import_dat, sqtable) : 'TEST': table not found on channel OK - so it doesn't seem to find the table TEST in test.dbf. I tried lower-case for TEST (i.e., test), but that doesn't seem to solve the problem. OK, so lets pretend I don't know what the table in test.dbf is...

...ABLE_TYPE REMARKS 1 C:\\USERS\\NUTTERB <NA> Core2012.txt TABLE <NA> 2 C:\\USERS\\NUTTERB <NA> MTGCards.csv TABLE <NA> > sqlFetch(mtg, "MTGCards.csv") Error in odbcTableExists(channel, sqtable) : 'MTGCards.csv': table not found on channel > MTGCards.csv is an export from an MS Access database, and I'm able to get it out of Access, and I'm also able to connect to our Oracle databases. So I'm not sure what it is I'm not getting about reading...

...library(RODBC) > channel <- odbcConnect("TLIAS01", uid="jeff.lindon") > channel RODB Connection 1 Details: case=nochange DSN=TLIAS01 UID=jeff.lindon Trusted_Connection=Yes WSID=TLIJLINDON DATABASE=tliresearch > d <- sqlFetch(channel, District) Error in odbcTableExists(channel, sqtable) : object "District" not found I have checked this problem with our CIO and he confirmed my Data Source configuration is correct (the connection test confirmed that R is able to connect to the database), and that the table really does exist and I have correct pe...

...an 10$' TABLE <NA> 5 <NA> 'Scan 11$' TABLE <NA> 6 <NA> 'Scan 12$' TABLE <NA> but the following does'nt work > data<-sqlFetch(channel,scanTables[1,"TABLE_NAME"],rownames=T) Error in odbcTableExists(channel, sqtable) : Scan1$ : table not found on channel whereas this works well: > data<-sqlFetch(channel,"Scan1",rownames=T) > data X-Coord Y-Coord C a C2 Si Mn P S Cr Cr1 1 1648 117896 298.9131 5.558300 4...

...odbcDriverConnect("DRIVER=Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb); DBQ=U:\\test folder\\fname[sp]; ReadOnly=False") sqlTables(channel) my.data <- sqlFetch(channel, "Sheet1") print(my.data) odbcClose(channel) } # The error I receive states: Error in odbcTableExists(channel, sqtable) : ?Sheet1?: table not found on channel # Thank you sincerely in advance for any help with this problem. Mark Miller Gainesville, Florida -- View this message in context: http://old.nabble.com/Reading-multiple-Excel-2007-files-with-a-loop-tp26414828p26414828.html Sent fro...

...top 1 * from > TestDB.[SILICON\\holouis1].clep_tier_shift") State NB Change_Number 1 IL 2005-02-08 7 It exists and I can get data from it, but if I try to use fetch or columns: > sqlFetch(channel, "TestDB.[SILICON\\holouis1].clep_tier_shift") Error in odbcTableExists(channel, sqtable) : 'TestDB.[SILICON\holouis1].clep_tier_shift': table not found on channel > sqlColumns(channel, "TestDB.[SILICON\\holouis1].clep_tier_shift") Error in sqlColumns(channel, "TestDB.[SILICON\\holouis1].clep_tier_shift") : 'TestDB....

...TABLE <NA> 2 'Success Rates$'Print_Area TABLE <NA> 3 'Success Rates$'Print_Titles TABLE <NA> ## The following give errors, although ## according to p.16 of manual, this should work: > dat<-sqlFetch(z,"Success Rates") Error in odbcTableExists(channel, sqtable) : Success Rates : table not found on channel ## This only seemed to work ... > dat<-sqlFetch(z,"'Success Rates$'") ## But > dat [1] "[RODBC] ERROR: Could not SQLExecDirect" [2] "37000 -1002 [Microsoft][ODBC Excel Driver] '&...

..."schema.table" syntax used in Postgresql (and Oracle) does not work directly with RODBC. This works library(RODBC) con<-odbcConnect("mydb") d<-sqlQuery(con,"select * from meso.trees") However this does not. d<-sqlFetch(con,"meso.trees") Error in odbcTableExists(channel, sqtable) : ?meso.trees?: table not found on channel Apparently the test if (!odbcValidChannel(channel)) is returning true. The inclusion of any non alphanumeric character leads a table name to be considered invalid. This also means that the useful sqlSave and sqlUpdate functions cannot...

Hi, i found tis message in the archive and have got the same problems ? John, perhaps you have found now a way install RPgSQL for windows2000, or anybody other ? many thanks for advance christian [SNIP] I wonder whether anyone has succeeded in building either the RPgSQL or the Rdbi.PGSQL and Rdbi packages for Windows. If so, would you be willing to share either the binary package(s) or