mdbtools-dev

[mdb-dev] building on osx

[Rhett G. <rh...@gm...>]

Trying to build mdbtools on osx. 'configure' worked, seemed to find
everything it needed. Got the following linker error:

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)
ld: warning multiple definitions of symbol _locale_charset
/opt/local/lib/libiconv.dylib(localcharset.o) definition of _locale_charset
/opt/local/lib/libintl.dylib(localcharset.o) definition of _locale_charset
/usr/bin/libtool: internal link edit command failed
make[2]: *** [libmdb.la] Error 1
make[1]: *** [all-recursive] Error 1
make: *** [all-recursive] Error 1

Any ideas on how to make this work?

Thanks,

Rhett

Re: [mdb-dev] segfault in mdb-export (CVS 05.05.2005)

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

I finally got this bug tracked down and fixed.  I have committed the fixes to cvs, so I
expect it to appear on anonymous cvs by the time you read this.

 -- Jeff Smith


--- Mario Ohnewald <mar...@gm...> wrote:
> Hello List!
> 
> I am running Debian sid, cvs from 05.05.2005, and i get this segfault
> when i want to export a table:
> 
> shell command: /usr/local/bin/mdb-export -H -I file.pck ABFDok
> 
> spiekey@SpiekLap:~$ gdb
> 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 "i386-linux".
> (gdb) file /usr/local/bin/mdb-export
> Reading symbols from /usr/local/bin/mdb-export...done.
> Using host libthread_db library "/lib/tls/libthread_db.so.1".
> (gdb) run -H -I file.pck ABFDok
> Starting program: /usr/local/bin/mdb-export -H -I file.pck ABFDok
> Unhandled memo field flags = 3a
> 
> Program received signal SIGSEGV, Segmentation fault.
> 0x4012adb6 in free () from /lib/tls/libc.so.6
> (gdb) backtrace
> #0  0x4012adb6 in free () from /lib/tls/libc.so.6
> #1  0x40062a84 in g_free () from /usr/lib/libglib-2.0.so.0
> #2  0x4001e288 in mdb_xfer_bound_data (mdb=0x804b508, start=1179403647,
> col=0x4002549f, len=1) at data.c:222
> #3  0x4001e484 in _mdb_attempt_bind (mdb=0x804b508, col=0x1, isnull=0
> '\0', offset=1703, len=12) at data.c:301
> #4  0x4001e415 in mdb_read_row (table=0x80725e0, row=0) at data.c:279
> #5  0x4001e71e in mdb_fetch_row (table=0x80725e0) at data.c:397
> #6  0x08048d36 in main (argc=162, argv=0xbffff8c4) at mdb-export.c:147
> 
> Unfortunately i cant upload the db file for you, so you could test and
> debug it.
> Any idea what causes this segfault?
> What else do you need to know?
> 
> Thanks, Mario


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[mdb-dev] ODBC crash on SELECT

[Martin S. <kv...@gm...>]

Hello,
I encountered 'segmentation fault' with mdbtools odbc layer usage
(SELECT of a NUMERIC(9) value). It does not occur on other mdbtools
parts.

I have put it down as a sf bug tracker item:
http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D1218830&group_=
id=3D2294&atid=3D102294

Martin

[mdb-dev] exporting from read-only databases

[Ilya S. <il...@bl...>]

I have encountered a number of MsAccess databases for which
  1. mdb-tables reports
  "The file does not appear to be an access database"

  2. MsAccess opens them fine (without asking for passwords) but they are
   read-only...

