mdbtools-dev

Re: [mdb-dev] compile error for 0.6pre1

[Jeff S. <why...@ya...>]

Actually, the correct fix (which is has been in CVS since April 2005 (we ju=
st haven't had a release since then)=0Ais to remove 'static' from the defin=
ition in src/libmdb/backend.c.=0A=0A -- Jeff Smith=0A=0A----- Original Mess=
age ----=0AFrom: Rikul Patel <rik...@gm...>=0ATo: mdbtools-dev@list=
s.sourceforge.net=0ASent: Monday, September 25, 2006 3:30:11 PM=0ASubject: =
[mdb-dev] compile error for 0.6pre1=0A=0AThere is a "static GHashTable *mdb=
_backends" declared in=0Asrc/libmdb/backend.c  but there is also a "extern =
GHashTable=0A*mdb_backends" in include/mdbtools.h .  This caused compile to=
 fail on=0A Mac OS X 10.4.7 with "gcc version 4.0.1 (Apple Computer, Inc. b=
uild=0A5363)" I commented out the extern declaration in mdbtools.h and it=
=0Acompiled fine.=0A=0A----------------------------------------------------=
---------------------=0ATake Surveys. Earn Cash. Influence the Future of IT=
=0AJoin SourceForge.net's Techsay panel and you'll get the chance to share =
your=0Aopinions on IT & business topics through brief surveys -- and earn c=
ash=0Ahttp://www.techsay.com/default.php?page=3Djoin.php&p=3Dsourceforge&CI=
D=3DDEVDEV=0A_______________________________________________=0Amdbtools-dev=
 mailing list=0Am...@li...=0Ahttps://lists.sourcefo=
rge.net/lists/listinfo/mdbtools-dev=0A=0A=0A=0A=0A

[mdb-dev] Created an rpm file

[Steve Q. <st...@tr...>]

Guys,

I created an RPM file for mdbtools 0.6 for Red Hat Enterprise 4. I did 
this because I couldn't find a rpm for this distribution. Anyway, I'm 
trying to upload it to rpmfind.net, but it says that it doesn't accept 
submissions and to instead "upload to one of the ftp sites that I 
mirror". However, it neglects to tell me which ftp sites it mirrors. Can 
anyone tell me where I can upload this thing?

Reason I am doing this is that I had a hard time getting it to compile 
in Red Hat enterprise and i want to spare other people of my agony.

- Steve

[mdb-dev] compile error for 0.6pre1

[Rikul P. <rik...@gm...>]

There is a "static GHashTable *mdb_backends" declared in
src/libmdb/backend.c  but there is also a "extern GHashTable
*mdb_backends" in include/mdbtools.h .  This caused compile to fail on
 Mac OS X 10.4.7 with "gcc version 4.0.1 (Apple Computer, Inc. build
5363)" I commented out the extern declaration in mdbtools.h and it
compiled fine.

[mdb-dev] [ mdbtools-Bugs-1563144 ] make errs on backend declaration

[SourceForge.net <no...@so...>]

Bugs item #1563144, was opened at 2006-09-21 13:38
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1563144&group_id=2294

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: build  tools
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Nobody/Anonymous (nobody)
Summary: make errs on backend declaration

Initial Comment:
Hello,

configure runs fine. Make errs with the following on
Novell SLED10. mo...@ro...

sled10:~/Documents/mdbtools-0.6pre1 # make
Making all in src
make[1]: Entering directory
`/root/Documents/mdbtools-0.6pre1/src'
Making all in libmdb
make[2]: Entering directory
`/root/Documents/mdbtools-0.6pre1/src/libmdb'
if /bin/sh ../../libtool --mode=compile gcc
-DHAVE_CONFIG_H -I. -I. -I../../include 
-I../../include -I/opt/gnome/include/glib-2.0
-I/opt/gnome/lib/glib-2.0/include     -g -O2 -DSQL -MT
backend.lo -MD -MP -MF ".deps/backend.Tpo" \
  -c -o backend.lo `test -f 'backend.c' || echo
'./'`backend.c; \
then mv -f ".deps/backend.Tpo" ".deps/backend.Plo"; \
else rm -f ".deps/backend.Tpo"; exit 1; \
fi
 gcc -DHAVE_CONFIG_H -I. -I. -I../../include
-I../../include -I/opt/gnome/include/glib-2.0
-I/opt/gnome/lib/glib-2.0/include -g -O2 -DSQL -MT
backend.lo -MD -MP -MF .deps/backend.Tpo -c backend.c 
-fPIC -DPIC -o .libs/backend.o
backend.c:31: error: static declaration of
‘mdb_backends’ follows non-static declaration
../../include/mdbtools.h:150: error: previous
declaration of ‘mdb_backends’ was here
make[2]: *** [backend.lo] Error 1
make[2]: Leaving directory
`/root/Documents/mdbtools-0.6pre1/src/libmdb'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory
`/root/Documents/mdbtools-0.6pre1/src'
make: *** [all-recursive] Error 1
sled10:~/Documents/mdbtools-0.6pre1 #



----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=102294&aid=1563144&group_id=2294

Re: [mdb-dev] mdb-sql produces Segmentation fault on AMD Opteron

[Sam M. <pa...@gm...>]

I'd almost wonder if it isn't a mdb issue but an iconv issue. Have you
recompiled mdb with debugging and no stripping enabled? also
installing debugging libraries (-dbg packages where available) and it
should give some more information as well :)

Sam

