search for: odbcgetinfo

...Oracle is not standards-compliant. >See the options in ?odbcConnect. > >If sqlQuery(essai, "select * from S_TYP_COLLEGES") works, this is likely >to be the problem. > >On Mon, 16 Jul 2007, eric at net2000.ch wrote: > >> >> >>> essai >>> odbcGetInfo(essai) >> DBMS_Name DBMS_Ver Driver_ODBC_Ver >> "Oracle" "09.00.0121" "03.51" >> Data_Source_Name Driver_Name Driver_Ver >> "ORESTE_prod" "SQORA32.DLL" "09.00.0101&q...

...RODBC connection is open? Since odbcValidChannel is not exported from namespace RODBC, I suppose I shouldn't be using it. This is the best I could come up with, but it seems a bit 'dirty' to be using a tryCatch for something like this: odbcOpenp <- function(conn) tryCatch({odbcGetInfo(conn);TRUE},error=function(...)FALSE) Suggestions? -s [[alternative HTML version deleted]]

...ing with the following: library(RODBC) library(MASS) USArrests[1,2] <- NA hills <- hills[1:15,] row.names(hills)[12] <- "Dollar ('$')" set.seed(1) # MySQL ## testdb3 is ODBC/Connector 3.51.x, testdb5 is 5.1.x channel <- odbcConnect("MysqlODBC")  #my database odbcGetInfo(channel) sqlTypeInfo(channel) sqlTables(channel) sqlDrop(channel, "test.USArrests",errors = FALSE)  #explicit database AND table call as MySQL doesn't allow general table creation  Everything works as advertised. ---------------------------------------------------------------------...

Hello, Does anyone know a way to connect from R on Linux box to TeraData server? I can use ODBC connection on Windows box, but with amount of data I need (and prefer) to use large Linux box. Thanks, Vadim

Hello I am trying to move data between R and other systems (e.g. SAS and MS SQL Server) using RODBC. I think I have the most recent version of RODBC (0.9) and here is some other system info: > odbcGetInfo(channel) [1] "Microsoft SQL Server version 08.00.0679. Driver ODBC version 03.52" > version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status major 1 minor 6.1 year 2002 month 11 day 01 language R > I appear to be ha...

...und similar problems have been encountered with Oracle and postgresSQL. http://www.mail-archive.com/r-help@r-project.org/msg19386.html The approach in the above link looked promising, but I don't know how to set the search path for DB2... Additional information, possibly helpful? > odbcGetInfo(channel), DBMS_Name DBMS_Ver Driver_ODBC_Ver Data_Source_Name Driver_Name Driver_Ver ODBC_Ver "DB2/AIX64" "08.02.0005" "03.51" "QUALITY8" "DB2CLI.DLL" "08.02.0006&q...

...of the session or when there is no R object referring to them. * There is no longer a restriction to 16 channels. * Add NAMESPACE. * odbcConnect{Access,Dbase,Excel} allow a missing file name (and will bring up a dialog box to search for it). * odbcGetInfo returns more information in a 8-element character vector (based on an idea of Matthew Dowle). * The C code calls SQLExecuteDirect rather than SQLExecute and does not call SQLCloseCursor, based on a problem report from Matthew Dowle using MS SQLServer. Repeate...

...0 70 71 ... 63 > # [89 rows deleted] > # 90 57 56 52 ... 37 > frame1 <- sqlQuery(channel, "select * from [Sheet1$]") > frame1 [1] "[RODBC] ERROR: Could not SQLExecute" [2] "S1001 -1040 [Microsoft][ODBC Excel Driver] Too many fields defined." > odbcGetInfo(channel) [1] "EXCEL version 08.00.0000. Driver ODBC version 03.51" > version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386, mingw32 status major 1 minor 6.1 year 2002 month 11 day 01 language R

...Its main use is with max set to non zero it will retrieve the result set in batches with repeated calls." Have I mis-understood? Is this a driver problem? Something else? Any help/advice much appreciated. Many thanks in advance, Matthew > channel = odbcConnect("MY DSN") > odbcGetInfo(channel) [1] "Microsoft SQL Server version 08.00.0760. Driver ODBC version 03.52" > odbcQuery(channel, "select * from TEST") # Table TEST contains a single column by 100 rows [1] 1 > sqlGetResults(channel, max=10) last_update 1 2004-02-06 2 2004-02-06 3 2004-02-06...

...of the session or when there is no R object referring to them. * There is no longer a restriction to 16 channels. * Add NAMESPACE. * odbcConnect{Access,Dbase,Excel} allow a missing file name (and will bring up a dialog box to search for it). * odbcGetInfo returns more information in a 8-element character vector (based on an idea of Matthew Dowle). * The C code calls SQLExecuteDirect rather than SQLExecute and does not call SQLCloseCursor, based on a problem report from Matthew Dowle using MS SQLServer. Repeate...

...nel) Error in .Call("RODBCFetchRows", attr(channel, "handle_ptr"), max, buffsize, : negative length vectors are not allowed The channel was created as such channel <- odbcConnect("Labdata") I think this is telling me that my odbcConnect command worked > odbcGetInfo(channel) DBMS_Name DBMS_Ver "Adaptive Server Anywhere" "09.00.0002" Driver_ODBC_Ver Data_Source_Name "03.52" "Labdata" Driver_Name...

...only excel supports multisheets. Best, Stefan Example code: system(paste('ssconvert "excelcohortdata_men_reference scenario.xml" "excelcohortdata_men_reference scenario22.xls"')) channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls") odbcGetInfo(channel1) sqlTables(channel1) sqlQuery(channel1, "select * from \"age 9in 2010$\"" ) sqlFetch(chanel1, "age 9in 2010""

...------ ~# dpkg -l libmdb* mdbtools ii libmdbodbc 0.5.99.0.6pre1.0.20 MDB tools ODBC module ii libmdbtools 0.5.99.0.6pre1.0.20 mdbtools libraries ii mdbtools 0.5.99.0.6pre1.0.20 JET / MS Access database (MDB) tools -------------------------- ~# mdb-ver db.mdb JET4 -------------------------- R> odbcGetInfo(channel) DBMS_Name "" DBMS_Ver "" Driver_ODBC_Ver "" Data_Source_Name "test" Driver_Name "test" Driver_Ver "test" ODBC_Ver "03.52" Server_Name "03.52" -------------------------- R> version platform: i486-pc...

Hello, We are having some strange issues with RODBC related to integer columns. Whenever we do a sql query the data in a integer column is 150 actual data points then 150 0's then 150 actual data points then 150 0's. However, our database actually has numbers where the 0's are filled in. Furthermore, other datatypes do not have this problem: double and varchar are correct and do not

Hi, I'm able to establish a successful odbc connection using RODBC 1.3-2 on Win 7 and R 2.12.0. But I'm getting the following error message when I try to save a data frame into the debase as shown below. library(RODBC) bbdb <- odbcConnect("bbdb") odbcGetInfo(bbdb) # returns ok sqlSave(bbdb, USArrests, rownames = "state", addPK=TRUE) # example from the RODBC manual Error in sqlSave(bbdb, USArrests, rownames = "state", addPK = TRUE) : [RODBC] ERROR: Could not SQLExecDirect 'CREATE TABLE "USArrests" ("state&quot...

...**** ********* `RODM_open_dbms_connection` <- function( # # Open an ODBC connection to the Oracle Database # dsn, uid = "", pwd = "") { library(RODBC) channel <- odbcConnect(dsn = dsn, uid = uid, pwd = pwd, case = "toupper", rows_at_time=1) driver <- odbcGetInfo(channel)[[1]] setSqlTypeInfo(driver, list(double="double precision", integer="integer", character="varchar(255)", logical="varchar(255)")) ********* ********* I am confused why would there be locked binding here. Sorry , if I didn't post my question a...

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

...s grDevices utils datasets methods base other attached packages: [1] mra_1.0 frb_3.9 fame_2.19 tis_1.23 RODBC_1.3-6 [6] RObjectTables_0.3-1 loaded via a namespace (and not attached): [1] data.table_1.8.2 XML_3.9-4 > conn <- h41Connect(devl = T) > odbcGetInfo(conn) DBMS_Name DBMS_Ver Driver_ODBC_Ver Data_Source_Name Driver_Name "Microsoft SQL Server" "10.50.4000" "03.50" "h41_devl" "libtdsodbc.so" Driver_Ver...

Hello!!! I have been read a much about as read data from Excel File, but I haven?t found the necesary information to read the data. Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I don?t know as read the data?? I hope that you could help me. Thank you very much. -- View this message in context:

...only excel supports multisheets. Best, Stefan Example code: system(paste('ssconvert "excelcohortdata_men_reference scenario.xml" "excelcohortdata_men_reference scenario22.xls"')) channel1<-odbcConnectExcel("excelcohortdata_men_reference scenario10.xls") odbcGetInfo(channel1) sqlTables(channel1) sqlQuery(channel1, "select * from \"age 9in 2010$\"" ) sqlFetch(chanel1, "age 9in 2010"" ------------------------------ Message: 45 Date: Tue, 4 May 2010 23:58:44 +0900 From: Luis N <globophobe at gmail.com> To: r-help at r-...