mdbtools-dev

RE: [mdb-dev] inporting data to mysql

[Gary S. <ga...@pr...>]

If you have access to the Win platform install the MySQL ODBC drive and =
just create a query.  I know this has nothing to do with MDB-DEV app but =
it's simple and fast.

Gary Smith

=20

 -----Original Message-----
From: 	txemi [mailto:tx...@eu...]=20
Sent:	Saturday, September 06, 2003 3:24 PM
To:	mdb...@li...
Subject:	[mdb-dev] inporting data to mysql


Hi, I am trying to export data from microsoft access to mysql.

I am doing it exporting text data from Microsoft Access or mdbtools to
text files and then inporting it with LOAD DATA from mysql. The problem
is than I cannot find a combination of field deparator, escape secuence,
etc... for not loosing data in the transfer.

Could anybody provide a hint to do it in other way? Perhaps using odbc
or something like that?

--=20
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] inporting data to mysql

[txemi <tx...@eu...>]

Hi, I am trying to export data from microsoft access to mysql.

I am doing it exporting text data from Microsoft Access or mdbtools to
text files and then inporting it with LOAD DATA from mysql. The problem
is than I cannot find a combination of field deparator, escape secuence,
etc... for not loosing data in the transfer.

Could anybody provide a hint to do it in other way? Perhaps using odbc
or something like that?

-- 
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org

[mdb-dev] inporting data to mysql

[txemi <tx...@eu...>]

Hi, I am trying to export data from microsoft access to mysql.

I am doing it exporting text data from Microsoft Access or mdbtools to
text files and then inporting it with LOAD DATA from mysql. The problem
is than I cannot find a combination of field deparator, escape secuence,
etc... for not loosing data in the transfer.

Could anybody provide a hint to do it in other way? Perhaps using odbc
or something like that?

-- 
 ______________________________
< hola, soy una firma horrible >
 ------------------------------
        \   ^__^
         \  (oo)\_______
            (__)\       )\/\
                ||----w |
                ||     ||

txemi <tx...@eu...>
web: http://txemi.webhop.org
mirror: http://txemi2.webhop.org

[mdb-dev] mdbtools, unixodbc and openoffice.org

[David W. <dav...@ya...>]

Hi,

Scanning through the archives it looks like most of you talk about serious 
code stuff so I hope this is not too out of place.

I have unixodbc working nicely with mysql and have mdbtools installed and 
can use mdb-sql and mdb-export etc. from the command line.  I have set up 
an access database in odbc.ini and odbcinst.ini (as shown below) and I can 
add the Access database as a data source in OpenOffice.org and it can find 
the library okay.  It does not show the tables however or allow me to issue 
SQL statements.  Should it be possible to do this or am I expecting too 
much at this stage?  I can do what I need to do using mdb-export and then 
put the data into MySQL but it would be nice to be able to get to the 
Access tables directly.  Any tips?

Thanks.

Dave

odbc.ini:
[MSAccess] Description = Microsoft Access Driver = MSAccess
Database = /home/dave/tmp/test.mdb
Servername = localhost UserName = Password = Port = 5432

odbcinst.ini: [MSAccess] Description = MDB Tools ODBC drivers Driver = 
/usr/local/lib/libmdbodbc.so.0 Setup = FileUsage = 1

[mdb-dev] ODBC parse error

[<tro...@mu...>]

I downloaded and installed the RPMs vers. 0.5-1 following the instructions =
on=20
the Installation Guide.

The first problem I found was a dependency problem during the installation =
of=20
"mdbtools-0.5-1.i386.rpm". Although the library "libreadline.so.4" was=20
installed in the directory "/lib", I got the error message "libreadline.so.=
4=20
is needed by mdbtools-0.5-1". I even upgraded from "readline-4.3-4mdk" to=20
"libreadline4-4.3-7mdk", but I got the same error. So, in the end, I=20
installed the RPM with the "--nodeps" option.

I checked the installation making an SQL query with "mdb-sql", which worked=
=20
fine. Then I had no trouble at all installing "mdbtools-devel-0.5-1.i386.rp=
m"=20
and "mdbtools-odbc-0.5-1.i386.rpm". I then configured my "odbc.ini" file.

