newcomer wonders about reading contents of queries and reports

[Godfrey Nix]

Hi,

I have just joined this group, having downloaded mdb-utils a couple of nights
ago. I have already imported the data from one of its tables (all 10600
records) into a mysql table. It only took one minute to do it all. great!!

Now, a question. I can see there are reports and queries by using gmdb2 but I
need to know the content of them (so that I can replicate the queries in
mysql database, or give functional equivalents for each of them). How do I
begin to look at the queries or reports?

Godfrey

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

[Dane Springmeyer]

Hopefully someone can help here:

I am tring to build mdbtools from cvs (I've also tried the prerelease  
using the same methods) and I keep on getting an error in the  
configure step.

It is:

__________

checking for GLIB - version >= 2.0.0... no
*** Could not run GLIB test program, checking why...
*** The test program failed to compile or link. See the file  
config.log for the
*** exact error that occured. This usually means GLIB is incorrectly  
installed.

glib 2.0 is required by MDB Tools.
It can be downloaded at www.gtk.org
__________

I am installing on Debian Linux on a remote server and I don't even  
need glib or any of the graphical tools. I just need to compile  
mdbtools with odbc support for use with the gdal PGEO driver, to  
convert ms access/ESRI geodatabases to csv output.

I have tried both installing glib-2.12.0 and pointing mdbtools to the  
glib.h file in my directory : /home/dspringmeyer/usr/local/glib-2.0  
and I have tried disabling glib as ./configure --help explains.

Neither of these options help and I am still prevented from a  
successful configure step.

Anyone have any ideas how to hack the source files to *truly* diable  
the glib check?  Or any other ideas on a way to help?



Thanks,

Dane


ps. full error below:



------




[tropicana]$ ./autogen.sh --prefix=/home/dspringmeyer/usr/local --
disable-glibtest --with-iodbc=/home/dspringmeyer/usr/local --with-
unixodbc=/home/dspringmeyer/usr/local  --disable-gmdb2
processing .
Running aclocal  ...
Running libtoolize...
Running autoheader...
Running automake --gnu  ...
Running autoconf ...
Running ./configure --prefix=/home/dspringmeyer/usr/local --disable-
glibtest --with-iodbc=/home/dspringmeyer/usr/local --with-unixodbc=/
home/dspringmeyer/usr/local --disable-gmdb2 ...
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking whether make sets $(MAKE)... (cached) yes
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for a sed that does not truncate output... /bin/sed
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognize dependent libraries... pass_all
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking how to run the C++ preprocessor... g++ -E
checking for g77... g77
checking whether we are using the GNU Fortran 77 compiler... yes
checking whether g77 accepts -g... yes
checking the maximum length of command line arguments... 98304
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc static flag -static works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared  
libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld) supports shared  
libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ static flag -static works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared  
libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
appending configuration tag "F77" to libtool
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for g77 option to produce PIC... -fPIC
checking if g77 PIC flag -fPIC works... yes
checking if g77 static flag -static works... yes
checking if g77 supports -c -o file.o... yes
checking whether the g77 linker (/usr/bin/ld) supports shared  
libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking for flex... flex
checking lex output file root... lex.yy
checking lex library... -lfl
checking whether yytext is a pointer... yes
checking for bison... bison -y
checking for ANSI C header files... (cached) yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking limits.h usability... yes
checking limits.h presence... yes
checking for limits.h... yes
checking for unistd.h... (cached) yes
checking wordexp.h usability... yes
checking wordexp.h presence... yes
checking for wordexp.h... yes
checking for an ANSI C-conforming const... 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
checking for SQLGetPrivateProfileString in -liodbcinst... yes
checking for SQLGetPrivateProfileString in -lodbcinst... yes
checking for pkg-config... /usr/bin/pkg-config
checking for GLIB - version >= 2.0.0... no
*** Could not run GLIB test program, checking why...
*** The test program failed to compile or link. See the file  
config.log for the
*** exact error that occured. This usually means GLIB is incorrectly  
installed.

glib 2.0 is required by MDB Tools.
It can be downloaded at www.gtk.org.

-------------------------------------------------------------------------
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
mdbtools-dev@...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[Jeff Smith-3]

Some parts of this message have been removed. Learn more about Nabble's security policy.

