Displaying 20 results from an estimated 2000 matches similar to: "RODBC"
2001 Nov 13
1
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)
2002 Aug 28
1
RODBC: sqlFetch and its argument sqtable
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
2005 Nov 16
1
RODBC and Very long field lengths
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
2006 Apr 14
3
Bad EXE format for
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
2001 Nov 06
3
wine seems to be trying
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
2007 Mar 19
1
Wine and MS Access problem
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
2012 Nov 26
2
puzzling RODBC error
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 <-
2010 May 29
2
Running MSACCESS and Tildes Jumis
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
2004 Dec 16
3
Cannot share MSAccess DB after upgrade 3.0.5 to 3.0.8
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
2006 May 08
2
overzealous Windows security
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
2002 Dec 16
2
Save open access databases
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)?
2005 Feb 11
3
msaccess odbc driver not working
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
2005 May 03
2
Access 97 on Wine 20041019
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
2004 Sep 17
5
msaccess db corruption
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
2005 Feb 07
1
how to add a windows share
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
2008 Dec 22
4
Silly Noob
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
2011 Jun 26
1
RJDBC and multiple classpaths
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
2005 Sep 03
2
tar question
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
--
2010 May 16
1
RODBC-Error-sqlSave
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
2007 Jan 18
7
CRITICAL - DB Adapters - Syntax Errors
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