On 18/09/06, Niels Tolstrup <nt...@ex...> wrote:
>
>
>
> Dear Sirs,
>
>  I would like to use mdb-sql to query an MS Access database, but I get an
> Segmentation fault.
>
>  I am using a 64 bit AMD Opteron with debian sarge and
> mdbtools_0.5.99.0.6pre1.0.20050409-1_amd64
>
>  I seems that my problem is related to running on the Opteron, because I am
> running the exact same version of mdbtools on the same debian distribution
> on a 32 bit Intel processor without any problems.
>
>  The command looks like this:
>  nt@betelgeuse:~$ echo 'select "EQ No",Sequence,"Oligo Name" from "Oligo
> Synthesis"' > my_query
>  nt@betelgeuse:~$ mdb-sql oligo.mdb < my_query
>
>  Segmentation fault
>
>  For debugging I tried:
>
>  nt@betelgeuse:~$ gdb mdb-sql
>  GNU gdb 6.3-debian
>  Copyright 2004 Free Software Foundation, Inc.
>  GDB is free software, covered by the GNU General Public License, and you
> are
>  welcome to change it and/or distribute copies of it under certain
> conditions.
>  Type "show copying" to see the conditions.
>  There is absolutely no warranty for GDB.  Type "show warranty" for details.
>  This GDB was configured as "x86_64-linux"...(no debugging symbols found)
>  Using host libthread_db library "/lib/libthread_db.so.1".
>
>  (gdb) run oligo.mdb < my_query
>  Starting program: /usr/bin/mdb-sql oligo.mdb < my_query
>  (no debugging symbols found)
>  (no debugging symbols found)
>  (no debugging symbols found)
>  (no debugging symbols found)
>  (no debugging symbols found)
>  (no debugging symbols found)
>  (no debugging symbols found)
>
>
>  Program received signal SIGSEGV, Segmentation fault.
>  0x00002aaaab0bef32 in __gconv_get_alias_db () from /lib/libc.so.6
>  (gdb) backtrace
>  #0  0x00002aaaab0bef32 in __gconv_get_alias_db () from /lib/libc.so.6
>  #1  0x00002aaaab0b9459 in iconv_close () from /lib/libc.so.6
>  #2  0x00002aaaab0b8a57 in iconv () from /lib/libc.so.6
>  #3  0x00002aaaaabcdec8 in mdb_unicode2ascii () from /usr/lib/libmdb.so.1
>  #4  0x00002aaaaabc7b57 in mdb_read_columns () from /usr/lib/libmdb.so.1
>  #5  0x00002aaaaabc6405 in mdb_read_catalog () from /usr/lib/libmdb.so.1
>  #6  0x00002aaaaabc7727 in mdb_read_table_by_name () from
> /usr/lib/libmdb.so.1
>  #7  0x00002aaaaacd7673 in mdb_sql_select () from /usr/lib/libmdbsql.so.1
>  #8  0x00002aaaaacd7d84 in yyparse () from /usr/lib/libmdbsql.so.1
>  #9  0x0000000000401555 in ?? ()
>  #10 0x00000000004018dd in ?? ()
>  #11 0x0000000000402292 in ?? ()
>  #12 0x00002aaaab0b8441 in __libc_start_main () from /lib/libc.so.6
>
>
>  I also tried to run mdb-tables, it runs fine on the Intel, but fails on the
> Opteron:
>
>  nt@betelgeuse:~$ gdb mdb-tables
>  GNU gdb 6.3-debian
>  Copyright 2004 Free Software Foundation, Inc.
>  GDB is free software, covered by the GNU General Public License, and you
> are
>  welcome to change it and/or distribute copies of it under certain
> conditions.
>  Type "show copying" to see the conditions.
>  There is absolutely no warranty for GDB.  Type "show warranty" for details.
>  This GDB was configured as "x86_64-linux"...(no debugging symbols found)
>  Using host libthread_db library "/lib/libthread_db.so.1".
>
>  (gdb) run oligo.mdb
>  Starting program: /usr/bin/mdb-tables oligo.mdb
>  (no debugging symbols found)
>  (no debugging symbols found)
>  (no debugging symbols found)
>  (no debugging symbols found)
>
>  Program received signal SIGSEGV, Segmentation fault.
>  0x00002aaaaae7cf32 in __gconv_get_alias_db () from /lib/libc.so.6
>  (gdb) backtrace
>  #0  0x00002aaaaae7cf32 in __gconv_get_alias_db () from /lib/libc.so.6
>  #1  0x00002aaaaae77459 in iconv_close () from /lib/libc.so.6
>  #2  0x00002aaaaae76a57 in iconv () from /lib/libc.so.6
>  #3  0x00002aaaaabcdec8 in mdb_unicode2ascii () from /usr/lib/libmdb.so.1
>  #4  0x00002aaaaabc7b57 in mdb_read_columns () from /usr/lib/libmdb.so.1
>  #5  0x00002aaaaabc6405 in mdb_read_catalog () from /usr/lib/libmdb.so.1
>  #6  0x0000000000400e65 in ?? ()
>  #7  0x00002aaaaae76441 in __libc_start_main () from /lib/libc.so.6
>  #8  0x0000000000400b6a in ?? ()
>  #9  0x00007fffff9bca48 in ?? ()
>
>
>
>  The fact that it runs on the 32 bit machine but not the 64 bit machine, and
> the failing call to iconv() makes me believe that I have a problem with
> integer size.
>
>  Please help me find out how I, using a linux command line tool in debian on
> an Opteron, can query a MS Access database.
>
>  Sincerely yours
>
>  Niels
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job
> easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
>
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
>
>

[mdb-dev] mdb-sql produces Segmentation fault on AMD Opteron

[Niels T. <nt...@ex...>]

Dear Sirs,

I would like to use mdb-sql to query an MS Access database, but I get an =
Segmentation fault.

I am using a 64 bit AMD Opteron with debian sarge and =
mdbtools_0.5.99.0.6pre1.0.20050409-1_amd64

I seems that my problem is related to running on the Opteron, because I =
am running the exact same version of mdbtools on the same debian =
distribution on a 32 bit Intel processor without any problems.

The command looks like this:
nt@betelgeuse:~$ echo 'select "EQ No",Sequence,"Oligo Name" from "Oligo =
Synthesis"' > my_query
nt@betelgeuse:~$ mdb-sql oligo.mdb < my_query

Segmentation fault

For debugging I tried:

nt@betelgeuse:~$ gdb mdb-sql
GNU gdb 6.3-debian
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you =
are
welcome to change it and/or distribute copies of it under certain =
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for =
details.
This GDB was configured as "x86_64-linux"...(no debugging symbols found)
Using host libthread_db library "/lib/libthread_db.so.1".