First, despite what may be inferred from the configure script, glib is required.
Second, glib is used for data structures and other foundational functions, but
has nothing to do with graphics (except that the gtk+ toolkit does use it as a
foundation).

Did you install glib using Debian packages (via dpkg or apt-get) or by
compiling/installing?  If you used the Debian packages, did you get the -dev
package (i.e. libglib2.0-dev)?  In either case, did a glib-2.0.pc file get
installed?  If glib was installed from Debian packages, it should be located
in /usr/lib/pkgconfig .

 -- Jeff Smith

----- Original Message ----
From: Dane Springmeyer <blake@...>
To: mdbtools-dev@...
Sent: Saturday, December 1, 2007 5:40:03 PM
Subject: [mdb-dev] configure fails due to glib test, even when "disabled"

Hopefully someone can help here:

I am tring to build mdbtools from cvs (I've also tried the prerelease 
using the same methods) and I keep on getting an error in the 
configure step.

It is:

__________

checking for GLIB - version >= 2.0.0... no
*** Could not run GLIB test program, checking why...
*** The test program failed to compile or link. See the file 
config.log for the
*** exact error that occured. This usually means GLIB is incorrectly 
installed.

glib 2.0 is required by MDB Tools.
It can be downloaded at www.gtk.org
__________

I am installing on Debian Linux on a remote server and I don't even 
need glib or any of the graphical tools. I just need to compile 
mdbtools with odbc support for use with the gdal PGEO driver, to 
convert ms access/ESRI geodatabases to csv output.

I have tried both installing glib-2.12.0 and pointing mdbtools to the 
glib.h file in my directory : /home/dspringmeyer/usr/local/glib-2.0 
and I have tried disabling glib as ./configure --help explains.

Neither of these options help and I am still prevented from a 
successful configure step.

Anyone have any ideas how to hack the source files to *truly* diable 
the glib check?  Or any other ideas on a way to help?



Thanks,

Dane

---

Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
-------------------------------------------------------------------------
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
mdbtools-dev@...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[Dane Springmeyer]

Hi Jeff,

 Thanks for the clarification. That's helpful, now I know to persist in getting mdbtools to find glib.

I installed, compiled, and built using:

wget ftp://ftp.gtk.org/pub/glib/2.12/glib-2.12.0.tar.gz

tar xzvf glib-2.12.0

cd glib-2.12.0

./configure --prefix=/home/dspringmeyer/usr/local

make

make install

The prefix is key because I don't have root access. But the glib build worked fine I thought. I have within my home/dspringmeyer/ directory:

usr/local/lib/glib-2.0/include/glibconfig.h

usr/local/lib/pkgconfig/glib-2.0.pc

usr/local/lib/pkgconfig/glib-2.0.pc

usr/local/lib/libglib-2.0.la

usr/local/lib/libglib-2.0.so

usr/local/lib/libglib-2.0.so.0

usr/local/lib/libglib-2.0.so.o.1200.0

So where would be the right place to point --with-glib ???

With no success I've tried:

--with-glib=/home/dspringmeyer/usr/local/lib

--with-glib=/home/dspringmeyer/usr/local/glib-2.0

--with-glib=/home/dspringmeyer/usr/local/lib/pkgconfig/

I am also getting these lines right before the error:

checking for pkg-config... /usr/bin/pkg-config

checking for GLIB - version >= 2.0.0... no

*** Could not run GLIB test program, check

Do I need to set the pkg-config directory seen above to this?: /home/dspringmeyer/usr/local/lib/pkgconfig/

And if so, how would I do that within the ./configure command?

Thanks,

Dane

On Dec 2, 2007, at 1:53 PM, Jeff Smith wrote:

First, despite what may be inferred from the configure script, glib is required.
Second, glib is used for data structures and other foundational functions, but
has nothing to do with graphics (except that the gtk+ toolkit does use it as a
foundation).

Did you install glib using Debian packages (via dpkg or apt-get) or by
compiling/installing?  If you used the Debian packages, did you get the -dev
package (i.e. libglib2.0-dev)?  In either case, did a glib-2.0.pc file get
installed?  If glib was installed from Debian packages, it should be located
in /usr/lib/pkgconfig .

 -- Jeff Smith

----- Original Message ----
From: Dane Springmeyer <blake@...>
To: mdbtools-dev@...
Sent: Saturday, December 1, 2007 5:40:03 PM
Subject: [mdb-dev] configure fails due to glib test, even when "disabled"