The solution was to apply earlier David Mansfield's encryption
patch (don't know how/why read-onliness is connected with encryption).

However, the patch had to be adjusted to the current
source... So here is the updated version of patch...

Disclaimer: the patch solved my problem, but I don't know enough about
MsAccess file structure to judge whether the patch is generally
applicable.

Ilya

[mdb-dev] MDBTools and DataTypes -Memo, YESNO

[<moo...@po...>]

Hallo, 

I've got problems with Data Types such as Memo and YesNo. I want to import MSACCESS Database into Firebird 1.5 using php 4.0 ODBC Functions.
Everything goes fine but function ODBC_RESULT doesn't  return any values saved in Memo Field and in YesNo field.
Would you like to give me some solutions for this problem?
 
Looking forward for your reply
Krzylo

Re: [mdb-dev] mdbtools' license (LGPL or GPL)

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

--- Alexandre Horst <ale...@op...> wrote:
> What is the license of mdbtools? I saw in
> http://sourceforge.net/projects/mdbtools that mdbtools has a mixture of
> LGPL and GPL licenses. Which parts of mdbtools are bearing GPL? 

It is primarily LGPL.  gmdb2 (src/gmdb2) and assorted utilities (src/util) are GPL.

 -- Jeff Smith

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[mdb-dev] building mdbtools without autconf/configure

[Ilya S. <il...@bl...>]

Good morning/evening,

Not sure whether this deserves to be in documentation/be part of the
source/or is just a useless curiousity....

Anyway, when I tried to build mdbtools on RH7.3, it turned out that I need
a newer autoconf, after trying and failing to update autoconf, I
tried to build mdbtools without it and it turned out to be a matter of a
 10-line script...The script is below, maybe it would be useful for
someone/somewhere...

#!/usr/bin/python
import os,sys
def run(cmd):
    print cmd
    status=os.system(cmd)
    assert  status ==0, "command failed"

run("echo '#define MDB_FULL_VERSION \"CVS051105\"' >include/mdbver.h")
run("touch include/config.g")
GLIB_INCL="-I../../include -I/usr/include/glib-2.0 -I/usr/lib/glib-2.0/include"
if not os.path.exists("bin"):
    os.mkdir("bin")

os.chdir("src/libmdb")
run("gcc -c %(GLIB_INCL)s *.c" % vars())
#run("ar r libmdb.a *.o")
os.chdir("../../")

os.chdir("src/util")
for tool in ("mdb-ver", "mdb-tables", "mdb-export", "mdb-schema",
             "mdb-check", "prtable", "prdump", "prdata"):
    run("gcc  %(GLIB_INCL)s -ldl -lm ../libmdb/*.o -lglib-2.0 %(tool)s.c -o../../bin/%(tool)s"
        %vars())

Does this brute force build method deserve to be mentioned in installation
guide?

Ilya

[mdb-dev] Column and accents

[Heraud K. <her...@gm...>]

Hello,=20

I use mdbtools 0.6, PHP 5.0.4 and unixODBC.
I have a base Access with names of columns which uses accents and others.=
=20
(N=B0_Candidat_DESS, Civilit=E9_Candidat_DESS...).
When I do a request, I have this kind of message:=20

Error At Line: parse error near =E9=20

Which is the solution?

thank you

[mdb-dev] semicolons are missing in INSERT statements

[Mario O. <mar...@gm...>]

Hello List,

the mdb-export gave me the following lines/export:

INSERT INTO AfATabel (AfATabelleCode, AfATabelleLand, AfATabelleName,
AfATabelleND, AfATabelleP, AfATabelleGr, AfATabelleHandle,
AfATabelleOriginal) VALUES ("00",41,"AfA-Tabellen",0,0.0000,0,0,1)

INSERT INTO AfATabel (AfATabelleCode, AfATabelleLand, AfATabelleName,
AfATabelleND, AfATabelleP, AfATabelleGr, AfATabelleHandle,
AfATabelleOriginal) VALUES ("01",41,"AfA-Tabelle
Finanzamt",0,0.0000,0,0,1)

INSERT INTO AfATabel (AfATabelleCode, AfATabelleLand, AfATabelleName,
AfATabelleND, AfATabelleP, AfATabelleGr, AfATabelleHandle,
AfATabelleOriginal) VALUES ("01.01",41,"Gebäude",0,0.0000,0,300,1)

... (loads more, about 10000 lines)...

but a semicolon is missing at the end of each INTERT INTO statements.

Is this normal? How could i fix this?

Thanks, Mario

[mdb-dev] semicolons are missing in INSERT statement

[Mario O. <moh...@th...>]

Hello List,

the mdb-export gave me the following lines/export:

INSERT INTO AfATabel (AfATabelleCode, AfATabelleLand, AfATabelleName,
AfATabelleND, AfATabelleP, AfATabelleGr, AfATabelleHandle,
AfATabelleOriginal) VALUES ("00",41,"AfA-Tabellen",0,0.0000,0,0,1)

INSERT INTO AfATabel (AfATabelleCode, AfATabelleLand, AfATabelleName,
AfATabelleND, AfATabelleP, AfATabelleGr, AfATabelleHandle,
AfATabelleOriginal) VALUES ("01",41,"AfA-Tabelle
Finanzamt",0,0.0000,0,0,1)

INSERT INTO AfATabel (AfATabelleCode, AfATabelleLand, AfATabelleName,
AfATabelleND, AfATabelleP, AfATabelleGr, AfATabelleHandle,
AfATabelleOriginal) VALUES ("01.01",41,"Gebäude",0,0.0000,0,300,1)

... (loads more, about 10000 lines)...

but a semicolon is missing at the end of each INTERT INTO statements.

Is this normal? How could i fix this?

Thanks, Mario

[mdb-dev] mdbtools' license (LGPL or GPL)

[Alexandre H. <ale...@op...>]

Hi mdbtools creators,

What is the license of mdbtools? I saw in
http://sourceforge.net/projects/mdbtools that mdbtools has a mixture of
LGPL and GPL licenses. Which parts of mdbtools are bearing GPL? 

Regard
Alexandre Horst

Re: [mdb-dev] segfault in mdb-export (CVS 05.05.2005)

[Mario O. <mar...@gm...>]

On Sat, 2005-05-07 at 12:56 -0700, Jeff Smith wrote:
> --- Mario Ohnewald <mar...@gm...> wrote:
> > Hello List!
> > 
> > I am running Debian sid, cvs from 05.05.2005, and i get this segfault
> > when i want to export a table:
> > 
> > shell command: /usr/local/bin/mdb-export -H -I file.pck ABFDok
> 
> > Unfortunately i cant upload the db file for you, so you could test and
> > debug it.
> > Any idea what causes this segfault?
> > What else do you need to know?
> > 

Could anyone please help me?
Maybe someone who is familiar with the sourcecode so that we can debug
it?!

Thanks, Mario

Re: [mdb-dev] segfault in mdb-export (CVS 05.05.2005)

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

--- Mario Ohnewald <mar...@gm...> wrote:
> Hello List!
> 
> I am running Debian sid, cvs from 05.05.2005, and i get this segfault
> when i want to export a table:
> 
> shell command: /usr/local/bin/mdb-export -H -I file.pck ABFDok

> Unfortunately i cant upload the db file for you, so you could test and
> debug it.
> Any idea what causes this segfault?
> What else do you need to know?
> 
> Thanks, Mario

Mario,

First, I am not familiar with the .pck extension.  What program generated this file?  Can
you send me any other examples of pck files so I can compare their structure with
standard mdb files?

 -- Thanks
 -- Jeff Smith


		
__________________________________ 
Do you Yahoo!? 
Read only the mail you want - Yahoo! Mail SpamGuard. 
http://promotions.yahoo.com/new_mail 

[mdb-dev] segfault in mdb-export (CVS 05.05.2005)

[Mario O. <mar...@gm...>]

Hello List!

I am running Debian sid, cvs from 05.05.2005, and i get this segfault
when i want to export a table:

shell command: /usr/local/bin/mdb-export -H -I file.pck ABFDok

spiekey@SpiekLap:~$ gdb
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 "i386-linux".
(gdb) file /usr/local/bin/mdb-export
Reading symbols from /usr/local/bin/mdb-export...done.
Using host libthread_db library "/lib/tls/libthread_db.so.1".
(gdb) run -H -I file.pck ABFDok
Starting program: /usr/local/bin/mdb-export -H -I file.pck ABFDok
Unhandled memo field flags = 3a

Program received signal SIGSEGV, Segmentation fault.
0x4012adb6 in free () from /lib/tls/libc.so.6
(gdb) backtrace
#0  0x4012adb6 in free () from /lib/tls/libc.so.6
#1  0x40062a84 in g_free () from /usr/lib/libglib-2.0.so.0
#2  0x4001e288 in mdb_xfer_bound_data (mdb=0x804b508, start=1179403647,
col=0x4002549f, len=1) at data.c:222
#3  0x4001e484 in _mdb_attempt_bind (mdb=0x804b508, col=0x1, isnull=0
'\0', offset=1703, len=12) at data.c:301
#4  0x4001e415 in mdb_read_row (table=0x80725e0, row=0) at data.c:279
#5  0x4001e71e in mdb_fetch_row (table=0x80725e0) at data.c:397
#6  0x08048d36 in main (argc=162, argv=0xbffff8c4) at mdb-export.c:147



Unfortunately i cant upload the db file for you, so you could test and
debug it.
Any idea what causes this segfault?
What else do you need to know?

Thanks, Mario

Re: [mdb-dev] Convert Access DB into a MySQL DB

[Mario O. <mar...@gm...>]

Hello Dave, 

On Fri, 2005-05-06 at 14:12 +0000, david whiting wrote:
> For me just calling mdb-tables with the name of the DB gives me the
> tables. For example:
> 
> mdb-tables Nwind.mdb 
> 
> gives me:
> 
> Order Details Orders Products Shippers Categories Customers Employees Suppliers 

mdb-tables file.pck
ABFBaum AfATabel clItem GEVOBaum sABFKons sBilzTxt sBuchArt sBuchTxt
sEUERTxt sFestKto sMahn sPersKto sSchlBez sStVor sUstVor TBSBaum sFibuK
sSachKto sStTab sZvkK sFKonst Waehrung bFibuHd SendArt
tmpAuktionDocStTmp ABFDruck Inventur SeitInv SeitIPos WEBuch EABPWEBuch
EABPRABuch EABPBuchJournal EABPKtoBlatt tKasBuch tKasSplit
tKasStueckelung sAnlHist sAusw AbgrBuch sAnlagen SAfATab SJAfA AbgrBetr
AbBetr2 IFBProt UserProt sHBank sBankVb sperskom sperskor MahnPositionen
sKzBaum bSalden sKassen ToDo Favoriten sClKonst DOB tSVAssist tKasTrans
sBelArt sGrundl DbProt LastBuH LastBuN sZusatzZeilen ABFMe ABFRabat Tbs
sArtikel ArtLief ArtVerw ArtStat ArtMenge artbeweg StckList ArtPreis
PrsStaff ABFProj Zuschlag ABFDok ABFDokWK ABFPos ABFPosWK ABFTZ ABFPStat
AbfStat RABuch TUBuch ABFStapl RappProj BestDok BestPos BestStat
AcontoBuchung InvFortschritt WebShop WebShopCatalogTreeNew
WebShopCatalogTree tNebenZeileWK sEBImpGrundlagen bEBImport sVorlauf
sBeschr sBuch Elster_Grundl Elster_Main sZKD sInkasso tmpPersKtoSelA
tmpPersKtoSelB TempArtNr sZvkS VZ ZScheck ZDDTA ZASCII VESRDaten ZOnline
TMailAccounts WebShopItems WebShopIDs OrderDoc OrderPos
WebShopBankeinzug ProvData PrsFest sAfterbuyKons ArtAenderCalc
Preisschwellen ProjInf PCFBImport bBuchung bBuchSub bOpoMain bOpoSub
OpProt bPrAntBuch tWKBuch tHauptzeileWK tWKBuchSub TMailDocTypes
TMailDocuments TMailConfig bZList BOPZahl Abgleich Abgl_OP ZAbglDat
BSmlZlg BZahl DlgDaten

So i guess that worked ;)

> 
> Can you give the exact error message? 
I did a screenshot of the access error message (in german), but i guess
its not intresting anymore at this point.

> And just out of interest are you
> using the C or java version and what is your OS?
I am running Debian sid, with the latest mdb tools (cvs version from
05.05.2005).



Do i now follow your next steps?

ii) mdb-schema -T Orders accessDB mysql
iii) mdb-export  to dump the data.

$ mdb-schema -T ABFBaum file.pck mysql
-------------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2004 Brian Bruns
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-------------------------------------------------------------

DROP TABLE ABFBaum;
CREATE TABLE ABFBaum
 (
        ABFBaumCode                     varchar (40),
        ABFBaumEbene                    int,
        ABFBaumName                     varchar (31),
        ABFBaumDtnrmWrg                 varchar (23)
);
-- CREATE ANY INDEXES ...



-- CREATE ANY Relationships ...

-- relationships are not supported for mysql


Any idea?

Thanks, Mario

Re: [mdb-dev] Convert Access DB into a MySQL DB

[Horst K. <md...@kn...>]

Am Donnerstag 05 Mai 2005 20:22 schrieb Mario Ohnewald:
> Now, how do i proceed? Which tool do i need to convert my access file
> into a mysql db?
If mdbtools can read your mdb file you might want to use knoda 
(http://www.knoda.org) to export your data to Mysql

Horst

Re: [mdb-dev] Convert Access DB into a MySQL DB

[Mario O. <mar...@gm...>]

On Fri, 2005-05-06 at 07:31 +0000, david whiting wrote:
> Hi Mario,
> 
> I haven't used mdb-tools for a while so I might be getting a bit rusty
> and I have an old version from CVS (I haven't had to work with an
> access file for a while). But, if I remember correctly,  if your DB is
> called 'accessDB' you should be able to use:
> 
> i) mdb-tables accessDB 

How can i find out the tables in the file?
I have tried to open it with M$ Access 2003, but got an error that i
would need the privileges to do so, and to make sure the DB isnt locked
or something.

I am Administrator, and the file is fully r/w by the user.


Thanks, Mario

[mdb-dev] Convert Access DB into a MySQL DB

[Mario O. <mar...@gm...>]

Hello List,

i have a little Jet DB (Access) file here which i would like to convert
to a mysql database.

I have compiled and installed the latest cvs version successfully.

Now, how do i proceed? Which tool do i need to convert my access file
into a mysql db?

Thansk, Mario

Re: [mdb-dev] dynamic link problem with libmdb

[Pascal H. <a.h...@ch...>]

04/05/05 20:41, Jeff Smith wrote:

> The libtool files that 'shipped' with mdbtools 0.6pre1 builds the
> libraries with bad names, and ldconfig was not recognizing that
> these were shared libraries when building its cache.

Yes, this did the trick, thanks.

I suspected that the library names were incorrect, but I wasn't sure
and didn't know how to fix it in any case. Anyhow things work fine
now.

Thanks,
Pascal.

Re: [mdb-dev] dynamic link problem with libmdb

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

--- Pascal Haakmat <a.h...@ch...> wrote:
> Hi,
> 
> I've compiled and installed mdbtools-0.6pre1, but have run into a
> little snag (garnome-env, attached, is a small shell script which
> modifies a few environment variables, since my glib/gtk+ 2 install is
> at a non-standard place):
> 
> $ garnome-env mdb-schema  
> mdb-schema: error while loading shared libraries: libmdb.0: cannot
> open shared object file: No such file or directory
> 
> ldconfig doesn't seem to "pick up" libmdb in /usr/local/lib, even
> though it is clearly there and other libraries in that directory work
> fine:

Pascal,

The libtool problem strikes again!  We really need a 0.6pre2.

Here is what I would suggest: first, remove the mdb libraries
that are out there now.  Then go to you mdbtools build directory,
do a 'make distclean', a 'libtoolize --force --copy'.  You can
now redo the usual configure, make, make install.

The libtool files that 'shipped' with mdbtools 0.6pre1 builds the
libraries with bad names, and ldconfig was not recognizing that
these were shared libraries when building its cache.

 -- Jeff Smith

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [mdb-dev] dynamic link problem with libmdb

[Pascal H. <a.h...@ch...>]

04/05/05 14:28, Martin Ellis wrote:

> Why not add /usr/local/lib to this line?
> 
> LD_LIBRARY_PATH=$GARNOME/lib:$LD_LIBRARY_PATH
> 
> so....
> LD_LIBRARY_PATH=$GARNOME/lib:/usr/local/lib:$LD_LIBRARY_PATH
> 
> You could alternatively play with ld.so.config or whatever, but you'd have
> to look at the man pages....

/usr/local/lib is in /etc/ld.so.conf.

Thanks
Pascal.

Re: [mdb-dev] dynamic link problem with libmdb

[Lenny L. <lle...@ma...>]

You can add /usr/local/lib to /etc/ld.so.config (or /etc/ld.so.conf) and 
re-run ldconfig.

--
Lenny

Martin Ellis wrote:
> On Wednesday 04 May 2005 13:21, Pascal Haakmat wrote:
>>ldconfig doesn't seem to "pick up" libmdb in /usr/local/lib, even
>>though it is clearly there and other libraries in that directory work
>>fine:
> 
> 
> Why not add /usr/local/lib to this line?
> 
> LD_LIBRARY_PATH=$GARNOME/lib:$LD_LIBRARY_PATH
> 
> so....
> LD_LIBRARY_PATH=$GARNOME/lib:/usr/local/lib:$LD_LIBRARY_PATH
> 
> You could alternatively play with ld.so.config or whatever, but you'd have
> to look at the man pages....
> 
> Martin
> 