(gdb) run oligo.mdb < my_query
Starting program: /usr/bin/mdb-sql oligo.mdb < my_query
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)


Program received signal SIGSEGV, Segmentation fault.
0x00002aaaab0bef32 in __gconv_get_alias_db () from /lib/libc.so.6
(gdb) backtrace
#0  0x00002aaaab0bef32 in __gconv_get_alias_db () from /lib/libc.so.6
#1  0x00002aaaab0b9459 in iconv_close () from /lib/libc.so.6
#2  0x00002aaaab0b8a57 in iconv () from /lib/libc.so.6
#3  0x00002aaaaabcdec8 in mdb_unicode2ascii () from /usr/lib/libmdb.so.1
#4  0x00002aaaaabc7b57 in mdb_read_columns () from /usr/lib/libmdb.so.1
#5  0x00002aaaaabc6405 in mdb_read_catalog () from /usr/lib/libmdb.so.1
#6  0x00002aaaaabc7727 in mdb_read_table_by_name () from =
/usr/lib/libmdb.so.1
#7  0x00002aaaaacd7673 in mdb_sql_select () from /usr/lib/libmdbsql.so.1
#8  0x00002aaaaacd7d84 in yyparse () from /usr/lib/libmdbsql.so.1
#9  0x0000000000401555 in ?? ()
#10 0x00000000004018dd in ?? ()
#11 0x0000000000402292 in ?? ()
#12 0x00002aaaab0b8441 in __libc_start_main () from /lib/libc.so.6


I also tried to run mdb-tables, it runs fine on the Intel, but fails on =
the Opteron:

nt@betelgeuse:~$ gdb mdb-tables
GNU gdb 6.3-debian
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you =
are
welcome to change it and/or distribute copies of it under certain =
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for =
details.
This GDB was configured as "x86_64-linux"...(no debugging symbols found)
Using host libthread_db library "/lib/libthread_db.so.1".

(gdb) run oligo.mdb
Starting program: /usr/bin/mdb-tables oligo.mdb
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)
(no debugging symbols found)

Program received signal SIGSEGV, Segmentation fault.
0x00002aaaaae7cf32 in __gconv_get_alias_db () from /lib/libc.so.6
(gdb) backtrace
#0  0x00002aaaaae7cf32 in __gconv_get_alias_db () from /lib/libc.so.6
#1  0x00002aaaaae77459 in iconv_close () from /lib/libc.so.6
#2  0x00002aaaaae76a57 in iconv () from /lib/libc.so.6
#3  0x00002aaaaabcdec8 in mdb_unicode2ascii () from /usr/lib/libmdb.so.1
#4  0x00002aaaaabc7b57 in mdb_read_columns () from /usr/lib/libmdb.so.1
#5  0x00002aaaaabc6405 in mdb_read_catalog () from /usr/lib/libmdb.so.1
#6  0x0000000000400e65 in ?? ()
#7  0x00002aaaaae76441 in __libc_start_main () from /lib/libc.so.6
#8  0x0000000000400b6a in ?? ()
#9  0x00007fffff9bca48 in ?? ()



The fact that it runs on the 32 bit machine but not the 64 bit machine, =
and the failing call to iconv() makes me believe that I have a problem =
with integer size.

Please help me find out how I, using a linux command line tool in debian =
on an Opteron, can query a MS Access database.

Sincerely yours

Niels

Re: [mdb-dev] mdb-export segmentation fault

[Stefan T. [N. Internetdiensten] <st...@ne...>]

Dear Thorpe,

I had the same problem. The problem wasn't really mdbtools, although the
tools perhaps could handle it better, but a defective database.

Before using it, try to find something like "Compress and Repair database"
in the menu (I think it's called that way but I use a Dutch version of
Access).
It's probarly one broken record in a table, well that was it in my case.
Microsoft Access doesn't make a problem of it, and ignores that one record,
but mdbtools does not.

I hope this reply is helpfull for you.

With kind regards,
Stefan Thoolen

-----Oorspronkelijk bericht-----
Van: mdb...@li...
[mailto:mdb...@li...] Namens Thorpe Mayes
Verzonden: maandag 11 september 2006 18:34
Aan: mdb...@li...
Onderwerp: *****SPAM***** [mdb-dev] mdb-export segmentation fault


I ran this from the commmand line:

# mdb-export ok06vf01.mdb ok06vf01

  and got this:

STA,CY,MUNI,CNTY,TWN,WD,PR,BB,PNAME,ODA,ODB,CD,SD,LD,LDS,MM,IIH,LN,MADR1 
,MADR2,MCITY,MSTA,MZIP5,MZIP4,MDC,MCR,MLOT,ADF,COA,RODD,RHNUM,RHSFX,RSTP 
RE,RSTNAME,RSTPOST,RSTTYPE,RAPT,RCITY,RSTA,RZIP5,RDSF,TAC,TEL,TSC,TML,TR 
C,FTC,SR01,SR02,SR03,SR04,SR05,SR06,SR07,SR08,SR09,SR10,SR11,SR12,SR13,S 
R14,SR15,SR16,SR17,SR18,SR19,SR20,SR21,SR22,SR23,SR24,SR25,SR26,SR27,SR2 
8,SR29,SR30,CO01,CO02,CO03,HMIX,ETETH,ETREL,ETGRP,ETLAN,FILL,FILLA,PROCD 
ATE,FILECODE,RNCID1,HTSEQ1,PFX1,FN1,MN1,SFX1,SEX1,BDATE1,DEMO1,PARTY1,RD 
ATE1,METH1,ACT1,ABS1,PBF1,VH06G1,VH06P1,VH05G1,VH05P1,VH04G1,VH04P1,VH04 
PP1,VH03G1,VH03P1,VH02G1,VH02P1,VH01G1,VH01P1,VH00G1,VH00P1,VH00PP1,VH99 
G1,VH99P1,VH98G1,VH98P1,VH97G1,VH97P1,VHA1,VHB1,VHC1,VOTERID1,OTHA1,OTHB 
1 "",0.0000000000000000000000000000000000000000000000000000000000000000000 
000000000000000000000000000000000000000000000000000000000000000000000000 
000000000000000000000000000000000000000000000000000000000000000000000000 
000000000000000000000000000000000000000000000000000000000000000000000000 
00000000000000000000000000228156987444611,,"","","","","","","","",,,,"" 
,"",,"","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","",,,"","","","","","","","","","","","","","","","","","","","","","" 
,"","","","","","","","","","","","","","","","","","",""
"", 
-58639378995972355232269047872391698809118079929944547299961840534669537 
438711679981696932653189375030878852779036395458836251577990358162057026 
53375245912637440,,"","","","","","","","",,,,"","",,"","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","",,,"","","","","","" 
,"","","","","","","","","","","","","","","","","","","","","","","","" 
,"","","","","","","","","","",""
Segmentation fault



