Menu
▾
▴
mdbtools-dev
This list is closed, nobody may subscribe to it.
| 2000 |
Jan
|
Feb
(1) |
Mar
(53) |
Apr
(28) |
May
(5) |
Jun
(7) |
Jul
(16) |
Aug
(15) |
Sep
(10) |
Oct
(1) |
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(9) |
Feb
(7) |
Mar
(1) |
Apr
(7) |
May
(6) |
Jun
|
Jul
(15) |
Aug
(10) |
Sep
(2) |
Oct
(12) |
Nov
(3) |
Dec
(2) |
| 2002 |
Jan
(2) |
Feb
(12) |
Mar
(33) |
Apr
(30) |
May
(5) |
Jun
(18) |
Jul
(18) |
Aug
(47) |
Sep
(8) |
Oct
(7) |
Nov
(8) |
Dec
(13) |
| 2003 |
Jan
(48) |
Feb
(8) |
Mar
(10) |
Apr
(30) |
May
(6) |
Jun
(8) |
Jul
(19) |
Aug
(36) |
Sep
(19) |
Oct
(16) |
Nov
(11) |
Dec
(17) |
| 2004 |
Jan
(11) |
Feb
(22) |
Mar
(52) |
Apr
(45) |
May
(18) |
Jun
(72) |
Jul
(14) |
Aug
(31) |
Sep
(19) |
Oct
(27) |
Nov
(19) |
Dec
(25) |
| 2005 |
Jan
(16) |
Feb
(46) |
Mar
(50) |
Apr
(3) |
May
(21) |
Jun
(3) |
Jul
(24) |
Aug
(33) |
Sep
(25) |
Oct
(23) |
Nov
(30) |
Dec
(20) |
| 2006 |
Jan
(12) |
Feb
(11) |
Mar
(8) |
Apr
(15) |
May
(27) |
Jun
(15) |
Jul
(19) |
Aug
(5) |
Sep
(9) |
Oct
(1) |
Nov
(2) |
Dec
(3) |
| 2007 |
Jan
|
Feb
(3) |
Mar
(18) |
Apr
(5) |
May
(9) |
Jun
|
Jul
(10) |
Aug
(3) |
Sep
(8) |
Oct
(1) |
Nov
(7) |
Dec
(9) |
| 2008 |
Jan
(2) |
Feb
|
Mar
(10) |
Apr
(4) |
May
|
Jun
(5) |
Jul
(9) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(8) |
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(11) |
Nov
(1) |
Dec
(20) |
| 2010 |
Jan
|
Feb
(2) |
Mar
|
Apr
(7) |
May
|
Jun
(23) |
Jul
(3) |
Aug
(6) |
Sep
(1) |
Oct
(4) |
Nov
(1) |
Dec
|
| 2011 |
Jan
(1) |
Feb
(26) |
Mar
(25) |
Apr
(11) |
May
(5) |
Jun
(5) |
Jul
(2) |
Aug
(39) |
Sep
(12) |
Oct
(6) |
Nov
|
Dec
|
| 2012 |
Jan
(19) |
Feb
(5) |
Mar
|
Apr
|
May
|
Jun
(7) |
Jul
|
Aug
(8) |
Sep
|
Oct
(3) |
Nov
(2) |
Dec
(3) |
| 2013 |
Jan
(6) |
Feb
|
Mar
(1) |
Apr
|
May
(7) |
Jun
(5) |
Jul
(2) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2014 |
Jan
(4) |
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(5) |
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
|
From: The W. <th...@fa...> - 2004-12-22 15:40:38
|
On 12/22/04 4:36 PM, Calvin Smith wrote: > The java port should work just fine on osx :) Where can I get it? Thanks. |
|
From: Calvin S. <cal...@ho...> - 2004-12-22 15:37:35
|
>Hi all, Hi >are you planning to add Mac OS X support to MDB tools? >It would be great to have an option to 'open' MDB files in Mac OS X, right >now the only option I know is running Microsoft Access in Virtual PC. The java port should work just fine on osx :) Calvin |
|
From: Calvin S. <cal...@ho...> - 2004-12-22 15:34:08
|
>I'm interested in showing how to manage Access MDB files from OpenOffice, >and thought it could be a good idea to do this under Linux. It works fine >under windows using MS's ODBC driver. I'm able to access a .mdb file from linux using openoffice and the java version of mdbtools. works well and I don't have to setup any kind of odbc stuff. instead I just enter the url to the file and it works :) Give it a shot, if you have errors let me know. Calvin PS. Currently the java version is against 0.5 when 0.6 is official i'll port it to java as well ----Original Message Follows---- From: Kenneth Irving <ke...@fq...> To: mdb...@li... Subject: [mdb-dev] problem compiling 0.6pre1 Date: Mon, 20 Dec 2004 18:33:12 -0300 (UYT) MIME-Version: 1.0 Received: from sc8-sf-uberspam1.sourceforge.net ([66.35.250.206]) by mc12-f18.hotmail.com with Microsoft SMTPSVC(5.0.2195.6824); Mon, 20 Dec 2004 13:37:47 -0800 Received: from projects.sourceforge.net (sc8-sf-list1-b.sourceforge.net [10.3.1.7])by sc8-sf-uberspam1.sourceforge.net (Postfix) with ESMTPid 8A07E1D240C; Mon, 20 Dec 2004 13:34:02 -0800 (PST) Received: from sc8-sf-mx2-b.sourceforge.net ([10.3.1.12] helo=sc8-sf-mx2.sourceforge.net)by sc8-sf-list1.sourceforge.net with esmtp (Exim 4.30)id 1CgV9e-0003Gt-7tfor mdb...@li...; Mon, 20 Dec 2004 13:33:22 -0800 Received: from mail.fq.edu.uy ([164.73.160.197])by sc8-sf-mx2.sourceforge.net with esmtp (Exim 4.41)id 1CgV9c-00036Q-0Hfor mdb...@li...; Mon, 20 Dec 2004 13:33:22 -0800 Received: from mail.fq.edu.uy (localhost [127.0.0.1])by mail.fq.edu.uy (8.12.8/8.12.4) with ESMTP id iBKLXCCZ029169for <mdb...@li...>; Mon, 20 Dec 2004 18:33:12 -0300 Received: from localhost (ken@localhost)by mail.fq.edu.uy (8.12.8/8.12.4/Submit) with ESMTP id iBKLXC0G029166for <mdb...@li...>; Mon, 20 Dec 2004 18:33:12 -0300 X-Message-Info: JGTYoYF78jHDfby3Hrmy5bxIahwywaw0 X-Authentication-Warning: mail.fq.edu.uy: ken owned process doing -bs X-Scanned-By: MIMEDefang 2.29 (www . roaringpenguin . com / mimedefang) X-MIME-Autoconverted: from 8bit to quoted-printable by mail.fq.edu.uy id iBKLXCCZ029169 X-Spam-Score: -4.9 (----) X-Spam-Report: Spam Filtering performed by sourceforge.net.See http://spamassassin.org/tag/ for more details.Report problems to http://sf.net/tracker/?func=add&group_id=1&atid=200001-4.9 BAYES_00 BODY: Bayesian spam probability is 0 to 1%[score: 0.0000] Errors-To: mdb...@li... X-BeenThere: mdb...@li... X-Mailman-Version: 2.0.9-sf.net Precedence: bulk List-Unsubscribe: <https://lists.sourceforge.net/lists/listinfo/mdbtools-dev>,<mailto:mdb...@li...?subject=unsubscribe> List-Id: MDB Tools development <mdbtools-dev.lists.sourceforge.net> List-Post: <mailto:mdb...@li...> List-Help: <mailto:mdb...@li...?subject=help> List-Subscribe: <https://lists.sourceforge.net/lists/listinfo/mdbtools-dev>,<mailto:mdb...@li...?subject=subscribe> List-Archive: <http://sourceforge.net/mailarchive/forum.php?forum=mdbtools-dev> X-Original-Date: Mon, 20 Dec 2004 18:33:12 -0300 (UYT) Return-Path: mdb...@li... X-OriginalArrivalTime: 20 Dec 2004 21:37:47.0680 (UTC) FILETIME=[25EE8A00:01C4E6DC] I downloaded mdbtools 0.6pre1 and configured it using these options: ./configure --with-unixodbc=/usr/lib/unixODBC --enable-sql And when I use make to start the compilation I get this error: ---------------------------- snip ------------------------------------- /bin/sh ../../libtool --mode=link gcc -g -O2 -DSQL -DUNIXODBC -o mdb-sql mdb-sql.o ../libmdb/libmdb.la ../sql/libmdbsql.la -lglib-2.0 -lncursees -lfl gcc -g -O2 -DSQL -DUNIXODBC -o .libs/mdb-sql mdb-sql.o ../libmdb/.libs/libmdb -lm ../sql/.libs/libmdbsql /usr/lib/libglib-2.0.so -lncurses -lfl mdb-sql.o(.text+0xba7): In function `main': /usr/local/src/database/mdbtools-0.6pre1/src/util/mdb-sql.c:364: undefined reference to `read_history' mdb-sql.o(.text+0x10ca):/usr/local/src/database/mdbtools-0.6pre1/src/util/mdb-sql.c:483: undefined reference to `write_history' collect2: ld returned 1 exit status make[2]: *** [mdb-sql] Error 1 make[2]: Leaving directory `/usr/local/src/database/mdbtools-0.6pre1/src/util' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/database/mdbtools-0.6pre1/src' make: *** [all-recursive] Error 1 ---------------------------- snip ------------------------------------ As you see, I interpreted that the compiler doesn't find the read_history function. I searched the sorce files trying to find it and coundn't. Also didn't find write_history. ¿Any clue? Some days ago I compiled mdbtools-0.5 because I'm interested in using the ODBC driver to access mdb files, but couldn't make it work. (By the way, the 0.5 version available for download has a minor error: there is a ';' missing in parser.y. After that it compiled without problem) I'm interested in showing how to manage Access MDB files from OpenOffice, and thought it could be a good idea to do this under Linux. It works fine under windows using MS's ODBC driver. The thing is that although I configures unixODBC files odbc.ini and odbcinst.ini as instructed I keep getting the same error: 'Could not find DSN in odbc.in' reading the list someone suggests this haas been solved in version 0.6pre1, but I haven't been able to compile it. Any ideas... By the way, mdbtool does a great job extracting data from mdb files. I've been able to migrate several databases to MySQL without problem: Great Work!! thanks! best regards Kenneth ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ mdbtools-dev mailing list mdb...@li... https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Pedro A A. <pa...@ho...> - 2004-12-21 15:12:11
|
Hi folks: I'm experiencing the following behaviour in mdb-sql from the CVS code: I can describe table and list table correctly, but when I select something, I get the right nomber of lines all are empty :( This doesn't happen with 0.5. BTW, it would be good to have an fflush(stdout); after each fprintf(stdout,"\n"); to enable running mdb-sql as an interactive coprocess of another program. I use this in a patched version of 0.5 in order to run TCC scripts which make complex queries to an mdb database. Regards, Pedro A, pa...@ho... paag@paag:~/BR4K$ mdb-sql bdb4k.mdb 1 => select idDisco from Discos where disco = 'BR4C_033' 2 => go +-----------+ |idDisco | +-----------+ | | +-----------+ 1 Row retrieved 1 => list tables 2 => go +------------------------------+ |Tables | +------------------------------+ |Archivos | |Arreglistas | |Conjuntos | |Directores | |Discos | |Grabaciones | |Instrumentos | |Programas | |Solistas | |UnionArchivoDisco | |UnionGrabacionesSolistasInstru| |Autores | |UnionGrabacionesConjuntosDirec| +------------------------------+ 13 Rows retrieved 1 => describe table discos 2 => go +------------------------------+--------------------+----------+ |Column Name |Type |Size | +------------------------------+--------------------+----------+ |IdDisco |Long Integer |4 | |Disco |Text |50 | +------------------------------+--------------------+----------+ 2 Rows retrieved 1 => exit |
|
From: Kenneth I. <ke...@fq...> - 2004-12-20 21:33:22
|
I downloaded mdbtools 0.6pre1 and configured it using these options: ./configure --with-unixodbc=3D/usr/lib/unixODBC --enable-sql And when I use make to start the compilation I get this error: ---------------------------- snip ------------------------------------- /bin/sh ../../libtool --mode=3Dlink gcc -g -O2 -DSQL -DUNIXODBC -o mdb= -sql mdb-sql.o ../libmdb/libmdb.la ../sql/libmdbsql.la -lglib-2.0 -lnc= ursees -lfl gcc -g -O2 -DSQL -DUNIXODBC -o .libs/mdb-sql mdb-sql.o ../libmdb/.libs/l= ibmdb -lm ../sql/.libs/libmdbsql /usr/lib/libglib-2.0.so -lncurses -lfl mdb-sql.o(.text+0xba7): In function `main': /usr/local/src/database/mdbtools-0.6pre1/src/util/mdb-sql.c:364: undefine= d reference to `read_history' mdb-sql.o(.text+0x10ca):/usr/local/src/database/mdbtools-0.6pre1/src/util= /mdb-sql.c:483: undefined reference to `write_history' collect2: ld returned 1 exit status make[2]: *** [mdb-sql] Error 1 make[2]: Leaving directory `/usr/local/src/database/mdbtools-0.6pre1/src/util' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/usr/local/src/database/mdbtools-0.6pre1/src' make: *** [all-recursive] Error 1 ---------------------------- snip ------------------------------------ As you see, I interpreted that the compiler doesn't find the read_history function. I searched the sorce files trying to find it and coundn't. Also didn't find write_history. =BFAny clue? Some days ago I compiled mdbtools-0.5 because I'm interested in using the ODBC driver to access mdb files, but couldn't make it work. (By the way, the 0.5 version available for download has a minor error: there is a ';' missing in parser.y. After that it compiled without problem) I'm interested in showing how to manage Access MDB files from OpenOffice, and thought it could be a good idea to do this under Linux. It works fine under windows using MS's ODBC driver. The thing is that although I configures unixODBC files odbc.ini and odbcinst.ini as instructed I keep getting the same error: 'Could not find DSN in odbc.in' reading the list someone suggests this haas been solved in version 0.6pre1, but I haven't been able to compile it. Any ideas... By the way, mdbtool does a great job extracting data from mdb files. I've been able to migrate several databases to MySQL without problem: Great Work!! thanks! best regards Kenneth |
|
From: Jeff S. <why...@ya...> - 2004-12-18 05:10:05
|
If anyone would care to donate the hardware and OS, I would be happy to support it. :-)) On a more realistic note, the most likely cause of problems (if any) would probably be endian issues. I did some minimal testing on a Sparc machine (big-endian like PowerPC) and I do not recall having any significant issues. Please do try it out, and report any issues you may have. -- Thanks, -- Jeff Smith --- Matthew Palmer <mp...@he...> wrote: > On Fri, Dec 17, 2004 at 09:10:17PM +0100, The Wolf wrote: > > are you planning to add Mac OS X support to MDB tools? > > If you've got the Unix build tools (buggered if I can remember what they're > called at the moment) you should be able to build MDB tools without too much > hassle. > > - Matt __________________________________ Do you Yahoo!? Send holiday email and support a worthy cause. Do good. http://celebrity.mail.yahoo.com |
|
From: Matthew P. <mp...@he...> - 2004-12-17 21:56:59
|
On Fri, Dec 17, 2004 at 09:10:17PM +0100, The Wolf wrote: > are you planning to add Mac OS X support to MDB tools? If you've got the Unix build tools (buggered if I can remember what they're called at the moment) you should be able to build MDB tools without too much hassle. - Matt |
|
From: The W. <th...@fa...> - 2004-12-17 20:10:25
|
Hi all, are you planning to add Mac OS X support to MDB tools? It would be great to have an option to 'open' MDB files in Mac OS X, right now the only option I know is running Microsoft Access in Virtual PC. Keep up the great work! Thanks a lot. |
|
From: Jeff S. <why...@ya...> - 2004-12-11 06:22:24
|
I have made some additional changes in this area. 1. Default jet3 encoding is now set to CP1252. 2. Added encoding and proper decoding for 'Unicode Compression' (it is a bit more complex than an ISO-8859-1 string prepended by 0xff 0xfe). 3. Combined arguments for source buffer and offset in ascii2unicode and unicode2ascii. -- Jeff Smith --- wind <tee...@ya...> wrote: > Hi,Brian > With this patch I convert both jet3 and jet4 strings to MDB_ICONV. > After reading http://support.microsoft.com/default.aspx?scid=kb;en-us;289525 ad > http://support.microsoft.com/kb/202479/EN-US/, I guess that there is not charset > infomation in jet3 database. So I introduce a new enviroment variable MDB_JET3_CHARSET. > If it's not setted then ISO8859-1 will be used. For peoples in other countries other > charset can be setted. For example, I set MDB_JET3_CHARSET to GBK since I use Chinese > version Access. > > Regards > Wind > ----- Original Message ----- > From: "Brian Bruns" <bri...@gm...> > To: <mdb...@li...> > Sent: Friday, November 26, 2004 9:47 PM > Subject: [mdb-dev] utf-8/iconv support > > > > Hi all, > > > > I've finally commited my iconv patch. A couple of comments. > > > > The default behaviour is to convert to UTF-8. Setting the MDB_ICONV > > environment variable will override this. For example: > > > > export MDB_ICONV=ISO8859-1 > > > > will cause MDB Tools to convert into good ol' ISO 8859, a single byte > > character set used for most western european languages. If the > > variable is not set, UTF-8 is used, which will work well with most > > recent linux distros. > > > > For Jet3, the database is considered to be encoded in ISO 8859-1, > > there is probably setting in the database definition page that really > > says what it is. If somebody has Jet 3 databases in another character > > set, and can send a hex dump of page 0, we may be able to figure it > > out. (just run "mdb-hexdump <db> | head -250" from the src/extras > > directory). > > > > Cheers, > > > > Brian __________________________________ Do you Yahoo!? Send a seasonal email greeting and help others. Do good. http://celebrity.mail.yahoo.com |
|
From: Brian B. <bri...@gm...> - 2004-12-10 02:23:12
|
Hmmm...see if you can apply ("apply" may be a stretch) patch # 844529
from the sourceforge site and see if that works for you. That'd be
for 0.5.
I'd be interested in fixing the CVS version. I don't have access to a
solaris box though. I could try it on AIX and perhaps find
something...do you have a sample database which demonstrates the
problem? The other possibility is that it is a 32bit/64bit issue.
I'm not sure it is 64bit clean, can you set the compiler flags to
force 32bit mode? (not sure how to do it on sparc, sorry).
Brian
On Thu, 9 Dec 2004 12:40:31 +1100, Justin Higgins
<jus...@te...> wrote:
> Brian,
>
> Thanks for your reply. The columns getting truncated are all
> 'Memo/Hyperlink' type. The truncation seems to be independent of the
> length of the data in that column.
>
> Perhaps mdbtools is linking against different library versions on
> Solaris than it is on OSX, it seems strange that 0.5 would work and CVS
> doesn't though. Are there any particular versions of libraries you know
> of that have caused this kind of trouble ?
>
> Also, I am on Sparc Solaris, so you're right, they should both be big
> endian.
>
> Thanks again,
>
> - Justin
>
>
>
> On 10/12/2004, at 9:53 AM, Brian Bruns wrote:
>
> > Hi,
> >
> > David Mansfield's patches are (all, i think) integrated into CVS. I'd
> > say the beyond EOF is probably a byte order issue, except that OSX
> > should be big endian too.
> >
> > Are the columns getting truncated all of one type?
> >
> > Brian
> >
> > On Wed, 8 Dec 2004 16:52:40 +1100, Justin Higgins
> > <jus...@te...> wrote:
> >> Hi,
> >>
> >> First off, really useful project, thanks for everyone's effort that
> > has
> >> allowed me to even get this far.
> >>
> >> I've been using mdb-export 0.5 in a project to export large volumes of
> >> .mdb files (JET3 and JET4) to .csv files on Solaris 9. It's been
> >> working great except that some columns in JET3 are getting 1 character
> >> truncated sometimes.
> >>
> >> The CVS version of mdbtools does not seem to have this problem when I
> >> run it on Mac OSX 10.3, but I cannot get it to run on Solaris 9. Under
> >> Solaris it returns "offset <number> is beyond EOF" in amongst some of
> >> the .csv output and then core dumps.
> >>
> >> I have no idea what I am doing when it comes to C/C++ development and
> > I
> >> was hoping someone might be able to point me in the right direction to
> >> either a patch for 0.5 that might fix the truncation issue or a way to
> >> fix the EOF errors on Solaris.
> >>
> >> I did see mention in this list's archives of several stability
> >> improvements David Mansfield had made available as patches, is a
> >> combined patch of these improvements available anywhere ? I would like
> >> to test these improvements in 0.5 and see if they fix my truncation
> >> issue.
> >>
> >> Thanks for reading,
> >>
> >> - Justin Higgins
> >>
> >> -------------------------------------------------------
> >> SF email is sponsored by - The IT Product Guide
> >> Read honest & candid reviews on hundreds of IT Products from real
> > users.
> >> Discover which products truly live up to the hype. Start reading now.
> >> http://productguide.itmanagersjournal.com/
> >> _______________________________________________
> >> mdbtools-dev mailing list
> >> mdb...@li...
> >> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> >>
> >
>
>
|
|
From: Justin H. <jus...@te...> - 2004-12-09 05:54:27
|
Hi, First off, really useful project, thanks for everyone's effort that has allowed me to even get this far. I've been using mdb-export 0.5 in a project to export large volumes of .mdb files (JET3 and JET4) to .csv files on Solaris 9. It's been working great except that some columns in JET3 are getting 1 character truncated sometimes. The CVS version of mdbtools does not seem to have this problem when I run it on Mac OSX 10.3, but I cannot get it to run on Solaris 9. Under Solaris it returns "offset <number> is beyond EOF" in amongst some of the .csv output and then core dumps. I have no idea what I am doing when it comes to C/C++ development and I was hoping someone might be able to point me in the right direction to either a patch for 0.5 that might fix the truncation issue or a way to fix the EOF errors on Solaris. I did see mention in this list's archives of several stability improvements David Mansfield had made available as patches, is a combined patch of these improvements available anywhere ? I would like to test these improvements in 0.5 and see if they fix my truncation issue. Thanks for reading, - Justin Higgins |
|
From: Paul K. <ku...@ws...> - 2004-12-06 20:00:33
|
Newbie here, really great project! Couple of items: 1. the CVS links listed on http://mdbtools.sourceforge.net/ appear to be wrong, should be: cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools login cvs -z3 -d:pserver:ano...@cv...:/cvsroot/mdbtools co mdbtools 2. is anyone working on the java version right now? there is a bug in the handling of memo fields in Access 2000 files. It improperly detects non-unicode fields as unicode and consequently munges them. I believe the following fixes it: /mdbtools/mdbtools-java/src/mdbtools/libmdb/Data.java:705 is currently: if (mdb.pg_buf[row_start]==0xff && mdb.pg_buf[row_start+1]==0xfe) should be: if (mdb.pg_buf[row_start]==(byte) 0xff && mdb.pg_buf[row_start+1]==(byte) 0xfe) Paul ************************************ Paul Kulp, Ph.D. Chief Information Officer Web Services Group http://www.wsg.net |
|
From: wind <tee...@ya...> - 2004-12-01 16:07:07
|
SGksQnJpYW4NCiAgICBXaXRoIHRoaXMgcGF0Y2ggSSBjb252ZXJ0IGJvdGggamV0MyBhbmQgamV0 NCBzdHJpbmdzIHRvIE1EQl9JQ09OVi4gDQpBZnRlciByZWFkaW5nICBodHRwOi8vc3VwcG9ydC5t aWNyb3NvZnQuY29tL2RlZmF1bHQuYXNweD9zY2lkPWtiO2VuLXVzOzI4OTUyNSAgYWQgaHR0cDov L3N1cHBvcnQubWljcm9zb2Z0LmNvbS9rYi8yMDI0NzkvRU4tVVMvLCBJIGd1ZXNzIHRoYXQgdGhl cmUgaXMgbm90IGNoYXJzZXQgaW5mb21hdGlvbiBpbiBqZXQzIGRhdGFiYXNlLiBTbyBJIGludHJv ZHVjZSBhIG5ldyBlbnZpcm9tZW50IHZhcmlhYmxlIE1EQl9KRVQzX0NIQVJTRVQuICBJZiBpdCdz IG5vdCBzZXR0ZWQgdGhlbiBJU084ODU5LTEgd2lsbCBiZSB1c2VkLiBGb3IgcGVvcGxlcyBpbiBv dGhlciBjb3VudHJpZXMgb3RoZXIgY2hhcnNldCBjYW4gYmUgc2V0dGVkLiBGb3IgZXhhbXBsZSwg SSBzZXQgTURCX0pFVDNfQ0hBUlNFVCB0byBHQksgc2luY2UgSSB1c2UgQ2hpbmVzZSB2ZXJzaW9u IEFjY2Vzcy4gIA0KDQpSZWdhcmRzDQpXaW5kDQotLS0tLSBPcmlnaW5hbCBNZXNzYWdlIC0tLS0t IA0KRnJvbTogIkJyaWFuIEJydW5zIiA8YnJpYW4uYnJ1bnNAZ21haWwuY29tPg0KVG86IDxtZGJ0 b29scy1kZXZAbGlzdHMuc291cmNlZm9yZ2UubmV0Pg0KU2VudDogRnJpZGF5LCBOb3ZlbWJlciAy NiwgMjAwNCA5OjQ3IFBNDQpTdWJqZWN0OiBbbWRiLWRldl0gdXRmLTgvaWNvbnYgc3VwcG9ydA0K DQoNCj4gSGkgYWxsLCANCj4gDQo+IEkndmUgZmluYWxseSBjb21taXRlZCBteSBpY29udiBwYXRj aC4gIEEgY291cGxlIG9mIGNvbW1lbnRzLg0KPiANCj4gVGhlIGRlZmF1bHQgYmVoYXZpb3VyIGlz IHRvIGNvbnZlcnQgdG8gVVRGLTguICBTZXR0aW5nIHRoZSBNREJfSUNPTlYNCj4gZW52aXJvbm1l bnQgdmFyaWFibGUgd2lsbCBvdmVycmlkZSB0aGlzLiBGb3IgZXhhbXBsZToNCj4gDQo+IGV4cG9y dCBNREJfSUNPTlY9SVNPODg1OS0xDQo+IA0KPiB3aWxsIGNhdXNlIE1EQiBUb29scyB0byBjb252 ZXJ0IGludG8gZ29vZCBvbCcgSVNPIDg4NTksIGEgc2luZ2xlIGJ5dGUNCj4gY2hhcmFjdGVyIHNl dCB1c2VkIGZvciBtb3N0IHdlc3Rlcm4gZXVyb3BlYW4gbGFuZ3VhZ2VzLiAgSWYgdGhlDQo+IHZh cmlhYmxlIGlzIG5vdCBzZXQsIFVURi04IGlzIHVzZWQsIHdoaWNoIHdpbGwgd29yayB3ZWxsIHdp dGggbW9zdA0KPiByZWNlbnQgbGludXggZGlzdHJvcy4NCj4gDQo+IEZvciBKZXQzLCB0aGUgZGF0 YWJhc2UgaXMgY29uc2lkZXJlZCB0byBiZSBlbmNvZGVkIGluIElTTyA4ODU5LTEsDQo+IHRoZXJl IGlzIHByb2JhYmx5IHNldHRpbmcgaW4gdGhlIGRhdGFiYXNlIGRlZmluaXRpb24gcGFnZSB0aGF0 IHJlYWxseQ0KPiBzYXlzIHdoYXQgaXQgaXMuICBJZiBzb21lYm9keSBoYXMgSmV0IDMgZGF0YWJh c2VzIGluIGFub3RoZXIgY2hhcmFjdGVyDQo+IHNldCwgYW5kIGNhbiBzZW5kIGEgaGV4IGR1bXAg b2YgcGFnZSAwLCB3ZSBtYXkgYmUgYWJsZSB0byBmaWd1cmUgaXQNCj4gb3V0LiAgKGp1c3QgcnVu ICJtZGItaGV4ZHVtcCA8ZGI+IHwgaGVhZCAtMjUwIiBmcm9tIHRoZSBzcmMvZXh0cmFzDQo+IGRp cmVjdG9yeSkuDQo+IA0KPiBDaGVlcnMsDQo+IA0KPiBCcmlhbg0KPiANCj4gDQo+IC0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCj4gU0YgZW1h aWwgaXMgc3BvbnNvcmVkIGJ5IC0gVGhlIElUIFByb2R1Y3QgR3VpZGUNCj4gUmVhZCBob25lc3Qg JiBjYW5kaWQgcmV2aWV3cyBvbiBodW5kcmVkcyBvZiBJVCBQcm9kdWN0cyBmcm9tIHJlYWwgdXNl cnMuDQo+IERpc2NvdmVyIHdoaWNoIHByb2R1Y3RzIHRydWx5IGxpdmUgdXAgdG8gdGhlIGh5cGUu IFN0YXJ0IHJlYWRpbmcgbm93LiANCj4gaHR0cDovL3Byb2R1Y3RndWlkZS5pdG1hbmFnZXJzam91 cm5hbC5jb20vDQo+IF9fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX19f X19fDQo+IG1kYnRvb2xzLWRldiBtYWlsaW5nIGxpc3QNCj4gbWRidG9vbHMtZGV2QGxpc3RzLnNv dXJjZWZvcmdlLm5ldA0KPiBodHRwczovL2xpc3RzLnNvdXJjZWZvcmdlLm5ldC9saXN0cy9saXN0 aW5mby9tZGJ0b29scy1kZXYNCj4g |
|
From: Wind Li <Wi...@Su...> - 2004-12-01 07:53:35
|
Brian wrote:
> Hi all,
> I"ve finally commited my iconv patch. A couple of comments.
>
Great thanks Brian. I had just try it. It worked. Some suggestion:
1. mdbtools.h should not include config.h,
2. It should be better to apply the conversion on both jet3 and jet4 ,
so that users don't need care jet versions.
> The default behaviour is to convert to UTF-8. Setting the MDB_ICONV
> environment variable will override this. For example:
>
> export MDB_ICONV=ISO8859-1
>
> will cause MDB Tools to convert into good ol" ISO 8859, a single byte
> character set used for most western european languages. If the
> variable is not set, UTF-8 is used, which will work well with most
> recent linux distros.
>
> For Jet3, the database is considered to be encoded in ISO 8859-1,
> there is probably setting in the database definition page that really
> says what it is. If somebody has Jet 3 databases in another character
> set, and can send a hex dump of page 0, we may be able to figure it
> out. (just run "mdb-hexdump <db> | head -250" from the src/extras
> directory).
>
No. For example I am in China,so my databases are encoded in GB_2312.
> Cheers,
>
> Brian
>
--
Best Regards
______
/_____/\ Wind Li
/____ \\ \ Sun Microsystems
/_____\ \\ / Email: wi...@su...
/_____/ \/ / / Tel: (8610)82618200 ext.82962
/_____/ / \//\ Fax: (8610)62780969
\_____\//\ / / Cel: 13691555880
\_____/ / /\ /
\_____/ \\ \ China Engineering & Research Institute
\_____\ \\ 10/F, B ChuangXin Plaza
\_____\/ Beijing 100084, P.R.China
|
|
From: Brian B. <bri...@gm...> - 2004-11-26 13:48:03
|
Hi all, I've finally commited my iconv patch. A couple of comments. The default behaviour is to convert to UTF-8. Setting the MDB_ICONV environment variable will override this. For example: export MDB_ICONV=ISO8859-1 will cause MDB Tools to convert into good ol' ISO 8859, a single byte character set used for most western european languages. If the variable is not set, UTF-8 is used, which will work well with most recent linux distros. For Jet3, the database is considered to be encoded in ISO 8859-1, there is probably setting in the database definition page that really says what it is. If somebody has Jet 3 databases in another character set, and can send a hex dump of page 0, we may be able to figure it out. (just run "mdb-hexdump <db> | head -250" from the src/extras directory). Cheers, Brian |
|
From: Michael W. <mw...@ic...> - 2004-11-24 09:33:01
|
On Tue, Nov 23, 2004 at 05:17:26PM +0100, Christian Theune wrote:
> Hi,
>
> it looks like libmdb (0.6rc) has a memory leak. Valgrind told me this:
>
> ==1322== 3240 bytes in 9 blocks are definitely lost in loss record 23 of
> 27
> ==1322== at 0x1B905901: calloc (vg_replace_malloc.c:176)
> ==1322== by 0x1BFC1937: g_malloc0
> (in /usr/lib/libglib-2.0.so.0.400.7)
> ==1322== by 0x1B93EF9B: mdb_read_table (table.c:56)
>
> Does that make any sense to you?
table.c from line 56 is:
table = mdb_alloc_tabledef(entry);
mdb_read_pg(mdb, entry->table_pg);
if (mdb->pg_buf[0] != 0x02) return NULL; /* not a valid table def page */
[...]
mdb_alloc_tabledef() in mem.c calls g_malloc0().
So table.c does not free the allocated space if mdb->pg_buf[0]
is not 0x02.
The code is the same in current CVS.
Try this (untested):
--- mdbtools-0.6pre1.orig/src/libmdb/table.c 2004-06-15 06:12:37.000000000 +0200
+++ mdbtools-0.6pre1/src/libmdb/table.c 2004-11-24 11:26:52.000000000 +0200
@@ -56,7 +56,10 @@
table = mdb_alloc_tabledef(entry);
mdb_read_pg(mdb, entry->table_pg);
- if (mdb->pg_buf[0] != 0x02) return NULL; /* not a valid table def page */
+ if (mdb->pg_buf[0] != 0x02) {
+ mdb_free_tabledef(table);
+ return NULL; /* not a valid table def page */
+ }
len = mdb_pg_get_int16(mdb,8);
--
Michael Wood <mw...@ic...>
|
|
From: Christian T. <ct...@go...> - 2004-11-23 16:17:31
|
Hi, it looks like libmdb (0.6rc) has a memory leak. Valgrind told me this: =3D=3D1322=3D=3D 3240 bytes in 9 blocks are definitely lost in loss record = 23 of 27 =3D=3D1322=3D=3D at 0x1B905901: calloc (vg_replace_malloc.c:176) =3D=3D1322=3D=3D by 0x1BFC1937: g_malloc0 (in /usr/lib/libglib-2.0.so.0.400.7) =3D=3D1322=3D=3D by 0x1B93EF9B: mdb_read_table (table.c:56) Does that make any sense to you? Cheers, Christian --=20 gocept gmbh & co. kg - schalaunische str. 6 - 06366 koethen - germany www.gocept.com - ct...@go... - phone +49 3496 30 99 112 - fax +49 3496 30 99 118 - zope and plone consulting and development |
|
From: David S. <ds...@xs...> - 2004-11-22 17:01:09
|
El lun, 22-11-2004 a las 13:18 +0100, David Suela Fern=E1ndez escribi=F3:
> Hi!
>=20
> I'm trying to do and insert (or update) in a jet3 db with a php script
> using odbc:
>=20
> $myDB =3D odbc_connect("Dogs","","");
> $q =3D "insert into Tabla1(a,b,c) values('1235', '23', '43')";
> odbc_exec($myDB, $q);
> odbc_close($myDB);
>=20
> But always get the error: "Error at Line : syntax error near insert"
>=20
> I'm using the cvs version in a debian sarge.
>=20
> is it posible to write with odbc in a access db? some other way to do
> that?
>=20
> Thanks,
>=20
With libadodb it works. Now the problem is than the database has a
password. I tried with the next dns:
[Dogs]
Description =3D Microsoft Access Database
Driver =3D MDBToolsODBC
Database =3D /home/lala/test.mdb
SERVER =3D localhost
UserName =3D=20
Password =3D "mypasswd"
PORT =3D 5432
With this setting always said that the table doesn't exit.
Some suggestion? can mdbtoos use protected jet3 databases?
Thanks,
--=20
David Suela Fern=E1ndez <ds...@xs...>
xsto.info <el acceso a la informaci=F3n>
|
|
From: Brian B. <bri...@gm...> - 2004-11-22 15:20:18
|
Hi,
MDB Tools does not yet support writing to mdb databases. Some
preliminary code has been written, but it is really not yet usable.=20
See my message in the archives for details.
Brian
On Mon, 22 Nov 2004 13:18:53 +0100, David Suela Fern=E1ndez
<ds...@xs...> wrote:
> Hi!
>=20
> I'm trying to do and insert (or update) in a jet3 db with a php script
> using odbc:
>=20
> $myDB =3D odbc_connect("Dogs","","");
> $q =3D "insert into Tabla1(a,b,c) values('1235', '23', '43')";
> odbc_exec($myDB, $q);
> odbc_close($myDB);
>=20
> But always get the error: "Error at Line : syntax error near insert"
>=20
> I'm using the cvs version in a debian sarge.
>=20
> is it posible to write with odbc in a access db? some other way to do
> that?
>=20
> Thanks,
>=20
> --
> David Suela Fern=E1ndez <ds...@xs...>
> xsto.info <el acceso a la informaci=F3n>
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://productguide.itmanagersjournal.com/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
|
|
From: David S. <ds...@xs...> - 2004-11-22 12:20:34
|
Hi!
I'm trying to do and insert (or update) in a jet3 db with a php script
using odbc:
$myDB =3D odbc_connect("Dogs","","");
$q =3D "insert into Tabla1(a,b,c) values('1235', '23', '43')";
odbc_exec($myDB, $q);
odbc_close($myDB);
But always get the error: "Error at Line : syntax error near insert"
I'm using the cvs version in a debian sarge.
is it posible to write with odbc in a access db? some other way to do
that?
Thanks,
--=20
David Suela Fern=E1ndez <ds...@xs...>
xsto.info <el acceso a la informaci=F3n>
|
|
From: Dario A. <aba...@si...> - 2004-11-17 16:05:47
|
Am Mittwoch, 17. November 2004 14:37 schrieb Jeff Smith: > Configure tries to find GLib with pkg-config. Try running > 'pkg-config glib-2.0 --modversion' This should tell you > both the version of glib being found, and if pkg-config is > aware of glib at all. Please report back what you find. $PKG_CONFIG_PATH was unset on my system, so I tried # PKG_CONFIG_PATH="/usr/lib/pkgconfig/" pkg-config glib-2.0 --modversion and got "2.2.1" as an answer. Using this informatio on configure with: # PKG_CONFIG_PATH="/usr/lib/pkgconfig/" CPPFLAGS="-I/usr/include/glib-2.0/ -I/usr/lib/glib-2.0/include/" ./configure made configure run perfectly! A subsequent "make ; make install" worked just as well. Problem solved! Thanks for your help! Dario Abatianni |
|
From: Jeff S. <why...@ya...> - 2004-11-17 13:37:46
|
Configure tries to find GLib with pkg-config. Try running 'pkg-config glib-2.0 --modversion' This should tell you both the version of glib being found, and if pkg-config is aware of glib at all. Please report back what you find. -- Jeff Smith --- Dario Abatianni <aba...@si...> wrote: > Hi! > > I have trouble compiling the 0.6cvs version of mdbtools: > > # ./configure > > checking Are we using flex ... yes > checking for pkg-config... /usr/local/bin/pkg-config > checking for GLIB - version >= 2.0.0... no > *** Could not run GLIB test program, checking why... > *** The test program failed to compile or link. See the file config.log for the > *** exact error that occured. This usually means GLIB is incorrectly installed. > > I look in config.log and see > > configure:9153: gcc -o conftest -g -O2 -DSQL conftest.c >&5 > configure:9163:18: glib.h: No such file or directory > > So glib.h is not found. I add the path to the compiler flags (glibconfig.h was > not found as well so I add the second path respectively): > > CPPFLAGS="-I/usr/include/glib-2.0/ -I/usr/lib/glib-2.0/include/" ./configure > > Still I get the same error on configure: > > checking for GLIB - version >= 2.0.0... no > *** Could not run GLIB test program, checking why... > *** The test program failed to compile or link. See the file config.log for the > *** exact error that occured. This usually means GLIB is incorrectly installed. > > Ok, so I look into config.log again and find: > > configure:9153: gcc -o conftest -g -O2 -DSQL -I/usr/include/glib-2.0/ > -I/usr/lib/glib-2.0/include/ conftest.c >&5 > /tmp/cc0gK6T1.o(.text+0x8): In function `main': > /installs/mdbtools/cvs/configure:9169: undefined reference to `glib_major_version' > /tmp/cc0gK6T1.o(.text+0x17):/installs/mdbtools/cvs/configure:9169: undefined reference > to `glib_minor_version' > /tmp/cc0gK6T1.o(.text+0x32):/installs/mdbtools/cvs/configure:9172: undefined reference > to `glib_micro_version' > > This is where my knowledge ends. What can I do to make mdbtools compile? > > Thanks for your time! > Yours, > Dario Abatianni __________________________________ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com |
|
From: Dario A. <aba...@si...> - 2004-11-17 11:01:59
|
Hi! I have trouble compiling the 0.6cvs version of mdbtools: # ./configure checking Are we using flex ... yes checking for pkg-config... /usr/local/bin/pkg-config checking for GLIB - version >= 2.0.0... no *** Could not run GLIB test program, checking why... *** The test program failed to compile or link. See the file config.log for the *** exact error that occured. This usually means GLIB is incorrectly installed. I look in config.log and see configure:9153: gcc -o conftest -g -O2 -DSQL conftest.c >&5 configure:9163:18: glib.h: No such file or directory So glib.h is not found. I add the path to the compiler flags (glibconfig.h was not found as well so I add the second path respectively): CPPFLAGS="-I/usr/include/glib-2.0/ -I/usr/lib/glib-2.0/include/" ./configure Still I get the same error on configure: checking for GLIB - version >= 2.0.0... no *** Could not run GLIB test program, checking why... *** The test program failed to compile or link. See the file config.log for the *** exact error that occured. This usually means GLIB is incorrectly installed. Ok, so I look into config.log again and find: configure:9153: gcc -o conftest -g -O2 -DSQL -I/usr/include/glib-2.0/ -I/usr/lib/glib-2.0/include/ conftest.c >&5 /tmp/cc0gK6T1.o(.text+0x8): In function `main': /installs/mdbtools/cvs/configure:9169: undefined reference to `glib_major_version' /tmp/cc0gK6T1.o(.text+0x17):/installs/mdbtools/cvs/configure:9169: undefined reference to `glib_minor_version' /tmp/cc0gK6T1.o(.text+0x32):/installs/mdbtools/cvs/configure:9172: undefined reference to `glib_micro_version' This is where my knowledge ends. What can I do to make mdbtools compile? Thanks for your time! Yours, Dario Abatianni |
|
From: Rob <ro...@ir...> - 2004-11-16 09:10:13
|
Sam. Some sort of automated scripting to do the conversion was what I was thinking about also.. I'll keep playing. Many thanks for the help. Rob At 08:02 15/11/2004, Sam Moffatt wrote: >Well, perhaps the best option is to write a macro/com automation to >get access to convert the database to the right format. I've done a >bit of work with Word automation (using PHP mostly), perhaps you could >also something similar to automate the process. > >If your trying to link it in, perhaps run the script automatically >every hour. Its the best solution. You'll need a dedicated windows >box, but since access will be doing the work, it should be right. >There is some issues and microsoft doesn't support using office in >this way, have a look on msdn about it, but it can be done. > >access is a pain in the ass to use, but for a lot of things, its a >fact of life. if your familiar enough with php (my favourite >language), it appears to work alright with office, just use the vba >help (functions are the same, so it doesn't matter). > >Good luck, > >Sam > > >On Mon, 15 Nov 2004 06:08:42 +0000, Rob <ro...@ir...> wrote: > > Thanks for the response! > > > > I tried converting the database back to prior version through Access 2000, > > and get the same result as before; mdb-tables doesn't list anything for the > > converted db. The Access2000 version of the database lists fine. > > > > The App is Shooting Star http://www.foodogsoftware.com/ - an eBay auction > > management utility. I'd rather not change this, as it does everything I > > need it to do, and I've got rather a lot of historical data stored in > > it. I'm just trying to write a routine to track our ebay sales and tie > > them into our own web store ( http://www.russianglass.co.uk ). > > > > If I give it the upconverted database, I get the error: > > Error #3343 Unrecognized database format 'G:\blah\userdata.mdb'. > > Jet Version: 3.51 > > Source: DAO.Workspace > > Help Topic 5003343 in jeterr35.hlp > > > > It is quite happy, however, with having it's database password removed, and > > didn't seem to mind the db which had been converted up and back down again. > > > > I presume that despite my having Access 2000 installed on this machine, > > it's using a lesser version runtime routines? (It's much the same error if > > I try to open the later version db in Access 97.) > > > > Thanks, > > > > Rob > > > > > > > > > > At 03:43 15/11/2004, Sam Moffatt wrote: > > > > >In Access 2000, there is an option under the tools menu option to save > > >it as an older version of the database, so you don't need access 97 to > > >save databases in that format. Perhaps try using that. Also, what > > >language is your windows app running? if you've got access 2000 > > >running, it shouldn't have any issues. and can you change the windows > > >app? > > > > > >Sam > > > > > > > > >On Mon, 15 Nov 2004 01:58:46 +0000, Rob <ro...@ir...> wrote: > > > > Hi! > > > > > > > > I've been working on an ap in php, accessing an access database via > odbc & > > > > mdbtools. > > > > > > > > The database is actually from windows application, and appears to > be using > > > > the jet 3.51 engine for access. As it was password protected (but > I know > > > > the password) I loaded it into Access 2000, converted to new format, > > > > cleared the password, and saved it out as a temporary copy. mdb tools > > > > works fine on this copy, but I guess it's now in Jet 4 format. The > windows > > > > app certainly objects to it anyway. > > > > > > > > I finally got around to installing office 97 on a pc so I could > remove the > > > > password from the database without converting the format. This I > managed > > > > to do, and the windows app is happy with it, however mdb tools > refuses to > > > > return any data from it. Even mdb-tables just prints a blank line and > > > exits. > > > > > > > > mdb-tables does however list the tables in Northwind.mdb samed from the > > > > office 97 install. > > > > > > > > I'm using 0.6pre1, downloaded Nov 1st, running on FreebSD > 4.10-STABLE #0. > > > > > > > > Is there anything else I can try, do, tell you, to solve this? > > > > > > > > Thanks, > > > > > > > > Rob. > > > > > > >------------------------------------------------------- >This SF.Net email is sponsored by: InterSystems CACHE >FREE OODBMS DOWNLOAD - A multidimensional database that combines >robust object and relational technologies, making it a perfect match >for Java, C++,COM, XML, ODBC and JDBC. www.intersystems.com/match8 >_______________________________________________ >mdbtools-dev mailing list >mdb...@li... >https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Sam M. <pa...@gm...> - 2004-11-15 08:03:00
|
Well, perhaps the best option is to write a macro/com automation to get access to convert the database to the right format. I've done a bit of work with Word automation (using PHP mostly), perhaps you could also something similar to automate the process. If your trying to link it in, perhaps run the script automatically every hour. Its the best solution. You'll need a dedicated windows box, but since access will be doing the work, it should be right. There is some issues and microsoft doesn't support using office in this way, have a look on msdn about it, but it can be done. access is a pain in the ass to use, but for a lot of things, its a fact of life. if your familiar enough with php (my favourite language), it appears to work alright with office, just use the vba help (functions are the same, so it doesn't matter). Good luck, Sam On Mon, 15 Nov 2004 06:08:42 +0000, Rob <ro...@ir...> wrote: > Thanks for the response! > > I tried converting the database back to prior version through Access 2000, > and get the same result as before; mdb-tables doesn't list anything for the > converted db. The Access2000 version of the database lists fine. > > The App is Shooting Star http://www.foodogsoftware.com/ - an eBay auction > management utility. I'd rather not change this, as it does everything I > need it to do, and I've got rather a lot of historical data stored in > it. I'm just trying to write a routine to track our ebay sales and tie > them into our own web store ( http://www.russianglass.co.uk ). > > If I give it the upconverted database, I get the error: > Error #3343 Unrecognized database format 'G:\blah\userdata.mdb'. > Jet Version: 3.51 > Source: DAO.Workspace > Help Topic 5003343 in jeterr35.hlp > > It is quite happy, however, with having it's database password removed, and > didn't seem to mind the db which had been converted up and back down again. > > I presume that despite my having Access 2000 installed on this machine, > it's using a lesser version runtime routines? (It's much the same error if > I try to open the later version db in Access 97.) > > Thanks, > > Rob > > > > > At 03:43 15/11/2004, Sam Moffatt wrote: > > >In Access 2000, there is an option under the tools menu option to save > >it as an older version of the database, so you don't need access 97 to > >save databases in that format. Perhaps try using that. Also, what > >language is your windows app running? if you've got access 2000 > >running, it shouldn't have any issues. and can you change the windows > >app? > > > >Sam > > > > > >On Mon, 15 Nov 2004 01:58:46 +0000, Rob <ro...@ir...> wrote: > > > Hi! > > > > > > I've been working on an ap in php, accessing an access database via odbc & > > > mdbtools. > > > > > > The database is actually from windows application, and appears to be using > > > the jet 3.51 engine for access. As it was password protected (but I know > > > the password) I loaded it into Access 2000, converted to new format, > > > cleared the password, and saved it out as a temporary copy. mdb tools > > > works fine on this copy, but I guess it's now in Jet 4 format. The windows > > > app certainly objects to it anyway. > > > > > > I finally got around to installing office 97 on a pc so I could remove the > > > password from the database without converting the format. This I managed > > > to do, and the windows app is happy with it, however mdb tools refuses to > > > return any data from it. Even mdb-tables just prints a blank line and > > exits. > > > > > > mdb-tables does however list the tables in Northwind.mdb samed from the > > > office 97 install. > > > > > > I'm using 0.6pre1, downloaded Nov 1st, running on FreebSD 4.10-STABLE #0. > > > > > > Is there anything else I can try, do, tell you, to solve this? > > > > > > Thanks, > > > > > > Rob. > > |
26 messages has been excluded from this view by a project administrator.