The second and main problem appeared when testing the ODBC connection. I=20
always got a "parse error". For example:

        [jose@localhost jose]$ isql biblio
        +---------------------------------------+
        | Connected!                            |
        |                                       |
        | sql-statement                         |
        | help [tablename]                      |
        | quit                                  |
        |                                       |
        +---------------------------------------+
        SQL> select version();
        Error at Line : parse error near (
        [ISQL]ERROR: Could not SQLExecute
        SQL>

I get similar errors when trying to access the database through ODBC from=20
other applications, such as DataManager or OpenOffice.org. I also tried=20
building and installing the source, but I still had the same problem with t=
he=20
ODBC driver. I also upgraded the unixODBC packages.

My system has a Pentium III at 600Mz, 128MB RAM and Mandrake 9.1.

Any ideas?=20
Thanks a lot,
Jos=E9 Troncoso

Re: [mdb-dev] Tools build but segfault

[Robert J G. <rj...@at...>]

Yes, I'd very much like to try your rpm, if you're happy to mail
it (BTW, to me, not to the list!)

I'm interested that you made mdbtools build with glib-1.2.10 -- the
configure script I have refuses to use anything less than 2.0

Thanks,

Bob G

On Wed, 20 Aug 2003, Luis Miguel Cruz Miranda wrote:

> mdb-schema is running ok here for the momment.
> 
> I built mdbtools with...
> 
 <snip>
> glib-1.2.10-5
 <snip>
> I used a RH 7.3 and I have the rpm created so I can send you it if you want 
> (around 780Kb)
> 
> See you :)
> 

Re: [mdb-dev] Tools build but segfault

[Luis M. C. M. <lu...@b2...>]

mdb-schema is running ok here for the momment.

I built mdbtools with...

# rpm -qa | grep gcc
gcc-2.96-113
gcc-g77-2.96-113
gcc-c++-2.96-113

# rpm -qa | grep glib
glib-1.2.10-5
glibc-2.2.5-43
glib2-devel-2.0.1-2
glib-devel-1.2.10-5
glib2-2.0.1-2
glibc-kernheaders-2.4-7.16
glibc-devel-2.2.5-43
glibc-common-2.2.5-43

I used a RH 7.3 and I have the rpm created so I can send you it if you wa=
nt=20
(around 780Kb)

See you :)


At 12:47 20/08/2003 +0100, Robert J Gautier wrote:
>I've built mdbtools-0.5 on my Red Hat 7.3 system, and I can't seem to ge=
t
>them to do much.  Even on the Office97 'Northwind' database, although I
>can see the schema (mdb-schema) I can't export any data.  And on the mai=
n
>database I need to dump, I can't even dump the schema without getting
>a segfault.
>
>I'd appreciate any suggestions as to where to start trying to find the
>problem.  I've built the tools with MDB_DEBUG turned on and one odd
>thing is that I keep getting number of columns *way* more than 256:
>258, even in the tens of thousands...
>
>I've used gcc 2.96 and glib-2.2.2 -- could it be that my build is wrong?
>
>Thanks in advance,
>
>Bob G
>
>
>
>
>-------------------------------------------------------
>This SF.net email is sponsored by Dice.com.
>Did you know that Dice has over 25,000 tech jobs available today? From
>careers in IT to Engineering to Tech Sales, Dice has tech jobs from the
>best hiring companies. http://www.dice.com/index.epl?rel_code=3D104
>_______________________________________________
>mdbtools-dev mailing list
>mdb...@li...
>https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Luis Miguel Cruz Miranda.               |       B2B INTEGRAL, S.A.
CCNA - Systems Administrator            |       Pol. Ind. de Asipo
                                         |       C/A - Parcela 86-C
Tel: +34 902 506 605                    |       33.428 - CAYES - LLANERA
Fax:+34 985 980 794                     |       ASTURIAS (ESPA=D1A/SPAIN)

AVISO SOBRE CONFIDENCIALIDAD: Este mensaje y en su caso, sus anexos, se
dirige exclusivamente a su destinatario, por poder contener informaci=F3n
confidencial sometida a secreto profesional o cuya divulgaci=F3n est=E9
prohibida en virtud de la legislaci=F3n vigente, se informa a qui=E9n lo
recibiera sin ser el destinatario o persona autorizada por =E9ste, que la
informaci=F3n contenida en el mismo es reservada y su utilizaci=F3n o
divulgaci=F3n con cualquier fin est=E1 prohibida. Si ha recibido este
documento por error, le rogamos que nos lo comunique a la mayor brevedad
posible y proceda a su destrucci=F3n. =20