the mdb database is very large (1.62 GB) and consists of one table.

mdb tools is installed on a linux (RedHat 9.0) box. No problems  
installing the software. Lots of disk space.

Thank you.

Thorpe



-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job
easier Download IBM WebSphere Application Server v.1.0.1 based on Apache
Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] mdb-export segmentation fault

[Martin E. <ma...@el...>]

On Monday 11 September 2006 21:25, Michael Bunk wrote:
> After the segfault, type
> backtrace
>
> and send the result here.

... together with information about which version you are running.


Martin

Re: [mdb-dev] mdb-export segmentation fault

[Michael B. <mi...@lu...>]

Hello Thorpe,

I'm not active on this list, but in any case a backtrace is required 
to debug your problem. Use this command:
gdb mdb-export

At the prompt of gdb, type
run ok06vf01.mdb ok06vf01

After the segfault, type
backtrace

and send the result here.

Good luck,
 Michael

On Monday 11 September 2006 18:34, Thorpe Mayes wrote:
> I ran this from the commmand line:
>
> # mdb-export ok06vf01.mdb ok06vf01
>
>   and got this:
...
> Segmentation fault
...
> mdb tools is installed on a linux (RedHat 9.0) box
.... 

[mdb-dev] mdb-export segmentation fault

[Thorpe M. <tm...@ec...>]

I ran this from the commmand line:

# mdb-export ok06vf01.mdb ok06vf01

  and got this:

STA,CY,MUNI,CNTY,TWN,WD,PR,BB,PNAME,ODA,ODB,CD,SD,LD,LDS,MM,IIH,LN,MADR1 
,MADR2,MCITY,MSTA,MZIP5,MZIP4,MDC,MCR,MLOT,ADF,COA,RODD,RHNUM,RHSFX,RSTP 
RE,RSTNAME,RSTPOST,RSTTYPE,RAPT,RCITY,RSTA,RZIP5,RDSF,TAC,TEL,TSC,TML,TR 
C,FTC,SR01,SR02,SR03,SR04,SR05,SR06,SR07,SR08,SR09,SR10,SR11,SR12,SR13,S 
R14,SR15,SR16,SR17,SR18,SR19,SR20,SR21,SR22,SR23,SR24,SR25,SR26,SR27,SR2 
8,SR29,SR30,CO01,CO02,CO03,HMIX,ETETH,ETREL,ETGRP,ETLAN,FILL,FILLA,PROCD 
ATE,FILECODE,RNCID1,HTSEQ1,PFX1,FN1,MN1,SFX1,SEX1,BDATE1,DEMO1,PARTY1,RD 
ATE1,METH1,ACT1,ABS1,PBF1,VH06G1,VH06P1,VH05G1,VH05P1,VH04G1,VH04P1,VH04 
PP1,VH03G1,VH03P1,VH02G1,VH02P1,VH01G1,VH01P1,VH00G1,VH00P1,VH00PP1,VH99 
G1,VH99P1,VH98G1,VH98P1,VH97G1,VH97P1,VHA1,VHB1,VHC1,VOTERID1,OTHA1,OTHB 
1
"",0.0000000000000000000000000000000000000000000000000000000000000000000 
000000000000000000000000000000000000000000000000000000000000000000000000 
000000000000000000000000000000000000000000000000000000000000000000000000 
000000000000000000000000000000000000000000000000000000000000000000000000 
00000000000000000000000000228156987444611,,"","","","","","","","",,,,"" 
,"",,"","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","",,,"","","","","","","","","","","","","","","","","","","","","","" 
,"","","","","","","","","","","","","","","","","","",""
"", 
-58639378995972355232269047872391698809118079929944547299961840534669537 
438711679981696932653189375030878852779036395458836251577990358162057026 
53375245912637440,,"","","","","","","","",,,,"","",,"","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","","","","","","",""," 
","","","","","","","","","","","","","","","","","",,,"","","","","","" 
,"","","","","","","","","","","","","","","","","","","","","","","","" 
,"","","","","","","","","","",""
Segmentation fault



the mdb database is very large (1.62 GB) and consists of one table.

mdb tools is installed on a linux (RedHat 9.0) box. No problems  
installing the software. Lots of disk space.

Thank you.

Thorpe

Re: [mdb-dev] mdb files to csv files converter for windows

[Martin E. <ma...@el...>]

On Thursday 17 August 2006 16:10, ashwin.pimpale wrote:
>             I am the new member of this list. Could anyone please tell me
> where do I find the mdb to cvs converter for Windows platform.

If you're on Windows, the most robust way to do it is probably just to use the 
export features in Access.

If you don't have it, I think you can probably get away with downloading 
OpenOffice.  As I understand it, it uses the native database libraries when
installed on Windows.  Presumably that will have export functionality.

> This is very urgent. 

To who? :)

> I tried to search it on the net but it just suggests tools for the 
> unix & linux platform. They do specify that it can be installed on windows
> but then do not mention the procedures. 

I don't see anything in the mdbtools installation guide or FAQ to suggest 
this.

