mdbtools-dev

[mdb-dev] Segfault on long memo fields

[Nigel K. <sup...@pe...>]

I have one table where the user has pasted some notes from another
application into a 'comments' field of type 'memo' and mdb-export segfaults
when it gets to these notes - they are quite long and contain tabs. 

I am not sure whether it's the length of the data or that it includes
non-ascii characters, but I just wondered if anyone had any ideas tracking
down the problem - I have had a look at the source code for mdb-export but I
don't know C very well so I'm not getting very far. I get the feeling it's a
buffer overflow or character (tab?) handling issue somewhere?

Any thoughts on where to look?

Thanks

Re: [mdb-dev] FW: New user of mdbtools

[Nigel K. <sup...@pe...>]

> I cannot see any problems in the Access table that could cause some kind
of
> error condition but the export stops at exactly the same record every time
> and suspiciously close to when it creates a 100MB csv file (104140795) so
> could I be hitting a memory allocation limit or am I totally off-the-mark?

>
>Could be... Hard to tell, but I don't think so...
>
>I have looked at you patch...
>
>You do know that your "-L" is only active when you do not also specify
"-Q",
>right?
>
>I cannot see any obvious errors in your code.
>
>It's time for debugging: valgrind, gdb.
>
>Anyway: I think it is a much cleaner solution to post-process your
>generated SQL (using awk) to produce the output needed; thereby
>seperating the two responsibilities: DB conversion and Data manipulation.
>
>Jarl



Thanks for the feedback - the export runs if I remove two rows/records in
the database so it looks like there is a small corruption which I can easily
fix. Not sure if its worth the time to find out what's tripping the export
and make sure its trapped as the problem only occurs with 1 table out of 25
I am exporting.

Thanks also for the comments on my first ever 'c' coding!

Nigel

Re: [mdb-dev] FW: New user of mdbtools

[Jarl F. <ja...@ga...>]

"Nigel Kendrick" <sup...@pe...> writes:

> Glad there's some life here!!
>
> I'll submit the code and see what happens.
>
> Things have been working fine until I tried to generate a csv file from a
> large table containing a lot of text fields -  mdb-export crashes out with:
>
> *** glibc detected *** /usr/local/bin/.libs/lt-mdb-export: double free or
> corruption (out): 0x08f0dcb0 *** 
>
> I cannot see any problems in the Access table that could cause some kind of
> error condition but the export stops at exactly the same record every time
> and suspiciously close to when it creates a 100MB csv file (104140795) so
> could I be hitting a memory allocation limit or am I totally off-the-mark? 

Could be... Hard to tell, but I don't think so...

I have looked at you patch...

You do know that your "-L" is only active when you do not also specify "-Q",
right?

I cannot see any obvious errors in your code.

It's time for debugging: valgrind, gdb.

Anyway: I think it is a much cleaner solution to post-process your
generated SQL (using awk) to produce the output needed; thereby
seperating the two responsibilities: DB conversion and Data manipulation.

Jarl

[mdb-dev] FW: New user of mdbtools

[Nigel K. <sup...@pe...>]

-----Original Message-----
From: Jarl Friis [mailto:ja...@so...] 
Sent: Monday, June 23, 2008 12:09 PM
To: Nigel Kendrick
Cc: mdb...@li...
Subject: Re: [mdb-dev] New user of mdbtools

[Snip]

I will suggest that you do like the rest of us...
Submit a patch on 
http://sourceforge.net/tracker/?group_id=2294&atid=302294

I can reccomend 
Patch for UTF-8
Patch for export to SQLite

:-)

When you have done that, you can post a mail here on the list.

Jarl




Hi Jarl,

Glad there's some life here!!

I'll submit the code and see what happens.

Things have been working fine until I tried to generate a csv file from a
large table containing a lot of text fields -  mdb-export crashes out with:

*** glibc detected *** /usr/local/bin/.libs/lt-mdb-export: double free or
corruption (out): 0x08f0dcb0 *** 

I cannot see any problems in the Access table that could cause some kind of
error condition but the export stops at exactly the same record every time
and suspiciously close to when it creates a 100MB csv file (104140795) so
could I be hitting a memory allocation limit or am I totally off-the-mark? 

I'm afraid I am only 2-days 'into' c programming so I wouldn't know where to
start looking!?

Thanks

Nigel


EDIT: 