[mdb-dev] Tools build but segfault

[Robert J G. <rj...@at...>]

I've built mdbtools-0.5 on my Red Hat 7.3 system, and I can't seem to get 
them to do much.  Even on the Office97 'Northwind' database, although I
can see the schema (mdb-schema) I can't export any data.  And on the main
database I need to dump, I can't even dump the schema without getting
a segfault.

I'd appreciate any suggestions as to where to start trying to find the 
problem.  I've built the tools with MDB_DEBUG turned on and one odd
thing is that I keep getting number of columns *way* more than 256:
258, even in the tens of thousands...

I've used gcc 2.96 and glib-2.2.2 -- could it be that my build is wrong?

Thanks in advance,

Bob G

Re: [mdb-dev] undelete a deleted record from a mdb?

[klemens z. <zw...@vo...>]

hi,
       =20
        yes, i've read that too.
        my tables have some 'memo' fields, so i was hoping that
        something has survived...
        but in fact it looks not good :(
        some export stalled (took cpu for minutes without doing anything
        in output), some segfaulted. seems to be 'quite dirty' inside.
       =20
        So i realy start to think to move the DB-part to mysql since
        they have a update-log (
        http://www.mysql.com/doc/en/Update_log.html ) which might rescue
        in such a case.

.klemens

On Mon, 2003-08-18 at 23:54, Tony Toews wrote:
> >         I'll give another report if I success to get-back some of
> > the
> >         deleted data... :)
>=20
> FWIW Peter Miller is well known for being able to recover deleted
> MDBs.
>=20
> by Peter Miller of PK Solutions
> Question: A user at work has accidentally erased the contents of an
> Access MDB. The file size is still as it originally was. Is there
> *any* way of getting the data back?
>=20
> Answer: No, not really. Although the space used to store the deleted
> records remains unchanged, the actual contents of that storage are not
> just deleted, but duplicated in part. Typically, only about one out of
> every twenty records is recoverable, for technical reasons. Basically,
> although the undeleting is easy enough, Access/Jet copy the first
> deleted record on a page over the remaining deleted records on hat
> page. Typically there are twenty or more records per page, and hence
> the 95%+ data loss.
>=20
> That said, if the table had been deleted, rather than just its
> records, it would indeed be recoverable. In fact, if all tables had
> been deleted, they would all be recoverable. But records deleted from
> a table that is not deleted are indeed toast, or at least
> predominantly so.
>=20
> -----
> Tony Toews, Microsoft Access MVP
> Microsoft Access Links, Hints, Tips & Accounting Systems at
>    http://www.granite.ab.ca/accsmstr.htm
--=20
klemens zwischenbrugger <zw...@vo...>

Re: [mdb-dev] undelete a deleted record from a mdb?

[Tony T. <tt...@mv...>]

>         I'll give another report if I success to get-back some of the
>         deleted data... :)

FWIW Peter Miller is well known for being able to recover deleted MDBs.

Make that corrupted MDBs.

Tony

Re: [mdb-dev] undelete a deleted record from a mdb?

[Tony T. <tt...@mv...>]

>         I'll give another report if I success to get-back some of the
>         deleted data... :)

FWIW Peter Miller is well known for being able to recover deleted MDBs.

by Peter Miller of PK Solutions
Question: A user at work has accidentally erased the contents of an Access 
MDB. The file size is still as it originally was. Is there *any* way of 
getting the data back?

Answer: No, not really. Although the space used to store the deleted 
records remains unchanged, the actual contents of that storage are not just 
deleted, but duplicated in part. Typically, only about one out of every 
twenty records is recoverable, for technical reasons. Basically, although 
the undeleting is easy enough, Access/Jet copy the first deleted record on 
a page over the remaining deleted records on hat page. Typically there are 
twenty or more records per page, and hence the 95%+ data loss.

That said, if the table had been deleted, rather than just its records, it 
would indeed be recoverable. In fact, if all tables had been deleted, they 
would all be recoverable. But records deleted from a table that is not 
deleted are indeed toast, or at least predominantly so.