> Here are the links which might clear the issue:
> http://developer.gnome.org/doc/API/2.0/gtk/gtk-windows.html

That's not a page about mdbtools.  
That's a page about Gtk+: a library used by mdbtools which happens
to have been ported to Windows.

Martin

[mdb-dev] mdb files to csv files converter for windows

[ashwin.pimpale <ash...@in...>]

Hi guys,

            I am the new member of this list. Could anyone please tell me
where do I find the mdb to cvs converter for Windows platform. This is very
urgent. I tried to search it on the net but it just suggests tools for the
unix & linux platform. They do specify that it can be installed on windows
but then do not mention the procedures. Here are the links which might clear
the issue:

 

http://developer.gnome.org/doc/API/2.0/gtk/gtk-windows.html

 

Please respond as soon as possible,

 

With regards & thx,

         Ashwin.

Re: [mdb-dev] Red Hat Enterprise 4

[Sam M. <pa...@gm...>]

I will repeat some simple advice and suggest that you try the CVS
releases. I'm a Debian/Mac person so I can't particularly help (and
recently I had to replace my Mac's hard drive) on the Red Hat front.

Sam

On 16/08/06, Stever <st...@tr...> wrote:
> Has anyone gotten mdbtools to compile under Red Hat Enterprise 4? Both
> .5 and .6pre1 refuses to compile and I'm pulling my hair to see what's
> wrong.
>
> Just wondering if this is even feasible?
>
> - Steve
>
>
> -------------------------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

[mdb-dev] Red Hat Enterprise 4

[Stever <st...@tr...>]

Has anyone gotten mdbtools to compile under Red Hat Enterprise 4? Both
.5 and .6pre1 refuses to compile and I'm pulling my hair to see what's
wrong.

Just wondering if this is even feasible?

- Steve

[mdb-dev] export to postgresql

[Patrick W. <pr...@ne...>]

I have had some fun exporting a M$ Access database to PostgreSQL, and found
the enclose changes helpful. This is my first posting, so really, this is
just a "do you think this is useful / how would you like patches best
submitted" note.

autogen.sh, configure.in are just because I use cvs-autotools
libmdb.pc.in, libmdbsql.pc.in are just because I use an OS which uses -rpath
doc/mdb-export.text is just fixing a typo
mdbtools.h fixed a compile problem

backend.c:
 - data types mapping - we might as well use SQL datatypes and let the
   particular database do its own aliasing - it may mean that those
   tables become redundant?
 - allow foreign key constraints to be output for postgesql too, just
   adding a few "

mdb-export.c:
 - make boolean a text type because in postgresql:

     postgres=# create table test ( a boolean);
     CREATE TABLE
     postgres=# insert into test values ( 0 );
     ERROR:  column "a" is of type boolean but expression is of type integer
     HINT:  You will need to rewrite or cast the expression.
     postgres=# insert into test values ( '0' );
     INSERT 0 1
     postgres=# select * from test;
      a 
     ---
      f
     (1 row)

   so 0 (false in access) wants to be quoted, so that string -> boolean
   conversion occurs.

and the rest is all about quoting. In PostgreSQL, to preserve case and
spaces with table/column names, we need double quotes.

  create table "Some Table" -> Some Table
  create table Some Table   -> error
  create table "SomeTable"  -> SomeTable
  create table SomeTable    -> sometable

so I pop double quotes everywhere.

Another niggle is that if an escape character is defined, ' is then quoted
as escape char ' rather than '' .

The patches need discussing - I didn't go out of my way not to break other
backends, and it seems some of the above would be better off in an extension
to *mdb_backends.

Thoughts?

Cheers,

Patrick

[mdb-dev] Compiling under Red Hat Enterprise 4

[Steve Q. <st...@tr...>]

Question. . .

Has anyone got mdbtools 0.5 or 0.6pre1 working under Red Hat Linux 4? 
I'm having a devil of a time compiling this thing. I have both glib2 and 
glib2-devel installed, but it seems the code isn't seeing the libraries. 
I searched through the messageboards and google and couldn't find much, 
so i am posting this up online.

Here is when I try to compile version 0.5:
/bin/sh ../../libtool --mode=compile gcc -DPACKAGE_NAME=\"\" 
-DPACKAGE_TARNAME=\"\" -DPACKAGE_VERSION=\"\" -DPACKAGE_STRING=\"\" 
-DPACKAGE_BUGREPORT=\"\" -DPACKAGE=\"
mdbtools\" -DVERSION=\"0.5\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 
-DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 
-DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE
_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 
-DYYTEXT_POINTER=1 -DSTDC_HEADERS=1 -DHAVE_FCNTL_H=1 -DHAVE_LIMITS_H=1 
-DHAVE_UNISTD_H=1 -DHAVE_WOR
DEXP_H=1  -I. -I. -I ../../include `glib-config --cflags`    -g -O2 
-DSQL -DUNIXODBC -c -o odbc.lo `test -f 'odbc.c' || echo './'`odbc.c
rm -f .libs/odbc.lo
gcc -DPACKAGE_NAME=\"\" -DPACKAGE_TARNAME=\"\" -DPACKAGE_VERSION=\"\" 
-DPACKAGE_STRING=\"\" -DPACKAGE_BUGREPORT=\"\" -DPACKAGE=\"mdbtools\" 
-DVERSION=\"0.5\" -DSTDC_H
EADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 
-DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 
-DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAV
E_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DYYTEXT_POINTER=1 -DSTDC_HEADERS=1 
-DHAVE_FCNTL_H=1 -DHAVE_LIMITS_H=1 -DHAVE_UNISTD_H=1 -DHAVE_WORDEXP_H=1 
-I. -I. -I ../../include -I/
usr/include/glib-1.2 -I/usr/lib/glib/include -g -O2 -DSQL -DUNIXODBC -c 
odbc.c -MT odbc.lo -MD -MP -MF .deps/odbc.TPlo  -fPIC -DPIC -o .libs/odbc.lo
In file included from ../../include/mdbodbc.h:22,
                 from odbc.c:28:
../../include/mdbtools.h:31:18: glib.h: No such file or directory
In file included from ../../include/mdbodbc.h:22,
                 from odbc.c:28:
../../include/mdbtools.h:113: error: syntax error before '*' token
../../include/mdbtools.h:113: warning: data definition has no type or 
storage class
../../include/mdbtools.h:120: error: syntax error before "gboolean"


When I try to compile 0.6pre1, I get this:
gcc -DPACKAGE_NAME=\"\" -DPACKAGE_TARNAME=\"\" -DPACKAGE_VERSION=\"\" 
-DPACKAGE_STRING=\"\" -DPACKAGE_BUGREPORT=\"\" -DPACKAGE=\"mdbtools\" 
-DVERSION=\"0.5\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 
-DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 
-DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 
-DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DYYTEXT_POINTER=1 
-DSTDC_HEADERS=1 -DHAVE_FCNTL_H=1 -DHAVE_LIMITS_H=1 -DHAVE_UNISTD_H=1 
-DHAVE_WORDEXP_H=1  -I. -I. -I../../include `glib-config --cflags`    -g 
-O2 -DSQL -DUNIXODBC -c `test -f 'mdb-dump.c' || echo './'`mdb-dump.c
source='mdbsupport.c' object='mdbsupport.o' libtool=no \
depfile='.deps/mdbsupport.Po' tmpdepfile='.deps/mdbsupport.TPo' \
depmode=gcc3 /bin/sh ../../depcomp \
gcc -DPACKAGE_NAME=\"\" -DPACKAGE_TARNAME=\"\" -DPACKAGE_VERSION=\"\" 
-DPACKAGE_STRING=\"\" -DPACKAGE_BUGREPORT=\"\" -DPACKAGE=\"mdbtools\" 
-DVERSION=\"0.5\" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 
-DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 
-DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 
-DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DYYTEXT_POINTER=1 
-DSTDC_HEADERS=1 -DHAVE_FCNTL_H=1 -DHAVE_LIMITS_H=1 -DHAVE_UNISTD_H=1 
-DHAVE_WORDEXP_H=1  -I. -I. -I../../include `glib-config --cflags`    -g 
-O2 -DSQL -DUNIXODBC -c `test -f 'mdbsupport.c' || echo './'`mdbsupport.c
/bin/sh ../../libtool --mode=link gcc  -g -O2 -DSQL -DUNIXODBC   -o 
mdb-dump  mdb-dump.o mdbsupport.o ../libmdb/libmdb.la  `glib-config --libs`
mkdir .libs
gcc -g -O2 -DSQL -DUNIXODBC -o .libs/mdb-dump mdb-dump.o mdbsupport.o  
../libmdb/.libs/libmdb.so -lglib-2.0 -L/usr/lib -lglib -Wl,--rpath 
-Wl,/usr/local/lib
/usr/bin/ld: cannot find -lglib
collect2: ld returned 1 exit status
make[2]: *** [mdb-dump] Error 1
make[2]: Leaving directory `/root/tmp4/mdbtools-0.5/src/extras'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/root/tmp4/mdbtools-0.5/src'
make: *** [all-recursive] Error 1


Anyone can point out what's wrong?

[mdb-dev] Export from Microsoft Access to DB2

[Jatinder S. <jat...@gm...>]

Hi,

Can I use MDB utilities to export data from MS Access to IBM DB2?
I tried to use Export functionality provided by Access to export using ODBC
but observed that it has lot of limitations like primary key was getting
exported and then relationships between various tables etc.
I also want to export queries/forms/reports out of Microsft Access;

Appreciate any help.

Regards,
Jatinder

Re: [mdb-dev] 0.6pre1 make error

[Clodoaldo P. <clo...@gm...>]

2006/7/23, Martin Ellis <ma...@el...>:
> On Sunday 23 July 2006 16:59, Clodoaldo Pinto wrote:
> > While installing on FC5:
>
> > make: *** [all-recursive] Error 1
>
> Hi,
>
> You might want to read:
> http://sourceforge.net/mailarchive/forum.php?thread_id=10413561&forum_id=5183

Thanks, installing from cvs works Ok.

Regards, Clodoaldo

Re: [mdb-dev] 0.6pre1 make error

[Martin E. <ma...@el...>]

On Sunday 23 July 2006 16:59, Clodoaldo Pinto wrote:
> While installing on FC5:

> backend.c:31: error: static declaration of 'mdb_backends' follows
> non-static declaration
> ../../include/mdbtools.h:150: error: previous declaration of
> 'mdb_backends' was here
> make[2]: *** [backend.lo] Error 1
> make[2]: Leaving directory
> `/home/cpn/Downloads/mdbtools-0.6pre1/src/libmdb' make[1]: ***
> [all-recursive] Error 1
> make[1]: Leaving directory `/home/cpn/Downloads/mdbtools-0.6pre1/src'
> make: *** [all-recursive] Error 1

Hi,

You might want to read:
http://sourceforge.net/mailarchive/forum.php?thread_id=10413561&forum_id=5183

Cheers
Martin

[mdb-dev] 0.6pre1 make error

[Clodoaldo P. <clo...@gm...>]

While installing on FC5:

# make
Making all in src
make[1]: Entering directory `/home/cpn/Downloads/mdbtools-0.6pre1/src'
Making all in libmdb
make[2]: Entering directory `/home/cpn/Downloads/mdbtools-0.6pre1/src/libmdb'
if /bin/sh ../../libtool --mode=compile gcc -DHAVE_CONFIG_H -I. -I.
-I../../include  -I../../include -I/usr/include/glib-2.0
-I/usr/lib/glib-2.0/include     -g -O2 -DSQL -MT backend.lo -MD -MP
-MF ".deps/backend.Tpo" \
  -c -o backend.lo `test -f 'backend.c' || echo './'`backend.c; \
then mv -f ".deps/backend.Tpo" ".deps/backend.Plo"; \
else rm -f ".deps/backend.Tpo"; exit 1; \
fi
 gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include
-I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include -g -O2 -DSQL -MT
backend.lo -MD -MP -MF .deps/backend.Tpo -c backend.c  -fPIC -DPIC -o
.libs/backend.o
backend.c:31: error: static declaration of 'mdb_backends' follows
non-static declaration
../../include/mdbtools.h:150: error: previous declaration of
'mdb_backends' was here
make[2]: *** [backend.lo] Error 1
make[2]: Leaving directory `/home/cpn/Downloads/mdbtools-0.6pre1/src/libmdb'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/cpn/Downloads/mdbtools-0.6pre1/src'
make: *** [all-recursive] Error 1

Regards, Clodoaldo Pinto

Re: [mdb-dev] More OS X errors

[Jon S. <jes...@ho...>]

Hmm.  I applied the patch you posted, and double checked my fink install of
libtool (1.5.10-1), Neil, but it still gives me the same errors.  I don't
really understand what the problem is.

Thanks for all your help, :)
Jon Stovell