Apologies to Jarl - my first reply went direct and not to the list.

Scrap the idea of the 100MB limit as one of my exports to csv makes it to
177MB without any problems.

[mdb-dev] New user of mdbtools

[Nigel K. <sup...@pe...>]

Hello Everyone,
 
After a bit of fiddling and patience I have finally managed to checkout the
cvs version of mdbtools and compile it on a system running CentOS5.
 
As far as I can see the tools have been around for some time and ongoing
activity (development, forum/mailing list posts etc.) is fairly minimal, but
I am glad to have found the tools as they are helping greatly with a project
to import access 97 data into a MySQL database on a nightly basis.
 
One thing I did note, and found some comments on the 'net' about, was the
fact that the current/latest mdb-export tool does nothing about CR, LF or
CR/LF codes within data fields and this was a problem for me so I have
approached it in two ways:
 
1) Using an awk command to post-process the generated csv files:
 
awk -v RS="\r\n" -v ORS=" " {print} infile.csv > outfile.csv
 
2) I also had a look at the source code for mdb-export.c and modified it to
include an '-L' switch to replace CR and LF codes in data fields with
spaces. I am not sure if the code I have added is the most elegant way to
achieve the desired result (This was my first ever work in c and my last
real major programming work was in the 1990s in pascal!), but if anyone
wants the code - or there is a proper way to submit it to the project - just
let me know.
 
All the best
 
Nigel Kendrick
 

[mdb-dev] write functionality

[Niall M. <nim...@gm...>]

Hi, apologies if this has already been covered in a previous post.

What is the status of write functionality in the 0.6 prerelease? My intended
use is as following:

1. Copy Access 97 data to PostgreSQL db (schema created ok using mdbtools
version  0.5.99.0.6pre1.0.20051109-4)
2. Modify PostgreSQL data using web application.
3. Copy updated data to Access 97 mdb file.

The schema for the mdb is extremely basic with no relationships. It is used
as a datafile for a communications utility which is only available in
Windows and can only use mdb files. (I hope to change this eventually!)

[mdb-dev] Problems building mdbtools

[Rick M. <rm...@la...>]

Hi. I've tried building from source, which didn't like OS X, then  
building 0.6pre1, which failed to compile, then 0.5, which failed to  
link:

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 -DHAVE_READLINE=1 -I. -I. -I../../include -I/usr/ 
local/include/glib-2.0 -I/usr/local/lib/glib-2.0/include -g -O2 -DSQL - 
c stats.c -MT stats.lo -MD -MP -MF .deps/stats.TPlo -o stats.o >/dev/ 
null 2>&1
mv -f .libs/stats.lo stats.lo
/bin/sh ../../libtool --mode=link gcc  -g -O2 -DSQL   -o libmdb.la - 
rpath /usr/local/lib  catalog.lo mem.lo file.lo kkd.lo table.lo  
data.lo dump.lo backend.lo money.lo sargs.lo index.lo like.lo write.lo  
stats.lo  -L/usr/local/lib -lglib-2.0 -lintl -liconv
rm -fr .libs/libmdb.la .libs/libmdb.* .libs/libmdb.*
gcc -dynamiclib -flat_namespace -undefined suppress -o .libs/libmdb. 
0.0.0.dylib  catalog.lo mem.lo file.lo kkd.lo table.lo data.lo dump.lo  
backend.lo money.lo sargs.lo index.lo like.lo write.lo stats.lo  -L/ 
usr/lib -L/Developer/SDKs/MacOSX10.5.sdk/usr/lib -L/usr/local/lib - 
lglib-2.0 -lintl -liconv -lc -install_name  /usr/local/lib/libmdb. 
0.dylib -compatibility_version 1 -current_version 1.0
ld: duplicate symbol _mdb_backends in mem.lo and catalog.lo
collect2: ld returned 1 exit status
make[2]: *** [libmdb.la] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive] Error 1


Any suggestions? Thanks!

-- 
Rick

[mdb-dev] quick connection string question

[Daniel <lik...@gm...>]

Hi, all.

I found this list through Mono's ODBC info page
(http://www.mono-project.com/ODBC).  I'm trying to make a C# program that
would use a simple no-frills mdb file in Linux (Fedora 8) using the
System.Data.Odbc namespace in Mono.  Does anyone know what the connection
string is supposed to look like?  In a win32 .Net Framework scenario, it
would be something like:

OdbcConnection myConnection = new OdbcConnection("Driver={Microsoft Access
Driver (*.mdb)};DBQ=" + dbfilename);

However, that doesn't work with Linux.  I've downloaded and installed
unixODBC and the mdbtools packages (as the Mono info page instructs).  I
just need to know what the the connection string is supposed to be.

This may sound like a noob question, but keep in mind that I've been
searching the interwebs for a few days, without results.

I'm not trying to connect to a server, it's just a stand-alone mdb file
sitting in the same folder as the program.


Thanks in advance!

- Daniel

Re: [mdb-dev] Building mdbtools on Fedora Core 4

[Murray C. <mu...@fo...>]

Thanks Jarl

The latest CVS and autogen.sh worked fine.  I had to install a couple of
extra packages.... cvs (ha!) and libtool.

I then ran mdb-export and it worked like a charm,

Cheers
mc


On 02/04/2008, Jarl Friis <ja...@so...> wrote:
>
> "Murray Collingwood" <mu...@fo...> writes:
>
> > 1.  (*) text/plain          ( ) text/html
>
> >
> > Hello
> >
> > 1. Fedora Core 4 is not the latest, however it's all I have to work with
> in
> > the shared hosting environment I have.
> >
> > 2. I hunted but couldn't find any binaries that would work for this
> Fedora
> > build... hence I was only left with building my own... can't be too hard
> can
> > it?
> >
> > 3. I downloaded the latest sources (not CVS, from the tar.gz) so I have
> > mdbtools-0.5.tar.gz sources.
>
>
> Try the laest CVS and use autogen.sh instead of configure...
> Does that make any difference?
>
>
> Jarl
>
>


-- 
Murray Collingwood
Focus Computing
p +61 415 24 26 24
http://www.focus-computing.com.au

[mdb-dev] Building mdbtools on Fedora Core 4

[Murray C. <mu...@fo...>]

Hello

1. Fedora Core 4 is not the latest, however it's all I have to work with in
the shared hosting environment I have.

2. I hunted but couldn't find any binaries that would work for this Fedora
build... hence I was only left with building my own... can't be too hard can
it?

3. I downloaded the latest sources (not CVS, from the tar.gz) so I have
mdbtools-0.5.tar.gz sources.

4. The ./configure step failed:
a. I tried updating my glib version, however this only went to v1.2
b. Tried installing glib2 (which is actually version glib v2.6)
c. Also had to install & upgrade pkgconfig
d. glib2 installed into /usr/include/glib-2.0 - don't know why but I fixed
this in configure.in by specifying OPTDIRS="/usr/include/glib-2.0"
e. Configure appears to work okay, although it still reports an error
'cannot find -lreadline', not sure if this is critical

5. The make step now fails:
a. It was reporting a cmd not found, aclocal-1.6.  I went to /usr/bin and
built a symbolic link to aclocal as aclocal-1.6 and this worked fine.
b. Now the bit I'm stuck on...

-bash-3.00# make
cd . && aclocal-1.6
configure.in:127: error: `src/Makefile' is already registered with
AC_CONFIG_FILES.
autoconf/status.m4:848: AC_CONFIG_FILES is expanded from...
configure.in:127: the top level
autom4te: /usr/bin/m4 failed with exit status: 1
aclocal-1.6: autom4te failed with exit status: 1
make: *** [aclocal.m4] Error 1


Is anybody able to help me solve this problem please?

Cheers
mc


-- 
Murray Collingwood
Focus Computing
p +61 415 24 26 24
http://www.focus-computing.com.au

Re: [mdb-dev] writing to Microsoft Access MDB

[BonzaiBoy <ke...@gm...>]

I'm sorry... unfortunately that's only a typo in my e-mail. The name
of the table is table1 and in the INSERT-statement it should be table1
too...

B.


On Tue, Mar 25, 2008 at 9:39 PM, Igor Korot <ik...@ea...> wrote:
> I hope it's just an E-mail typo...
> You saying you created the table "table1", but trying to insert in "tabel1".
>
> Thank you.
>
>
> -----Original Message-----
> >From: BonzaiBoy <ke...@gm...>
> >Sent: Mar 25, 2008 4:08 PM
> >To: Igor Korot <ik...@ea...>
> >Cc: mdb...@li...
> >Subject: Re: [mdb-dev] writing to Microsoft Access MDB
> >
> >Igor,
> >
> >I created the access file myself...
> >
> >I created one table (table1) with one field (test) of type "long
> >integer". I tried to insert one value with the SQL-statement: INSERT
> >INTO tabel1 ( test ) VALUES ( '1' );
> >
> >I tried all variants I can imagine...
> >
> >B.
> >
> >
> >On Tue, Mar 25, 2008 at 7:32 PM, Igor Korot <ik...@ea...> wrote:
> >> Hi,
> >> Did you create your database or you using the standard access files?
> >>
> >> Thank you.
> >>
> >>
> >> -----Original Message-----
> >> >From: Ketjes <ke...@gm...>
> >> >Sent: Mar 25, 2008 8:38 AM
> >> >To: mdb...@li...
> >> >Subject: [mdb-dev] writing to Microsoft Access MDB
> >> >
> >> >Hi,
> >> >
> >> >I want to execute an INSERT-query into a Microsoft Access-file.
> >> >
> >> >I use:
> >> >- Debian-Linux as OS (kernel = 2.6.18-4-686-bigmem)
> >> >- unixODBC version 2.2.4
> >> >- libmdbtools (debian-package) => mdbtools: version
> >> >0.5.99.0.6pre1.0.20050409-1
> >> >- I use Perl to write my scripts
> >> >
> >> >I can SELECT records from my Access-DB perfectly, but when using INSERT
> >> >in a query I always get "syntax error near INSERT" !  I'm quite sure of
> >> >the INSERT-syntax itself...
> >> >
> >> >My question: does this version of mdbtools support writing to Access
> >> >MDB-files ?  anyone an idea what I'm doing wrong ?
> >> >
> >> >Kind regards,
> >> >
> >> >B.
> >> >
> >> >-------------------------------------------------------------------------
> >> >This SF.net email is sponsored by: Microsoft
> >> >Defy all challenges. Microsoft(R) Visual Studio 2008.
> >> >http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >> >_______________________________________________
> >> >mdbtools-dev mailing list
> >> >mdb...@li...
> >> >https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> >>
> >>
> >
> >-------------------------------------------------------------------------
> >This SF.net email is sponsored by: Microsoft
> >Defy all challenges. Microsoft(R) Visual Studio 2008.
> >http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >_______________________________________________
> >mdbtools-dev mailing list
> >mdb...@li...
> >https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
>

Re: [mdb-dev] writing to Microsoft Access MDB

[Igor K. <ik...@ea...>]

I hope it's just an E-mail typo...
You saying you created the table "table1", but trying to insert in "tabel1".

Thank you.

-----Original Message-----
>From: BonzaiBoy <ke...@gm...>
>Sent: Mar 25, 2008 4:08 PM
>To: Igor Korot <ik...@ea...>
>Cc: mdb...@li...
>Subject: Re: [mdb-dev] writing to Microsoft Access MDB
>
>Igor,
>
>I created the access file myself...
>
>I created one table (table1) with one field (test) of type "long
>integer". I tried to insert one value with the SQL-statement: INSERT
>INTO tabel1 ( test ) VALUES ( '1' );
>
>I tried all variants I can imagine...
>
>B.
>
>
>On Tue, Mar 25, 2008 at 7:32 PM, Igor Korot <ik...@ea...> wrote:
>> Hi,
>> Did you create your database or you using the standard access files?
>>
>> Thank you.
>>
>>
>> -----Original Message-----
>> >From: Ketjes <ke...@gm...>
>> >Sent: Mar 25, 2008 8:38 AM
>> >To: mdb...@li...
>> >Subject: [mdb-dev] writing to Microsoft Access MDB
>> >
>> >Hi,
>> >
>> >I want to execute an INSERT-query into a Microsoft Access-file.
>> >
>> >I use:
>> >- Debian-Linux as OS (kernel = 2.6.18-4-686-bigmem)
>> >- unixODBC version 2.2.4
>> >- libmdbtools (debian-package) => mdbtools: version
>> >0.5.99.0.6pre1.0.20050409-1
>> >- I use Perl to write my scripts
>> >
>> >I can SELECT records from my Access-DB perfectly, but when using INSERT
>> >in a query I always get "syntax error near INSERT" !  I'm quite sure of
>> >the INSERT-syntax itself...
>> >
>> >My question: does this version of mdbtools support writing to Access
>> >MDB-files ?  anyone an idea what I'm doing wrong ?
>> >
>> >Kind regards,
>> >
>> >B.
>> >
>> >-------------------------------------------------------------------------
>> >This SF.net email is sponsored by: Microsoft
>> >Defy all challenges. Microsoft(R) Visual Studio 2008.
>> >http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>> >_______________________________________________
>> >mdbtools-dev mailing list
>> >mdb...@li...
>> >https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>>
>>
>
>-------------------------------------------------------------------------
>This SF.net email is sponsored by: Microsoft
>Defy all challenges. Microsoft(R) Visual Studio 2008.
>http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>_______________________________________________
>mdbtools-dev mailing list
>mdb...@li...
>https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] writing to Microsoft Access MDB

[BonzaiBoy <ke...@gm...>]

Igor,

I created the access file myself...

I created one table (table1) with one field (test) of type "long
integer". I tried to insert one value with the SQL-statement: INSERT
INTO tabel1 ( test ) VALUES ( '1' );

I tried all variants I can imagine...

B.


On Tue, Mar 25, 2008 at 7:32 PM, Igor Korot <ik...@ea...> wrote:
> Hi,
> Did you create your database or you using the standard access files?
>
> Thank you.
>
>
> -----Original Message-----
> >From: Ketjes <ke...@gm...>
> >Sent: Mar 25, 2008 8:38 AM
> >To: mdb...@li...
> >Subject: [mdb-dev] writing to Microsoft Access MDB
> >
> >Hi,
> >
> >I want to execute an INSERT-query into a Microsoft Access-file.
> >
> >I use:
> >- Debian-Linux as OS (kernel = 2.6.18-4-686-bigmem)
> >- unixODBC version 2.2.4
> >- libmdbtools (debian-package) => mdbtools: version
> >0.5.99.0.6pre1.0.20050409-1
> >- I use Perl to write my scripts
> >
> >I can SELECT records from my Access-DB perfectly, but when using INSERT
> >in a query I always get "syntax error near INSERT" !  I'm quite sure of
> >the INSERT-syntax itself...
> >
> >My question: does this version of mdbtools support writing to Access
> >MDB-files ?  anyone an idea what I'm doing wrong ?
> >
> >Kind regards,
> >
> >B.
> >
> >-------------------------------------------------------------------------
> >This SF.net email is sponsored by: Microsoft
> >Defy all challenges. Microsoft(R) Visual Studio 2008.
> >http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> >_______________________________________________
> >mdbtools-dev mailing list
> >mdb...@li...
> >https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
>

Re: [mdb-dev] writing to Microsoft Access MDB

[Igor K. <ik...@ea...>]

Hi,
Did you create your database or you using the standard access files?

Thank you.

-----Original Message-----
>From: Ketjes <ke...@gm...>
>Sent: Mar 25, 2008 8:38 AM
>To: mdb...@li...
>Subject: [mdb-dev] writing to Microsoft Access MDB
>
>Hi,
>
>I want to execute an INSERT-query into a Microsoft Access-file.
>
>I use:
>- Debian-Linux as OS (kernel = 2.6.18-4-686-bigmem)
>- unixODBC version 2.2.4
>- libmdbtools (debian-package) => mdbtools: version 
>0.5.99.0.6pre1.0.20050409-1
>- I use Perl to write my scripts
>
>I can SELECT records from my Access-DB perfectly, but when using INSERT 
>in a query I always get "syntax error near INSERT" !  I'm quite sure of 
>the INSERT-syntax itself...
>
>My question: does this version of mdbtools support writing to Access 
>MDB-files ?  anyone an idea what I'm doing wrong ?
>
>Kind regards,
>
>B.
>
>-------------------------------------------------------------------------
>This SF.net email is sponsored by: Microsoft
>Defy all challenges. Microsoft(R) Visual Studio 2008.
>http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
>_______________________________________________
>mdbtools-dev mailing list
>mdb...@li...
>https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] writing to Microsoft Access MDB

[Ketjes <ke...@gm...>]

Hi,

I want to execute an INSERT-query into a Microsoft Access-file.

I use:
- Debian-Linux as OS (kernel = 2.6.18-4-686-bigmem)
- unixODBC version 2.2.4
- libmdbtools (debian-package) => mdbtools: version 
0.5.99.0.6pre1.0.20050409-1
- I use Perl to write my scripts

I can SELECT records from my Access-DB perfectly, but when using INSERT 
in a query I always get "syntax error near INSERT" !  I'm quite sure of 
the INSERT-syntax itself...

My question: does this version of mdbtools support writing to Access 
MDB-files ?  anyone an idea what I'm doing wrong ?

Kind regards,

B.

[mdb-dev] mdb-export segfault when OLE field

[Seb <sp...@gm...>]

Hi,

I'm trying to script a migration of an M$ Access db to PosgreSQL.  The
db has tables where some fields contain OLE objects.  These are causing
mdb-export to segfault.  However, if I export the table from "gmdb2
0.6pre1", the table is exported fine, although the OLE object links in
the respective cells are replaced by garbage characters.  I really don't
care about those fields, and am ok with replacing those with an empty
string, which could be done by post-processing the output with other
tools.  However, how can I emulate "gmdb2 0.6pre1" behaviour so that the
table is completely exported?  I presume it uses mdb-export with some
appropriate combination of switches, but I can't figure out which.  Any
help would be appreciated.


Cheers,

-- 
Seb

Re: [mdb-dev] glib-error

[Roman M. <ka...@gi...>]

Hi

I didn’t use a binary. I built it myself from source.

I just noticed another error at the top. Please have a look:

 # ./autogen.sh --with-unixodbc
processing .
Running aclocal  ...
aclocal: configure.in: 106: macro `AM_PATH_GLIB_2_0' not found in library
Running libtoolize...
You should update your `aclocal.m4' by running aclocal.
Running autoheader...
autoheader: include/config.h.in is unchanged
Running automake --gnu  ...
configure.in: 5: `automake requires `AM_CONFIG_HEADER', not `AC_CONFIG_HEADER'
Running autoconf ...
configure.in:11: warning: AC_PROG_LEX invoked multiple times
configure.in:106: error: possibly undefined macro: AM_PATH_GLIB_2_0
Running ./configure --with-unixodbc ...
checking for a BSD compatible install... /usr/bin/install -c
[...]

I looked inside aclocal.m4. I don’t know, what I have to update. Do you?

Kind regards
Roman

Quoting Jeff Smith <why...@ya...>:

> It appears that the GLib 2 development package is not installed.
> On my Fedora machine, that is glib2-devel.  On an Ubuntu
> machine, I believe it would be glib2-dev.  I don't know for other
> systems.
> 
>  -- Jeff Smith
> 
> ----- Original Message ----
> From: Roman Meier <ka...@gi...>
> To: mdb...@li...
> Sent: Friday, March 7, 2008 9:37:56 AM
> Subject: [mdb-dev] glib-error
> 
> Hi list
> 
> I downloaded the csv, but get the following error using "./autogen.sh
> --with-unixodbc"
> 
> [...]
> checking for memory.h... yes
> checking for strings.h... yes
> checking for inttypes.h... yes
> checking for stdint.h... yes
> checking for unistd.h... (cached) yes
> checking for size_t... yes
> checking for iconv... yes
> checking for iconv declaration...
>          extern size_t iconv (iconv_t cd, char * *inbuf, size_t
> *inbytesleft,
> char * *outbuf, size_t *outbytesleft);
> checking Are we using flex ... yes
> ./configure: line 7366: syntax error near unexpected token
> `AM_PATH_GLIB_2_0(2.0.0)'
> ./configure: line 7366: `AM_PATH_GLIB_2_0(2.0.0)'
> #
> 
> Can you help me?
> 
> Kind regards
> Roman
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 
> 
> 
> 
> 
> 
>      
>
____________________________________________________________________________________
> Looking for last minute shopping deals?  
> Find them fast with Yahoo! Search. 
> http://tools.search.yahoo.com/newsearch/category.php?category=shopping

Re: [mdb-dev] glib-error

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

It appears that the GLib 2 development package is not installed.
On my Fedora machine, that is glib2-devel.  On an Ubuntu
machine, I believe it would be glib2-dev.  I don't know for other
systems.

 -- Jeff Smith

----- Original Message ----
From: Roman Meier <ka...@gi...>
To: mdb...@li...
Sent: Friday, March 7, 2008 9:37:56 AM
Subject: [mdb-dev] glib-error

Hi list

I downloaded the csv, but get the following error using "./autogen.sh
--with-unixodbc"

[...]
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... (cached) yes
checking for size_t... yes
checking for iconv... yes
checking for iconv declaration...
         extern size_t iconv (iconv_t cd, char * *inbuf, size_t *inbytesleft,
char * *outbuf, size_t *outbytesleft);
checking Are we using flex ... yes
./configure: line 7366: syntax error near unexpected token
`AM_PATH_GLIB_2_0(2.0.0)'
./configure: line 7366: `AM_PATH_GLIB_2_0(2.0.0)'
#

Can you help me?

Kind regards
Roman


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev






      ____________________________________________________________________________________
Looking for last minute shopping deals?  
Find them fast with Yahoo! Search.  http://tools.search.yahoo.com/newsearch/category.php?category=shopping

[mdb-dev] glib-error

[Roman M. <ka...@gi...>]

Hi list

I downloaded the csv, but get the following error using "./autogen.sh
--with-unixodbc"

[...]
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... (cached) yes
checking for size_t... yes
checking for iconv... yes
checking for iconv declaration...
         extern size_t iconv (iconv_t cd, char * *inbuf, size_t *inbytesleft,
char * *outbuf, size_t *outbytesleft);
checking Are we using flex ... yes
./configure: line 7366: syntax error near unexpected token
`AM_PATH_GLIB_2_0(2.0.0)'
./configure: line 7366: `AM_PATH_GLIB_2_0(2.0.0)'
#

Can you help me?

Kind regards
Roman

[mdb-dev] Comma as a separator in Italian Euro format

[fabio n. <na...@po...>]

Hi Everybody!

I'm having problems while using mdb-export against one of my
databases.

This is what I get:

user@host$ mdb-export -d"\t" test.mdb euro_table
FIELD0	EURO_VALUE
0	00000000696.
1	00000004000.
2	00000008133.
3	00000000800.

while the following output was expected:

FIELD0	EURO_VALUE
0	696,56
1	4000,34
2	8133,44
3	800,40

or

FIELD0	EURO_VALUE
0	696.56
1	4000.34
2	8133.44
3	800.40

This db has been made with Access using Italian localization. The
following notation for Euro currency is used:

450,75

instead of

450.75

Maybe this is the problem?

Any hints to handle this?

Kind Regards,

-- 
fabio natali

[mdb-dev] Mac OS X compile problem in 0.5 and 0.6pre1

[David M. <dma...@sc...>]

I run into two similar problems trying to compile either 0.5 or 0.6pre1 =
on
my Mac OS X (10.4) system: mdb_backends multiply defined.

With 0.5, I get:
gcc -dynamiclib -flat_namespace -undefined suppress -o
.libs/libmdb.0.0.0.dylib  catalog.lo mem.lo file.lo kkd.lo table.lo =
data.lo
dump.lo backend.lo money.lo sargs.lo index.lo like.lo write.lo stats.lo
-L/opt/local/lib -lglib-2.0 -lintl -liconv -lc -install_name
/usr/local/lib/libmdb.0.dylib -compatibility_version 1 -current_version =
1.0
ld: multiple definitions of symbol _mdb_backends
catalog.lo definition of _mdb_backends in section (__DATA,__common)
mem.lo definition of _mdb_backends in section (__DATA,__common)
file.lo definition of _mdb_backends in section (__DATA,__common)
kkd.lo definition of _mdb_backends in section (__DATA,__common)
table.lo definition of _mdb_backends in section (__DATA,__common)
data.lo definition of _mdb_backends in section (__DATA,__common)
backend.lo definition of _mdb_backends in section (__DATA,__common)
money.lo definition of _mdb_backends in section (__DATA,__common)
sargs.lo definition of _mdb_backends in section (__DATA,__common)
index.lo definition of _mdb_backends in section (__DATA,__common)
write.lo definition of _mdb_backends in section (__DATA,__common)
stats.lo definition of _mdb_backends in section (__DATA,__common)
/usr/libexec/gcc/i686-apple-darwin8/4.0.1/libtool: internal link edit
command failed
make: *** [libmdb.la] Error 1

With 0.6pre1 I get:
 gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include
-I/opt/local/include/glib-2.0 -I/opt/local/lib/glib-2.0/include
-I/opt/local/include -g -O2 -DSQL -DUNIXODBC -MT backend.lo -MD -MP -MF
.deps/backend.Tpo -c backend.c  -fno-common -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[1]: *** [all-recursive] Error 1
make: *** [all-recursive] Error 1

What should I do differently?

I checked the archives and it looks like this has been encountered in =
the
past but fixed. Any help will be appreciated. Thank you.

Regards,

    David.

Re: [mdb-dev] UTF8 patch

[wfpearson <wfp...@gm...>]

Jarl Friis-2 wrote:
> 
> Hi.
> 
> I have updated the earlier UTF8 patch to the latest CVS, see
> http://sourceforge.net/tracker/index.php?func=detail&aid=1829259&group_id=2294&atid=302294
> 
> It seems like the project is very dead, could someone elaborate...
> 
> Jarl
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 
> 

-- 
View this message in context: http://www.nabble.com/UTF8-patch-tp13685976p14888249.html
Sent from the MDB Tools - Dev mailing list archive at Nabble.com.

Re: [mdb-dev] Building Without Gnome

[Rich S. <rsh...@ap...>]

On Tue, 4 Dec 2007, Dane Springmeyer wrote:

> try:
>
> --disable-gmdb2

Dane,

   Thank you, I will ... when I return from a business trip.

> Also, from reading the list archives it seems that there is good reason to 
> checkout from cvs (which requires building with autogen and getting 
> libtool, automake, and autoconf)

   There's just one stumbling block (which I can fix): I use subversion so I
don't have cvs installed.

Much appreciated,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863

Re: [mdb-dev] Building Without Gnome

[Dane S. <bl...@ha...>]

Hi Rich,

try:

--disable-gmdb2

Also, from reading the list archives it seems that there is good  
reason to checkout from cvs (which requires building with autogen and  
getting libtool, automake, and autoconf)

My build process was:

downloaded and compiled unixODBC, iODBC, libtool, automake, autoconf  
(and glib and pkg-config since I have a wierd setup) then:

cvs -d:pserver:ano...@md...:/cvsroot/ 
mdbtools login
cvs -z3 -d:pserver:ano...@md...:/cvsroot/ 
mdbtools co mdbtools
cd mdbtools
./autogen.sh --prefix=/home/dspringmeyer/usr/local --with-iodbc=/home/ 
dspringmeyer/usr/local --with-unixodbc=/home/dspringmeyer/usr/local -- 
disable-gmdb2

In the configure output I get:
....
checking for GNOME... configure: gmdb2 disabled
....

which I think is what you are looking for, since gmdb2 is (at least  
one of) the gui(s)


Cheers,

Dane





On Dec 4, 2007, at 1:06 PM, Rich Shepard wrote:

>    Some of our prospective clients have data in Access .mdb format,  
> and we
> can help them by converting those data to another format. Today I  
> discovered
> MDB Tools, and tried building both 0.5 and 0.6pre1, but both failed  
> because
> I do not have Gnome installed. However, libglade is installed here.
>
>    I have run only Xfce and have found that trying to install Gnome on
> Slackware is so much of a PITA that I won't waste more time trying.
>
>    Is there a way to build mdb-tools so we can use the command line
> conversion API without the GUI which requires Gnome?
>
> Thanks,
>
> Rich
>
> -- 
> Richard B. Shepard, Ph.D.               |  Integrity             
> Credibility
> Applied Ecosystem Services, Inc.        |            Innovation
> <http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax:  
> 503-667-8863
>
> ---------------------------------------------------------------------- 
> ---
> SF.Net email is sponsored by: The Future of Linux Business White Paper
> from Novell.  From the desktop to the data center, Linux is going
> mainstream.  Let it simplify your IT future.
> http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] Building Without Gnome

[Rich S. <rsh...@ap...>]

   Some of our prospective clients have data in Access .mdb format, and we
can help them by converting those data to another format. Today I discovered
MDB Tools, and tried building both 0.5 and 0.6pre1, but both failed because
I do not have Gnome installed. However, libglade is installed here.

   I have run only Xfce and have found that trying to install Gnome on
Slackware is so much of a PITA that I won't waste more time trying.

   Is there a way to build mdb-tools so we can use the command line
conversion API without the GUI which requires Gnome?

Thanks,

Rich

-- 
Richard B. Shepard, Ph.D.               |  Integrity            Credibility
Applied Ecosystem Services, Inc.        |            Innovation
<http://www.appl-ecosys.com>     Voice: 503-667-4517      Fax: 503-667-8863