-----
Tony Toews, Microsoft Access MVP
Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm

Re: [mdb-dev] undelete a deleted record from a mdb?

[klemens z. <zw...@vo...>]

hi

        ok, at least I got it to compile.
        Some libs was missig ( libglibc and all the gnome2 relevant ones
        ), and in configure.in ( on a fresh debian/unstable/i386) it
        doesn't like the 'src/Makefile' and 'include/Makefile' in last
        line. After removing it compiled fine; also i had to copy the
        'config.h.in' to the 'include/'  - dir...
       =20
        I'll give another report if I success to get-back some of the
        deleted data... :)

so long,
.klemens


On Thu, 2003-08-14 at 03:21, klemens zwischenbrugger wrote:
> Hi,
>=20
>   hm, even with a fresch debian-unstable getting compile-errors when=20
>   trying compile using autogen.sh
>=20
>   any ideas ?
>=20
> .klemens
>=20
>=20
>=20
> ---snip---
> processing .
> Running libtoolize...
> You should add the contents of `/usr/share/aclocal/libtool.m4' to
> `aclocal.m4'.
> Running aclocal  ...
> aclocal: configure.in: 88: macro `AM_PATH_GLIB_2_0' not found in library
> Running autoheader...
> configure.in:130: error: `src/Makefile' is already registered with
> AC_CONFIG_FILES.
> autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
> configure.in:130: the top level
> autom4te: /usr/bin/m4 failed with exit status: 1
> autoheader: /usr/bin/autom4te failed with exit status: 1
> Running automake --gnu  ...
> configure.in: 4: required file `include/config.h.in' not found
> configure.in: 4: required file `include/config.h.in' not found
> Running autoconf ...
> configure.in:130: error: `src/Makefile' is already registered with
> AC_CONFIG_FILES.
> autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
> configure.in:130: the top level
> autom4te: /usr/bin/m4 failed with exit status: 1
> Running ./configure ...
> ./autogen.sh: line 148: ./configure: No such file or directory
> ---snap---

[mdb-dev] New install

[Reaz B. <bak...@ro...>]

Hello

I just installed this on Debian but I can't figure out how to use it.
Are there any documents that explain in detail how?

 

I'm trying to build a web interface for an mdb database under Linux.  Is
it better to just convert the mdb to MySQL.  If it is, is there any
program that will allow me to do this?  The conversion.

 

Also how do I start the interface for this?

 

Sorry about all the questions.

 

Reaz 

Re: [mdb-dev] Seg fault with an MDB

[Andrew S. <and...@ed...>]

Paul Makepeace wrote:

> Hi,
>
> Reading the database from http://download.travlang.com/files/swa.zip
> (110K, 355K unzipped) generates a SEGV. A random sample of other
> dictionary files (english, esperanto, the two big ones) also fault.
>
>  
>
Your database seems to have been produced with a version of Access older 
than Access 97. I think mdb-tools only supports Access 97 and Access 
2000. I tried converting it to Access 97 format and it seems to work fine.

Andrew Seales

[mdb-dev] Seg fault with an MDB

[Paul M. <sou...@pa...>]

Hi,

Reading the database from http://download.travlang.com/files/swa.zip
(110K, 355K unzipped) generates a SEGV. A random sample of other
dictionary files (english, esperanto, the two big ones) also fault.

This is Debian/testing, GCC version 3.3 for i386.

mdb-tables swa.mdb:

This GDB was configured as "i386-linux"...
Core was generated by `mdb-tables swa.mdb'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /usr/local/lib/libmdb.so.0...done.
Loaded symbols for /usr/local/lib/libmdb.so.0
Reading symbols from /usr/lib/libglib-2.0.so.0...done.
Loaded symbols for /usr/lib/libglib-2.0.so.0
Reading symbols from /lib/libncurses.so.5...done.
Loaded symbols for /lib/libncurses.so.5
Reading symbols from /lib/libc.so.6...done.
Loaded symbols for /lib/libc.so.6
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
#0  0x40017127 in mdb_bind_column (table=0x804ca68, col_num=1, bind_ptr=0xbffff930) at data.c:39
39              col=g_ptr_array_index(table->columns, col_num - 1);
(gdb) bt
#0  0x40017127 in mdb_bind_column (table=0x804ca68, col_num=1, bind_ptr=0xbffff930) at data.c:39
#1  0x40014f5f in mdb_read_catalog (mdb=0x804a148, objtype=1) at catalog.c:72
#2  0x08048913 in main (argc=2, argv=0xbffffb74) at mdb-tables.c:66