On 7/20/06 8:35 AM, "Neil Tiffin" <ne...@ne...> wrote:

> I just compiled CVS as of July 20, 2006 3:30 PM UTC with no errors
> 
> I did have to modify autogen.sh as follows
> 
> % cvs diff -uw autogen.sh
> Index: autogen.sh
> ===================================================================
> RCS file: /cvsroot/mdbtools/mdbtools/autogen.sh,v
> retrieving revision 1.8
> diff -u -w -r1.8 autogen.sh
> --- autogen.sh  31 Mar 2005 05:22:13 -0000      1.8
> +++ autogen.sh  20 Jul 2006 15:33:51 -0000
> @@ -19,7 +19,7 @@
> }
> (grep "^A[CM]_PROG_LIBTOOL" $srcdir/configure.in >/dev/null) && {
> -  (libtool --version) < /dev/null > /dev/null 2>&1 || {
> +  (glibtool --version) < /dev/null > /dev/null 2>&1 || {
>       echo
>       echo "**Error**: You must have \`libtool' installed."
>       echo "Get ftp://ftp.gnu.org/pub/gnu/libtool-1.2d.tar.gz"
> 
> 
> You will note that libtool was changed to glibtool.  I also used fink
> to resolve all dependencies
> 
> I also used libtool 1.5
> 
> % fink list libtool
> Information about 5883 packages read in 3 seconds.
>       libtool                    1.3.5-23             Shared library
> build helper, v1.3.5
> i   libtool-shlibs             1.3.5-23             Shared libraries
> for libtool, v1.3.5
> i   libtool14                  1.5.22-1000          Shared library
> build helper, v1.5
> i   libtool14-shlibs           1.5.22-1000          Shared libraries
> for libtool, v1.5
> 
> Neil
> 
> On Jul 16, 2006, at 11:05 PM, Jon Stovell wrote:
> 
>> X-SpamDetect-Info: ------------- Start ASpam results ---------------
>> X-SpamDetect-Info: This message may be spam. This message BODY has
>> been altered to show you the spam information
>> X-SpamDetect: ****: 4.117000 SPF Pass=-2.0,Message-Id is not valid,
>> according to RFC 2822=1.2,To: repeats address as real
>> name=0.4,Aspam=4.5
>> X-SpamDetect-Info: ------------- End ASpam results -----------------
>> 
>> Hi all,
>> 
>> Trying to compile on Mac OS X from CVS, as checked out July 16, 2006.
>> Following the advice posted by Sam Moffat in January, I overrode
>> the libtool
>> check in autogen.sh (after using fink to ensure I had the latest
>> version
>> installed), but I am still running into errors further down the
>> line.  Any
>> help would be appreciated.  The errors autogen.sh throws are as
>> follows
>> (I've cut out a long list of stuff in the middle that went just fine):
>> 
>> **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 aclocal  ...
>> aclocal:configure.in:106: warning: macro `AM_PATH_GLIB_2_0' not
>> found in
>> library
>> Running libtoolize...
>> Running autoheader...
>> Running automake --gnu  ...
>> Running autoconf ...
>> Running ./configure ...
>> checking for a BSD-compatible install... /usr/bin/install -c
>> checking whether build environment is sane... yes
>> ..
>> ..
>> ..
>> checking for size_t... yes
>> checking for iconv... yes
>> checking for iconv declaration...
>>          extern size_t iconv (iconv_t cd, const char * *inbuf, size_t
>> *inbytesleft, char * *outbuf, size_t *outbytesleft);
>> checking Are we using flex ... yes
>> ../configure: line 20354: syntax error near unexpected token `2.0.0'
>> ../configure: line 20354: `AM_PATH_GLIB_2_0(2.0.0)'
>> 
>> 
>> 
>> 
>> 
>> 
>> ----------------------------------------------------------------------
>> ---
>> Using Tomcat but need to do more? Need to support web services,
>> security?
>> Get stuff done quickly with pre-integrated technology to make your
>> job easier
>> Download IBM WebSphere Application Server v.1.0.1 based on Apache
>> Geronimo
>> http://sel.as-us.falkag.net/sel?
>> cmd=lnk&kid=120709&bid=263057&dat=121642
>> _______________________________________________
>> mdbtools-dev mailing list
>> mdb...@li...
>> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 
> 

Re: [mdb-dev] More OS X errors

[Neil T. <ne...@ne...>]

I just compiled CVS as of July 20, 2006 3:30 PM UTC with no errors

I did have to modify autogen.sh as follows

% cvs diff -uw autogen.sh
Index: autogen.sh
===================================================================
RCS file: /cvsroot/mdbtools/mdbtools/autogen.sh,v
retrieving revision 1.8
diff -u -w -r1.8 autogen.sh
--- autogen.sh  31 Mar 2005 05:22:13 -0000      1.8
+++ autogen.sh  20 Jul 2006 15:33:51 -0000
@@ -19,7 +19,7 @@
}
(grep "^A[CM]_PROG_LIBTOOL" $srcdir/configure.in >/dev/null) && {
-  (libtool --version) < /dev/null > /dev/null 2>&1 || {
+  (glibtool --version) < /dev/null > /dev/null 2>&1 || {
      echo
      echo "**Error**: You must have \`libtool' installed."
      echo "Get ftp://ftp.gnu.org/pub/gnu/libtool-1.2d.tar.gz"


You will note that libtool was changed to glibtool.  I also used fink  
to resolve all dependencies

I also used libtool 1.5

% fink list libtool
Information about 5883 packages read in 3 seconds.
      libtool                    1.3.5-23             Shared library  
build helper, v1.3.5
i   libtool-shlibs             1.3.5-23             Shared libraries  
for libtool, v1.3.5
i   libtool14                  1.5.22-1000          Shared library  
build helper, v1.5
i   libtool14-shlibs           1.5.22-1000          Shared libraries  
for libtool, v1.5

Neil

On Jul 16, 2006, at 11:05 PM, Jon Stovell wrote:

> X-SpamDetect-Info: ------------- Start ASpam results ---------------
> X-SpamDetect-Info: This message may be spam. This message BODY has  
> been altered to show you the spam information
> X-SpamDetect: ****: 4.117000 SPF Pass=-2.0,Message-Id is not valid,  
> according to RFC 2822=1.2,To: repeats address as real  
> name=0.4,Aspam=4.5
> X-SpamDetect-Info: ------------- End ASpam results -----------------
>
> Hi all,
>
> Trying to compile on Mac OS X from CVS, as checked out July 16, 2006.
> Following the advice posted by Sam Moffat in January, I overrode  
> the libtool
> check in autogen.sh (after using fink to ensure I had the latest  
> version
> installed), but I am still running into errors further down the  
> line.  Any
> help would be appreciated.  The errors autogen.sh throws are as  
> follows
> (I've cut out a long list of stuff in the middle that went just fine):
>
> **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 aclocal  ...
> aclocal:configure.in:106: warning: macro `AM_PATH_GLIB_2_0' not  
> found in
> library
> Running libtoolize...
> Running autoheader...
> Running automake --gnu  ...
> Running autoconf ...
> Running ./configure ...
> checking for a BSD-compatible install... /usr/bin/install -c
> checking whether build environment is sane... yes
> ..
> ..
> ..
> checking for size_t... yes
> checking for iconv... yes
> checking for iconv declaration...
>          extern size_t iconv (iconv_t cd, const char * *inbuf, size_t
> *inbytesleft, char * *outbuf, size_t *outbytesleft);
> checking Are we using flex ... yes
> ../configure: line 20354: syntax error near unexpected token `2.0.0'
> ../configure: line 20354: `AM_PATH_GLIB_2_0(2.0.0)'
>
>
>
>
>
>
> ---------------------------------------------------------------------- 
> ---
> Using Tomcat but need to do more? Need to support web services,  
> security?
> Get stuff done quickly with pre-integrated technology to make your  
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache  
> Geronimo
> http://sel.as-us.falkag.net/sel? 
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] From MySql to ACCESS

[Michael W. <mw...@ic...>]

On Wed, Jul 19, 2006 at 06:37:53PM +0200, Michele Monaco wrote:
> I have a MySql database, I need to convert in an Access format.
> 
> May MdbTools help me?

In my opinion, mdbtools is not the tool to use for this.
mdb-sql might be able to do it (I haven't ever used mdb-sql) but
the write support of mdbtools is much younger than the read
support.

Rather do something like this:

  Use MS Access as a front-end to MySQL by linking tables.

or:

  Dump the schema and data from MySQL using the mysqldump
  command, edit the dump file to fix the "CREATE TABLE" commands
  etc., so that Access will accept them.  Then execute the SQL
  statements in Access.

or:

  Figure out how to get the data exported from each table in CSV
  format, create all the necessary tables within Access and then
  import each table's data.

P.S. I am no expert in either MySQL or MS Access...

-- 
Michael Wood <mw...@ic...>

Re: [mdb-dev] From MySql to ACCESS

[GARY S. <gse...@bt...>]

You can use Access to connect to a mysql database.
Have a look at http://www.ucl.ac.uk/is/mysql/access/

Hope this helps


Regards,
Gary
 


mdb...@li... wrote: Send mdbtools-dev mailing list submissions to
 mdb...@li...

To subscribe or unsubscribe via the World Wide Web, visit
 https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
or, via email, send a message with subject or body 'help' to
 mdb...@li...

You can reach the person managing the list at
 mdb...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of mdbtools-dev digest..."


Today's Topics:

   1. From MySql to ACCESS (Michele Monaco)


----------------------------------------------------------------------

Message: 1
Date: Wed, 19 Jul 2006 18:37:53 +0200
From: "Michele Monaco" 
Subject: [mdb-dev] From MySql to ACCESS
To: mdb...@li...
Message-ID:
 <382...@ma...>
Content-Type: text/plain; charset="iso-8859-1"

I have a MySql database, I need to convert in an Access format.

May MdbTools help me?

Many thanks,
Michele
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://sourceforge.net/mailarchive/forum.php?forum=mdbtools-dev/attachments/20060719/6960ce39/attachment.html 

------------------------------

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV

------------------------------

_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev


End of mdbtools-dev Digest, Vol 2, Issue 5
******************************************


 		
---------------------------------
 Now you can scan emails quickly with a reading pane. Get the new Yahoo! Mail.

Re: [mdb-dev] From MySql to ACCESS

[David M. <bun...@gm...>]

If you're using Windows, you could actually just install the MySQL ODBC 
driver and import the table via ODBC with the built in Access import 
function.

I don't know what you're intent is here, but be warned that if the table 
is over 10,000 records you could have a very bad experience after you 
import to an Access table.  As for the actual import process:  I've done 
it with very large DB2 tables and some smaller MySQL table and it is a 
fairly painless process.

Thanks,
Dave

Michele Monaco wrote:
> I have a MySql database, I need to convert in an Access format.
>
> May MdbTools help me?
>
> Many thanks,
> Michele
>
>
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> ------------------------------------------------------------------------
>
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>