similar to: RODBC

I'm tryuing to get the RODBC package to work with a MS Sql database (Wonderware's InSQL). I'm able to connect to the database using the following: version _ platform i386-pc-mingw32 arch x86 os Win32 system x86, Win32 status Under development (unstable)

Calling function "sqlFetch" in library(RODBC) and specifying a character string as 2nd argument, I get an error I don't understand: library(RODBC) channel <- odbcConnect("mydatabase.mdb", case="msaccess") sqlFetch(channel, "mytable") # this works fine tabname <- "mytable"; sqlFetch(channel, tabname) # this gives an error: # Error in

I'm having a small problem using RODBC. I'm trying to retrieve a string from a very long memo field (512*20*9=9360 characters = 74880 bytes) in an MSAccess database. It appears that RODBC set a maximum buffer size for a single column of 65535 bytes. ########## cut from RODBC.c ########## } else { /* transfer as character */ int datalen = thisHandle->ColData[i].ColSize; if

I'm using Wine 0.9.11~winehq1-1 on Debian Sid. I've been trying to install IE6 and MS Office 2000 for the last few days. As a side note, the only way I managed to install IE6 was through Sidenet. No luck with any other method (reg files, winetools...) Office 2000 installs, but when I try to run the program it says: warn:module:load_dll Failed to load module

Wine seems to be trying to run MS programs. 'wine /windows/Programs/access/office/msaccess.exe' starts 'access'. Then a error message says, FIXME:pthread_rwlock_rdlock FIXME:pthread_rwlock_unlock FIXME:pthread_rwlock_rdlock FIXME:pthread_rwlock_unlock FIXME:pthread_rwlock_rdlock FIXME:pthread_rwlock_unlock FIXME:pthread_rwlock_rdlock FIXME:pthread_rwlock_unlock

This is a MS Access problem I dont see in other posts. I have wine up and running and I now have it working with one other app, a spice cad program called scad3.exe. When I run it via wine I do get error messages, but since the program comes up and works fine any way I have been ignoring those errors. But I will list them here anyway, in case some expert can tell if they are relevant to my

Dear all, I'm trying to connect to an MSAccess database (ArcGIS personal geodatabase). I keep getting an error about the channel when using sqlQuery(). However, sqlTables() does not complain about the channel and lists all tables in the database. If I try sqlFetch(), then R crashes. I'm happy to hear suggestions on how to solve this. Best regards, Thierry > MDB <-

Hello! I am trying to run another Latvian accounting software Tildes Jumis. Free demo is available at http://tilde.lv/portal/go/tilde/3389/en-US/DesktopDefault.aspx It requires MS MSACCESS to run. I am running latest Wine (wine-1.2-rc2), installed RICHTX32.OCX, comctl32.dll,urlmon.dll using winetricks. Operating system:ubuntu 10.04 Program installs fine, but then I run it (using shortcut env

This is really strange. The samba server in question is a domain member server on a Windows NT 4.0 Domain network. It runs Gentoo 2004.3 with a 2.4.24 kernel. The Gentoo server was upgraded from Samba 3.0.5 to 3.0.8 last night. After the upgrade, the server had to be re-joined to the domain. After that, everything appeared to be working. This morning we found that the MSAccess database files

Hi, I've got a MSAccess database on a linux server (fedora core 5, samba 3, 192.168.0.90) which a Win XP client machine needs to use (192.168.0.50). However, Access refuses to open the database because "it's not on the LAN so is a security risk". How can I configure Samba so that Windows recognises 192.168.0.90 as a local machine, please? Jim Donovan Office +61+2-8923-5208

Hi all, I don't have any MSAccess on my machines, so I can't test it, and I would like to backup or invalidate that claim: if i have an MS Access database open by several people on a windows share (say on a w2k machine), will it be a problem backing it up on a linux backup server mounting the windows share (while it is still open and written to by the windows machines of course)?

I have problems import ms access 2000 data into Word 2000. The error is: DDE connection failed. Browsing the internet I found out that ms access uses ODBC for this (am I correct?). I have installed MDAC_TYP.EXE like in the Winehq documentation. I think that the msaccess driver doesn't work o.k. To reproduce: Run wine c:\windows\system\ODBCAD32.EXE --> in

Hi all, I'm having trouble getting Access 97 working with Wine 20041019. Word and Excel work just fine, as far as I've used them, but Access simply refuses to start. I've installed off an original installer CD through the WineTools ( 2.11jo) utility. I customised the install, removing everything except for the basic application files for Word, Excel and Access. I've also

Ok, I've tried all the "common" fixes, such as turning oplocks off on the share. Twice a day the database has to be repaired. running samba-3.0.7-2.FC2 Here's the pertinent section: comment = Aeries path = /home/aeries valid users = @aeries read only = No create mask = 0770 directory mask = 0770 inherit permissions = Yes

I have a msaccess program that is hard linked to a windows computer on the network (and I am not allowed to change the source :-( ) In some parts it seeks its files in \\computer1\c\Program Files\Program I have mounted computer1 using samba to ~/computer1 (with full read/write access) I have made a symbolic link in ~/.wine/dosdevices/unc according the winehq documentation. But I can't

Ok, Installed Ubuntu 8.10 clean, installed Wine, installed Office 2000 clean. What I need to do is open a database form in MSAccess on a server across the network. Access opens clean under XP, I click open, then click on my network button and get this error message: The file name, location, or format '::{208d2c60-3aea-1069-a2d7-08002b30309d}' is not valid. Type the file name in the

Corect me if this is not the right place to post this. I have a mdbdriver.jar (to access an MSAccess file) under Linux. I bought the license from http://www.csv-jdbc.com/ guys. The driver work fine when tested with DBVisualizer or another JDBC thing. The problem is that driver needs 3 other more jar files to work. Under R I have tried this and does not work: > library(RJDBC) Loading required

Basic tar question: I have created a ar file with tar -prvf /tmp/ib_backup.tar /opt/interbase/data/* The file has been copied to another box and I want to untar the file into /opt/interbase/data/ I am not sure about the syntax; how to specify where I want the data to be placed. Here is my start of the command: tar -xvf /tmp/ib_backup.tar #The tar file is in /tmp Todd --

Dear R-community, After repeating the sqlSave-command 3 times on a dataframe (of size 13149 rows * 5 columns) to my MS-Access database I get the following error: *Error in sqlSave(channel, eksport_transp_acc_2, "transp_acc_scenarier", : unable to append to table ‘transp_acc_scenarier’* ** This means that the first 2 savings are completed, but the third-one is somehow not. I have an

Anyone else notice that changeset 5980[1] hosed several of the db adapters? Specifically: activerecord/lib/active_record/connection_adapters/frontbase_adapter.rb activerecord/lib/active_record/connection_adapters/mysql_adapter.rb activerecord/lib/active_record/connection_adapters/openbase_adapter.rb activerecord/lib/active_record/connection_adapters/oracle_adapter.rb Someone has already filed