Hopefully someone can help here:

I am tring to build mdbtools from cvs (I've also tried the prerelease  
using the same methods) and I keep on getting an error in the  
configure step.

It is:

__________

checking for GLIB - version >= 2.0.0... no
*** Could not run GLIB test program, checking why...
*** The test program failed to compile or link. See the file  
config.log for the
*** exact error that occured. This usually means GLIB is incorrectly  
installed.

glib 2.0 is required by MDB Tools.
It can be downloaded at www.gtk.org
__________

I am installing on Debian Linux on a remote server and I don't even  
need glib or any of the graphical tools. I just need to compile  
mdbtools with odbc support for use with the gdal PGEO driver, to  
convert ms access/ESRI geodatabases to csv output.

I have tried both installing glib-2.12.0 and pointing mdbtools to the  
glib.h file in my directory : /home/dspringmeyer/usr/local/glib-2.0  
and I have tried disabling glib as ./configure --help explains.

Neither of these options help and I am still prevented from a  
successful configure step.

Anyone have any ideas how to hack the source files to *truly* diable  
the glib check?  Or any other ideas on a way to help?



Thanks,

Dane

---

Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.

-------------------------------------------------------------------------
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
mdbtools-dev@...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[Dane Springmeyer]

Jeff,

I realized that if the disable-glib is not really an option (even though it is found in ./configure --help) then maybe I am misinterpreting that I can even set the path to glib during the configure...

Is it even possible to do: 

./configure --with-glib=/path to glib... ?

I DO HAVE installed glib in a custom directory so maybe I need to do some hacking in the configure scripts?

Since I'm new to linux any suggestions would be helpful...

For instance, I am aware of setting the "LD_LIBRARY_PATH" and the "LD Flags" ideas but don't know how to go about that...

Cheers,

Dane

On Dec 2, 2007, at 1:53 PM, Jeff Smith wrote:

First, despite what may be inferred from the configure script, glib is required.
Second, glib is used for data structures and other foundational functions, but
has nothing to do with graphics (except that the gtk+ toolkit does use it as a
foundation).

Did you install glib using Debian packages (via dpkg or apt-get) or by
compiling/installing?  If you used the Debian packages, did you get the -dev
package (i.e. libglib2.0-dev)?  In either case, did a glib-2.0.pc file get
installed?  If glib was installed from Debian packages, it should be located
in /usr/lib/pkgconfig .

 -- Jeff Smith

----- Original Message ----
From: Dane Springmeyer <blake@...>
To: mdbtools-dev@...
Sent: Saturday, December 1, 2007 5:40:03 PM
Subject: [mdb-dev] configure fails due to glib test, even when "disabled"

Hopefully someone can help here:

I am tring to build mdbtools from cvs (I've also tried the prerelease  
using the same methods) and I keep on getting an error in the  
configure step.

It is:

__________

checking for GLIB - version >= 2.0.0... no
*** Could not run GLIB test program, checking why...
*** The test program failed to compile or link. See the file  
config.log for the
*** exact error that occured. This usually means GLIB is incorrectly  
installed.

glib 2.0 is required by MDB Tools.
It can be downloaded at www.gtk.org
__________

I am installing on Debian Linux on a remote server and I don't even  
need glib or any of the graphical tools. I just need to compile  
mdbtools with odbc support for use with the gdal PGEO driver, to  
convert ms access/ESRI geodatabases to csv output.

I have tried both installing glib-2.12.0 and pointing mdbtools to the  
glib.h file in my directory : /home/dspringmeyer/usr/local/glib-2.0  
and I have tried disabling glib as ./configure --help explains.

Neither of these options help and I am still prevented from a  
successful configure step.

Anyone have any ideas how to hack the source files to *truly* diable  
the glib check?  Or any other ideas on a way to help?



Thanks,

Dane

---

Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.

-------------------------------------------------------------------------
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
mdbtools-dev@...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[Jeff Smith-3]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Probably your best bet is to set the environmental variable PKG_CONFIG_PATH to the directory in which you found the .pc file.

 -- Jeff Smith

----- Original Message ----
From: Dane Springmeyer <blake@...>
To: Jeff Smith <whydoubt@...>
Cc: mdbtools-dev@...
Sent: Sunday, December 2, 2007 6:00:07 PM
Subject: Re: [mdb-dev] configure fails due to glib test, even when "disabled"