Re: [mdb-dev] dynamic link problem with libmdb

[Martin E. <m.a...@nc...>]

On Wednesday 04 May 2005 13:21, Pascal Haakmat wrote:
> I've compiled and installed mdbtools-0.6pre1, but have run into a
> little snag (garnome-env, attached, is a small shell script which
> modifies a few environment variables, since my glib/gtk+ 2 install is
> at a non-standard place):
>
> $ garnome-env mdb-schema
> mdb-schema: error while loading shared libraries: libmdb.0: cannot
> open shared object file: No such file or directory
>
> ldconfig doesn't seem to "pick up" libmdb in /usr/local/lib, even
> though it is clearly there and other libraries in that directory work
> fine:

Why not add /usr/local/lib to this line?

LD_LIBRARY_PATH=$GARNOME/lib:$LD_LIBRARY_PATH

so....
LD_LIBRARY_PATH=$GARNOME/lib:/usr/local/lib:$LD_LIBRARY_PATH

You could alternatively play with ld.so.config or whatever, but you'd have
to look at the man pages....

Martin

[mdb-dev] dynamic link problem with libmdb

[Pascal H. <a.h...@ch...>]

Hi,

I've compiled and installed mdbtools-0.6pre1, but have run into a
little snag (garnome-env, attached, is a small shell script which
modifies a few environment variables, since my glib/gtk+ 2 install is
at a non-standard place):

$ garnome-env mdb-schema  
mdb-schema: error while loading shared libraries: libmdb.0: cannot
open shared object file: No such file or directory

ldconfig doesn't seem to "pick up" libmdb in /usr/local/lib, even
though it is clearly there and other libraries in that directory work
fine:

$ garnome-env ldd /usr/local/bin/mdb-schema 
libmdb.0 => not found
libm.so.6 => /lib/i686/libm.so.6 (0x40027000)
libglib-2.0.so.0 => /usr/local/garnome/lib/libglib-2.0.so.0 (0x40049000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x400c4000)
libreadline.so.4 => /usr/lib/libreadline.so.4 (0x40106000)
libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

$ ls /usr/local/lib/libmdb*
/usr/local/lib/libmdb        /usr/local/lib/libmdbsql
/usr/local/lib/libmdb.0      /usr/local/lib/libmdbsql.0
/usr/local/lib/libmdb.0.0.0  /usr/local/lib/libmdbsql.0.0.0
/usr/local/lib/libmdb.a      /usr/local/lib/libmdbsql.a
/usr/local/lib/libmdb.la     /usr/local/lib/libmdbsql.la

However, when I first cd to /usr/local/lib, suddenly things do work:

$ cd /usr/local/lib
$ garnome-env ldd /usr/local/bin/mdb-schema 
libmdb.0 => libmdb.0 (0x40013000)
libm.so.6 => /lib/i686/libm.so.6 (0x40041000)
libglib-2.0.so.0 => /usr/local/garnome/lib/libglib-2.0.so.0 (0x40063000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x400de000)
libreadline.so.4 => /usr/lib/libreadline.so.4 (0x40120000)
libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)

Since having to first cd to /usr/local/lib is kind of a nuisance I was
hoping somebody here might know what is going on here and how to solve
it.

Thanks,
Pascal.

Re: [mdb-dev] Linked Tables

[Brian B. <bri...@gm...>]

Oops, this should have gone to list.  Gmail doesn't always do the
right things with list mail...maybe a setting someplace.
---
Hi,

Are you referring to linked tables from one access database to
another, or to an ODBC datasource?  For linked tables (the former
kind) to be of any use, we would really need to support joins.

Brian

On 4/18/05, Phil Mayes <phi...@gm...> wrote:
> Hi,
>=20
> Like many others I've found mdb-tools and think it is indeed a great
> and well-needed piece of software, very well done.
>=20
> I'm connecting to an MDB on a mounted windows share from a Fedora Core
> box and have been able to pull the data that I need so far.
>=20
> I know that linked tables is one feature that is mentioned for future
> release, but I was just wondering how soon/close this is to being
> available?
>=20
> I'd also like to contribute to the project as it looks like something
> I'll be needing to use in my work and would like help others to
> leverage this great software as they require.
>=20
> Regards,
>=20
> Phil
>=20
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_ide95&alloc_id=14396&opclick
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>