If you can't reproduce this & I can help any other way, let me know.

Cheers,
Paul

-- 
Paul Makepeace ....................................... http://paulm.com/

"If words would flow like water, then insurance can fail."
   -- http://paulm.com/toys/surrealism/

Re: [mdb-dev] undelete a deleted record from a mdb?

[klemens z. <zw...@vo...>]

Hi,

  hm, even with a fresch debian-unstable getting compile-errors when=20
  trying compile using autogen.sh

  any ideas ?

.klemens



---snip---
processing .
Running libtoolize...
You should add the contents of `/usr/share/aclocal/libtool.m4' to
`aclocal.m4'.
Running aclocal  ...
aclocal: configure.in: 88: macro `AM_PATH_GLIB_2_0' not found in library
Running autoheader...
configure.in:130: error: `src/Makefile' is already registered with
AC_CONFIG_FILES.
autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
configure.in:130: the top level
autom4te: /usr/bin/m4 failed with exit status: 1
autoheader: /usr/bin/autom4te failed with exit status: 1
Running automake --gnu  ...
configure.in: 4: required file `include/config.h.in' not found
configure.in: 4: required file `include/config.h.in' not found
Running autoconf ...
configure.in:130: error: `src/Makefile' is already registered with
AC_CONFIG_FILES.
autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
configure.in:130: the top level
autom4te: /usr/bin/m4 failed with exit status: 1
Running ./configure ...
./autogen.sh: line 148: ./configure: No such file or directory
---snap---

On Wed, 2003-08-13 at 20:59, Brian Bruns wrote:
> Not by default, but you could try the following.  First export=20
> CFLAGS=3D"-DSLOW_READ" and run configure.  Next edit src/libmdb/mem.c in=20
> mdb_alloc_tabledef() add a line after the memset like:
>=20
> table->noskip_del =3D 1;
>=20
> This will theoretically work, but I think you'll need a recent CVS copy o=
f=20
> MDB Tools, I don't think the last release will cut it.
>=20
> On 13 Aug 2003, klemens zwischenbrugger wrote:
>=20
> > Hi,
> >        =20
> >         is there a chance to undelete/get back some deleted records
> >         using mdbtools ?
> >         As I know, there is done some 4k-block-copy inside the record
> >         when deleting - maybee too much in my case.
> >        =20
> >         but anyway i like to give em a try - if possible...
> >        =20
> >         anywone know if possilbe with mdbtool ?=20
> >        =20
> > best regards,
> > .klemens
> >=20
> >=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email sponsored by: Free pre-built ASP.NET sites including
> Data Reports, E-commerce, Portals, and Forums are available now.
> Download today and enter to win an XBOX or Visual Studio .NET.
> http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/=
01
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
--=20
klemens zwischenbrugger <zw...@vo...>

[mdb-dev] Autogen.sh fails on Solaris 7

[Celeste S. B. <csb...@ci...>]

I've succeeded in downloading the CVS version of mdbtools. I've tried
repeatedly to get a ./configure file by running autogen.sh. I've failed.

I have the most recent versions of autoconf, automake, m4, and libtool.

The printout I get is as follows:

geobase1{csburris}2: ./autogen.sh
**Warning**: I am going to run `configure' with no arguments.
If you wish to pass any to it, please specify them on the
`./autogen.sh' command line.

processing .
Running libtoolize...
You should update your `aclocal.m4' by running aclocal.
Running aclocal  ...
Running autoheader...
configure.in:130: error: `src/Makefile' is already registered with
AC_CONFIG_FILES.
autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
configure.in:130: the top level
autom4te: /usr/local/bin/m4 failed with exit status: 1
autoheader: /usr/local/bin/autom4te failed with exit status: 1
Running automake --gnu  ...
configure.in:130: error: `src/Makefile' is already registered with
AC_CONFIG_FILES.
autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
configure.in:130: the top level
autom4te: /usr/local/bin/m4 failed with exit status: 1
configure.in: `AM_INIT_AUTOMAKE' must be used
automake: your implementation of AM_INIT_AUTOMAKE comes from an
automake: old Automake version.  You should recreate aclocal.m4
automake: with aclocal and run automake again.
automake: no `Makefile.am' found or specified
Running autoconf ...
configure.in:130: error: `src/Makefile' is already registered with
AC_CONFIG_FILES.
autoconf/status.m4:844: AC_CONFIG_FILES is expanded from...
configure.in:130: the top level
autom4te: /usr/local/bin/m4 failed with exit status: 1
Running ./configure ...
./autogen.sh: ./configure: not found


Has anyone else encountered this problem? Is there a workaround?

Celeste Suliin Burris
Systems Administrator
Tacoma Economic Development Dept.
591-5093
csb...@ci...

Re: [mdb-dev] undelete a deleted record from a mdb?

[klemens z. <zw...@vo...>]

hi,

        first - big thanks, that gives hope.
       =20
        2nd - seems that debian-woody has some old versions of the
        required programs - i got errors when i run autogen.sh against
        current cvs;
       =20
        so - just started to upgrade some on my play-arround-boxes to
        debian-unstable.
       =20
       =20
.klemens

On Wed, 2003-08-13 at 20:59, Brian Bruns wrote:
> Not by default, but you could try the following.  First export=20
> CFLAGS=3D"-DSLOW_READ" and run configure.  Next edit src/libmdb/mem.c in=20
> mdb_alloc_tabledef() add a line after the memset like:
>=20
> table->noskip_del =3D 1;
>=20
> This will theoretically work, but I think you'll need a recent CVS copy o=
f=20
> MDB Tools, I don't think the last release will cut it.
>=20
> On 13 Aug 2003, klemens zwischenbrugger wrote:
>=20
> > Hi,
> >        =20
> >         is there a chance to undelete/get back some deleted records
> >         using mdbtools ?
> >         As I know, there is done some 4k-block-copy inside the record
> >         when deleting - maybee too much in my case.
> >        =20
> >         but anyway i like to give em a try - if possible...
> >        =20
> >         anywone know if possilbe with mdbtool ?=20
> >        =20
> > best regards,
> > .klemens
> >=20
> >=20
--=20
klemens zwischenbrugger <zw...@vo...>

Re: [mdb-dev] undelete a deleted record from a mdb?

[Brian B. <ca...@ai...>]

Not by default, but you could try the following.  First export 
CFLAGS="-DSLOW_READ" and run configure.  Next edit src/libmdb/mem.c in 
mdb_alloc_tabledef() add a line after the memset like:

table->noskip_del = 1;

This will theoretically work, but I think you'll need a recent CVS copy of 
MDB Tools, I don't think the last release will cut it.

On 13 Aug 2003, klemens zwischenbrugger wrote:

> Hi,
>         
>         is there a chance to undelete/get back some deleted records
>         using mdbtools ?
>         As I know, there is done some 4k-block-copy inside the record
>         when deleting - maybee too much in my case.
>         
>         but anyway i like to give em a try - if possible...
>         
>         anywone know if possilbe with mdbtool ? 
>         
> best regards,
> .klemens
> 
> 

[mdb-dev] undelete a deleted record from a mdb?

[klemens z. <zw...@vo...>]

Hi,
       =20
        is there a chance to undelete/get back some deleted records
        using mdbtools ?
        As I know, there is done some 4k-block-copy inside the record
        when deleting - maybee too much in my case.
       =20
        but anyway i like to give em a try - if possible...
       =20
        anywone know if possilbe with mdbtool ?=20
       =20
best regards,
.klemens

--=20
klemens zwischenbrugger <zw...@vo...>

Re: [mdb-dev] negative value instead of positive one

[Marc D. <mar...@gm...>]

Am Son, 2003-08-10 um 12.01 schrieb Marc Deichmann:
> Here is an example out of the tables.=20
> Right (converted csv-file with Access):
> 6;2000;0;10;10;" ";3183460512;3229481873;0;0
> Wrong (converted csv-file with mdb-export):
> 6;2000;0;10;10;" ";-00000001111506784;-00000001065485423;0;0

Just tried to convert the 3183460512 to hex. My galculator says "inf".
Could it be that this problem is an overflow error?

Bye,
Marc.

--=20
 mailto:ma...@cr... | http://www.creative-sadness.de
-----------------------------------------------------------------
Tyr Anasazi: I thought you said the prison colony would be here.
Seamus Harper: I did! The coordinates lead right here!
Tyr Anasazi: I can spot planets. They're large. I have good eyes.
    --- "Andromeda" (2000)

[mdb-dev] negative value instead of positive one

[Marc D. <mar...@gm...>]

Hi!

I have a serious (for me) problem and it seems to be that the problem is
somewhere in the mdb-tools. :-(
I wrote a perl script to fetch values out of a Access database and there
are negative values where there shouldn't be.

The thing is the following. I am importing a database from Visual Fox
Pro to Access and the using the mdb-tools to convert the data to
csv-files. The switching from positive to negative is happening between
the Access database and the mdbtools.=20

When I am looking at the data with Access the number is correct. When I
am using the gmdb2 tool the same field is negative (also in the
csv-file).

Here is an example out of the tables.=20
Right (converted csv-file with Access):
6;2000;0;10;10;" ";3183460512;3229481873;0;0
Wrong (converted csv-file with mdb-export):
6;2000;0;10;10;" ";-00000001111506784;-00000001065485423;0;0

I could manually convert the Access tables in Windows to csv tables.
This is okay for some tables but for more than 100 tables it is a
pain...

Could anyone please help me?

Thanks a lot in advance,
Marc.

--=20
 mailto:ma...@cr... | http://www.creative-sadness.de
--
Trance Gemini: Exactly where on the body is the moneymaker located?
    -- "Andromeda" (2000)

[mdb-dev] status of David Mansfield's patches

[Ilya S. <ily...@na...>]

Just wondering, did David's patches make it into CVS?

Any chances of seeing 0.5.1 release in nearest future with those patches?

Many thanks,
Ilya

Re: [mdb-dev] Re: MDB-Tools and Perl

[Brian B. <ca...@ai...>]

Hi all,

First apologies for not keeping up with mdbtools lately, two jobs and two 
children is taking a toll.  If people have outstanding patches, *please* 
post them to sourceforge, so a) I don't lose them and b) others can apply 
them in the meantime.

On the perl front, the original idea was to use DBD::ODBC with the MDB 
Tools ODBC driver to accomplish this.  I got something working when I 
tried it oh so long ago.

After I move next friday and again have DSL, I'm hoping to have enough 
time to apply patches and put out a release sometime in September.

Cheers,

Brian 

On Wed, 6 Aug 2003, Kyle R. Burton wrote:

> > It sure would be nice if someone wrote a module and posted it to CPAN (hint,
> > hint)
> 
> Ok.
> 
> It'm not posting this to CPAN, but I just wrote up a quick hack that 
> rides on top of mdbtools:
> 
>   http://www.neverlight.com/~mortis/mdbtools/Mdbtools-0.01.readme
>   http://www.neverlight.com/~mortis/mdbtools/Mdbtools-0.01.tar.gz
> 
> I also put up a copy of the 0.5rc2 sources with my patches applied
> in case anyone wants at them:
> 
>   http://www.neverlight.com/~mortis/mdbtools/mdbtools-0.5rc2-krb.tar.gz
> 
> Hopefully this will be useful to someone...
> 
> Kyle R. Burton
> 
> 
> 

Re: [mdb-dev] Re: MDB-Tools and Perl

[Kyle R. B. <mo...@vo...>]

> It sure would be nice if someone wrote a module and posted it to CPAN (hint,
> hint)

Ok.

It'm not posting this to CPAN, but I just wrote up a quick hack that 
rides on top of mdbtools:

  http://www.neverlight.com/~mortis/mdbtools/Mdbtools-0.01.readme
  http://www.neverlight.com/~mortis/mdbtools/Mdbtools-0.01.tar.gz

I also put up a copy of the 0.5rc2 sources with my patches applied
in case anyone wants at them:

  http://www.neverlight.com/~mortis/mdbtools/mdbtools-0.5rc2-krb.tar.gz

Hopefully this will be useful to someone...

Kyle R. Burton


-- 

------------------------------------------------------------------------------
Wisdom and Compassion are inseparable.
        -- Christmas Humphreys
mo...@vo...                            http://www.voicenet.com/~mortis
------------------------------------------------------------------------------