similar to: Error results from MS Access via RODBC

What is this error message about and how do I troubleshoot it? > sqlTables(channel) 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 >

I am getting segfaults when I try to read a large binary object from a SQL Server database via RODBC. I am using the FreeTDS ODBC driver, and it has been working fine when reading from this same database. I have included relevant parts of the session below. Each row of the v_MAFiles view holds a text, html or pdf version of a document. The FileType entry is one of TXT, PDF, or HTML. If

Hi. I attempted to use RODBC and decided to execute all the tests provided in "Test.r" under the unpacked package RODBC folder. Beginning 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 <-

I am running R version 2.8.1 on Windows XP OS. This works fine. (Data.frame dta is created with records from the DB2 table.): sql <- "select * from storage.testappend_slt order by uut" dta <- sqlQuery(channel,sql) But when I try to append records (from data.frame newdta) to the same DB2 table. I get an error: sqlSave(channel, newdta, tablename = storage.testappend_slt, append

Morning everyone, I was hoping to use mdbtools to extract data from some Access databases overnight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest release from the mdbtools web site, but I either get 'buffer overflow' errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but

Hi again, I have played a little more with mdbtools and R. I downloaded the latest version of mdbtools from sourceforge (version 0.6pre1). Quickly scanning the mailing list suggests that ODBC seems to work with PHP but I have not been able to get it to work with R. I can make a connection to the database and when I do a query I get back the names of the rows but not the data. I must admit I have

I am trying to use some ms access databases in R (version 1.9.1 or 2.0 on a Debian system). In searching the net for promising software to do this, I found mdbtools. Mdbtools claims the ability to convert schemas and tables in MS Access to MySQL and other databases. http://mdbtools.sourceforge.net/ I'm wondering if anyone in the R community has tried using this software to use

I am on Ubuntu 11.4 with wine 1.3 This is an application that provides information from a small database and appears to ues: Jet4 Dao Several OCX tiles VB Runtime 6 I can share its install log if a cut and paste of such a think would be useful. It appears to happily install but when it goes to run I get the dialog box that says it encountered a "serious problem" and needs to close.

I have been struggling for the past several weeks with a corruption problem using an application that uses Access Databases on a Samba 2.0.7 share. The clients are all Win2k SP1 and the network is 'healthy'. I've turned off oplocks on both client and server, I've disabled the caching on the Win2k boxes per the Samba documentation and the one note posted on the download sites

Hi all, i use the PGSQL App, and i have found out, if you use a "(" or a ")" in your query the query crashes... My sample query was : SELECT count(*) from tbltest where fldtest='xxx' can somebody fix this ...?? Regards, Thomas. ******************************************* beroNet technologies GmbH Dipl.- Ing. Thomas H?ger Potsdamer Str. 18 A 14513 Teltow FON:

essai <- odbcConnect("ORESTE_prod", uid="osis_r", pwd="12miss15" ,case="oracle") > sqlTables(essai)$ORESTE ... 1315 <NA> ORESTE S_PROFESSIONS_OLD TABLE <NA> 1316 <NA> ORESTE S_PROVENANCES TABLE <NA> 1317 <NA> ORESTE

I have a problem with one application that using UDL file as a source to database. I have installed MDAC2.8 jet4, and changed DLL-s odbc32, odbccp32, oledb32 to native version. In odbcad32.exe I have created data source with the same configuration like in udl file and it's working. How to open UDL file for edition in wine (no text file edition)? Some ideas why it is not working?

I have a microsoft database that I have read in that is a list of dataframes processed by mdb.get. I am trying to read this into GRASS gis and need to change the labled atomic vectors to double precision- especially the coord.x coord.y. Now is there a way to check for classes and then change them inside of a for loop. This is the code I am using at the moment. library(Hmisc) # Read all tables

Buen dia Javier, muchas gracias por tu ayuda y el script compartido. Me va a servir como ayuda para seguir aprendiendo sobre RODBC pero no encuentro una solucion para este problema puntual de poder definir el tipo y ancho de las variables, q segun creo se hace con el argumento varTypes. Si alguien tien algun ejemplo donde haya usado la SqlSave y VarTypes, me sera de gran ayuda. Abrazo a todos

Hola Javier, si no estoy entendiendo mal, lo q deseo hacer no se trata de configurar los parametros SQL, sino solo de colocar un vector en el argumento VarTypes de la funcion sqlSave. El manual especifica esa opcion, pero no da ningun ejemplo de como usarla. *varTypes an optional named character vector giving the DBMSs datatypes to be used for* *some (or all) of the columns if a table is to be

Hi Andres, Ok -- I've added some API for this in 438db0719681: You can get the string pool from the execution session with LLVMOrcExecutionSessionGetSymbolStringPool, then clear that with LLVMOrcSymbolStringPoolClearDeadEntries. -- Lang. On Thu, Oct 1, 2020 at 5:34 PM Lang Hames <lhames at gmail.com> wrote: > Hi Andres, > > Oooh. I think I see. For various reasons the symbol

Hi, On 2020-10-01 15:29:12 -0700, Lang Hames wrote: > 24bytes / object -- Looks like I managed module ownership correctly but > leaked the ThreadSafeModule container. This should be fixed in 5044196b412f. That helped a bit, but not yet fully. Looks like it might be still reachable memory, so leakcheck isn't that helpful. Oooh. I think I see. For various reasons the symbol names we

Hi, Is there is anyway to Open Microsoft .mdb files in open office on Centos 5.3 ? Thanks linux

I have a geodatabase and would like to import it into GRASS, but it is in .mbf. I use mac and linux, and don't have access to access on the machines that I normally use. I do have access to access at school, but I would like to find a way around this if possible. Any thoughts, comments, or suggestions would be welcome. thanks, -- Stephen Sefick Let's not spend our time and resources

@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business. Does anyone have experience doing so? I have used odbtp in the recent past but it is extremely difficult to set up on the linux box as I learned when I recently upgraded from CentOS 4.x to 5.x. Is there another way to get