Jeff,

I realized that if the disable-glib is not really an option (even though it is found in ./configure --help) then maybe I am misinterpreting that I can even set the path to glib during the configure...

Is it even possible to do: 

./configure --with-glib=/path to glib... ?

I DO HAVE installed glib in a custom directory so maybe I need to do some hacking in the configure scripts?

Since I'm new to linux any suggestions would be helpful...

For instance, I am aware of setting the "LD_LIBRARY_PATH" and the "LD Flags" ideas but don't know how to go about that...

Cheers,

Dane

On Dec 2, 2007, at 1:53 PM, Jeff Smith wrote:

First, despite what may be inferred from the configure script, glib is required.
Second, glib is used for data structures and other foundational functions, but
has nothing to do with graphics (except that the gtk+ toolkit does use it as a
foundation).

Did you install glib using Debian packages (via dpkg or apt-get) or by
compiling/installing?  If you used the Debian packages, did you get the -dev
package (i.e. libglib2.0-dev)?  In either case, did a glib-2.0.pc file get
installed?  If glib was installed from Debian packages, it should be located
in /usr/lib/pkgconfig .

 -- Jeff Smith

----- Original Message ----
From: Dane Springmeyer <blake@...>
To: mdbtools-dev@...
Sent: Saturday, December 1, 2007 5:40:03 PM
Subject: [mdb-dev] configure fails due to glib test, even when "disabled"

Hopefully someone can help here:

I am tring to build mdbtools from cvs (I've also tried the prerelease  
using the same methods) and I keep on getting an error in the  
configure step.

It is:

__________

checking for GLIB - version >= 2.0.0... no
*** Could not run GLIB test program, checking why...
*** The test program failed to compile or link. See the file  
config.log for the
*** exact error that occured. This usually means GLIB is incorrectly  
installed.

glib 2.0 is required by MDB Tools.
It can be downloaded at www.gtk.org
__________

I am installing on Debian Linux on a remote server and I don't even  
need glib or any of the graphical tools. I just need to compile  
mdbtools with odbc support for use with the gdal PGEO driver, to  
convert ms access/ESRI geodatabases to csv output.

I have tried both installing glib-2.12.0 and pointing mdbtools to the  
glib.h file in my directory : /home/dspringmeyer/usr/local/glib-2.0  
and I have tried disabling glib as ./configure --help explains.

Neither of these options help and I am still prevented from a  
successful configure step.

Anyone have any ideas how to hack the source files to *truly* diable  
the glib check?  Or any other ideas on a way to help?



Thanks,

Dane

---

Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.

---

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
-------------------------------------------------------------------------
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
mdbtools-dev@...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[Dane Springmeyer]

Jeff and Simon,

Thanks so much for the help. Setting the PKG_CONFIG_PATH was exactly what I needed. Here are the steps I used to get mdbtools to find the right version of glib that I installed:

-----

installed a local build of pkg-config:

wget http://pkgconfig.freedesktop.org/releases/pkgconfig-0.18.tar.gz

tar xzvf pkgconfig-0.18.tar.gz

cd pkgconfig-0.18

./configure --prefix=/home/dspringmeyer/usr/local

then set my .bash_profile to have these lines:

PKG_CONFIG_PATH=/home/dspringmeyer/usr/local/lib/pkgconfig

export PKG_CONFIG_PATH

LD_LIBRARY_PATH=/home/dspringmeyer/usr/local/lib:/usr/lib:/usr/X11R6/lib:/usr/lib/libc5-compat:/lib/libc5-compat:/usr/i486-linuxlibc1/lib

export LD_LIBRARY_PATH

then, finally, pkg-config found the right pkgconfig directory I set. Here is the configure output:

------

checking for pkg-config... /home/dspringmeyer/usr/local/bin/pkg-config

checking for GLIB - version >= 2.0.0... yes (version 2.12.0)

checking pkg-config is at least version 0.9.0... yes

checking for GNOME... checking gtk-doc version >= 1.0... no

------

make 

make install

-----

The key seemed to be both setting the LD_LIBRARY_PATH and installing my own local copy of pkg-config after setting the PKG_CONFIG_PATH

Thanks so much. Quite a grueling process but I understand Linux a whole lot better than I did before.

Cheers,

Dane

-------------------------------------------------------------------------
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
mdbtools-dev@...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev