Menu
▾
▴
mdbtools-dev
This list is closed, nobody may subscribe to it.
| 2000 |
Jan
|
Feb
(1) |
Mar
(53) |
Apr
(28) |
May
(5) |
Jun
(7) |
Jul
(16) |
Aug
(15) |
Sep
(10) |
Oct
(1) |
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2001 |
Jan
(9) |
Feb
(7) |
Mar
(1) |
Apr
(7) |
May
(6) |
Jun
|
Jul
(15) |
Aug
(10) |
Sep
(2) |
Oct
(12) |
Nov
(3) |
Dec
(2) |
| 2002 |
Jan
(2) |
Feb
(12) |
Mar
(33) |
Apr
(30) |
May
(5) |
Jun
(18) |
Jul
(18) |
Aug
(47) |
Sep
(8) |
Oct
(7) |
Nov
(8) |
Dec
(13) |
| 2003 |
Jan
(48) |
Feb
(8) |
Mar
(10) |
Apr
(30) |
May
(6) |
Jun
(8) |
Jul
(19) |
Aug
(36) |
Sep
(19) |
Oct
(16) |
Nov
(11) |
Dec
(17) |
| 2004 |
Jan
(11) |
Feb
(22) |
Mar
(52) |
Apr
(45) |
May
(18) |
Jun
(72) |
Jul
(14) |
Aug
(31) |
Sep
(19) |
Oct
(27) |
Nov
(19) |
Dec
(25) |
| 2005 |
Jan
(16) |
Feb
(46) |
Mar
(50) |
Apr
(3) |
May
(21) |
Jun
(3) |
Jul
(24) |
Aug
(33) |
Sep
(25) |
Oct
(23) |
Nov
(30) |
Dec
(20) |
| 2006 |
Jan
(12) |
Feb
(11) |
Mar
(8) |
Apr
(15) |
May
(27) |
Jun
(15) |
Jul
(19) |
Aug
(5) |
Sep
(9) |
Oct
(1) |
Nov
(2) |
Dec
(3) |
| 2007 |
Jan
|
Feb
(3) |
Mar
(18) |
Apr
(5) |
May
(9) |
Jun
|
Jul
(10) |
Aug
(3) |
Sep
(8) |
Oct
(1) |
Nov
(7) |
Dec
(9) |
| 2008 |
Jan
(2) |
Feb
|
Mar
(10) |
Apr
(4) |
May
|
Jun
(5) |
Jul
(9) |
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
(8) |
| 2009 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(11) |
Nov
(1) |
Dec
(20) |
| 2010 |
Jan
|
Feb
(2) |
Mar
|
Apr
(7) |
May
|
Jun
(23) |
Jul
(3) |
Aug
(6) |
Sep
(1) |
Oct
(4) |
Nov
(1) |
Dec
|
| 2011 |
Jan
(1) |
Feb
(26) |
Mar
(25) |
Apr
(11) |
May
(5) |
Jun
(5) |
Jul
(2) |
Aug
(39) |
Sep
(12) |
Oct
(6) |
Nov
|
Dec
|
| 2012 |
Jan
(19) |
Feb
(5) |
Mar
|
Apr
|
May
|
Jun
(7) |
Jul
|
Aug
(8) |
Sep
|
Oct
(3) |
Nov
(2) |
Dec
(3) |
| 2013 |
Jan
(6) |
Feb
|
Mar
(1) |
Apr
|
May
(7) |
Jun
(5) |
Jul
(2) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
| 2014 |
Jan
(4) |
Feb
|
Mar
(2) |
Apr
|
May
|
Jun
|
Jul
|
Aug
(1) |
Sep
|
Oct
|
Nov
|
Dec
|
| 2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2016 |
Jan
(5) |
Feb
|
Mar
(1) |
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2017 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
(1) |
Dec
|
|
From: Dane S. <bl...@ha...> - 2007-12-03 18:29:42
|
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 |
|
From: Jeff S. <why...@ya...> - 2007-12-03 18:16:26
|
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 <bl...@ha...> To: Jeff Smith <why...@ya...> Cc: mdb...@li... 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 <bl...@ha...> To: mdb...@li... 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. ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs |
|
From: Dane S. <bl...@ha...> - 2007-12-03 00:00:14
|
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 <bl...@ha...> > To: mdb...@li... > 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. |
|
From: Dane S. <bl...@ha...> - 2007-12-02 23:31:55
|
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 <bl...@ha...> > To: mdb...@li... > 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. |
|
From: Jeff S. <why...@ya...> - 2007-12-02 21:53:53
|
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 <bl...@ha...> To: mdb...@li... 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 ____________________________________________________________________________________ Get easy, one-click access to your favorites. Make Yahoo! your homepage. http://www.yahoo.com/r/hs |
|
From: Dane S. <bl...@ha...> - 2007-12-01 23:40:16
|
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. |
|
From: Lukasz S. <szy...@gm...> - 2007-11-23 20:36:25
|
Hello, mdb-schema databasename.mdb mysql FYI Trying to convert ftp://ftp.nhtsa.dot.gov/manufacture/manufacturer.mdb to mysql Few error I came across. 1. Your script is not checking from length. It created fields varchar(501) where in mysql limit is 255. 2. The 'drop table tablename' statement should be "drop table if exists tablename" 3. table names are not quoted. CREATE TABLE 565 should be CREATE TABLE `565` 4. Column names are not quoted. CREATE TABLE `565` ( MFG NAME varchar (255), should be CREATE TABLE `565` ( ` MFG NAME` varchar (255), This also applies to mdb-export while doing insert statement. 5. Not sure if you know this but there is no comma ',' at the end of each insert statement. which can be added using SED on a fly: mdb-export -I manufacturer.mdb WMI | sed -e 's/)$/)\;/' |mysql -u username -p database_name Other then that the program is great. Thanks for having it. I had to fix these things manually. It would be nice if that was done inside the software. Thanks a lot. Lucas |
|
From: Jarl F. <ja...@ga...> - 2007-11-20 13:12:15
|
Justus Victor <j2j...@ya...> writes: > 1. (*) text/plain ( ) text/html > > Greetings to You. > > I am trying to install the mdbtools.tar.gz. I changed the name, but > i left the extension as it is. It is located in my home > directory. so i tried the following command ~$ sudo apt-get install > mdbtools.tar.gz it said that the "couldn't find package. > > so i tried ~$ sudo apt-get install '/home/assisteng/mdbtools.tar.gz' > and it gave the same error. I tried ~$ sudo apt-get install > /home/assisteng/mdbtools.tar.gz and it still didnot work. > > I am using ubuntu 7.10 gutsy gibbon. The apt-* commands only works for debian packages (.deb, I think). Installing from a tar-ball (.tar.gz) you have to extract the source code, build, and install the software manually. It is recomended that you find the name of the package for Ubuntu, the name is probably "mdbtools", so try ~$ sudo apt-get install mdbtools If that does not work, I suggest you seek help on a ubuntu-specific mailing list, because the problem is ubunutu specific. They probably have a mailing list for ubuntu users. Jarl |
|
From: Mechtilde S. <oo...@me...> - 2007-11-20 11:10:15
|
Hello Justus, Justus Victor schrieb: > Greetings to You. > > I am trying to install the mdbtools.tar.gz. I changed the name, but i > left the extension as it is. It is located in my home directory. so i > tried the following command ~$ sudo apt-get install mdbtools.tar.gz > it said that the "couldn't find package. That's right. It is designed so. If you want really install the mdbtools then pülease use the version from the Ubuntu repository. > so i tried ~$ sudo apt-get install '/home/assisteng/mdbtools.tar.gz' > and it gave the same error. I tried ~$ sudo apt-get install > /home/assisteng/mdbtools.tar.gz and it still didnot work. > > I am using ubuntu 7.10 gutsy gibbon. > > another difficulty i had another computer using the same gutsy gibbon > was my openoffice was responding. I tried to install it, but i am > not getting through. you want to install openoffice.org? > > I am only 3 weeks old in the linux world, so please be patient with > me. I will learn with help from good people like you all. > > Can you please help me. Thank you in advance. therefore I need more information what you want to do especially because you are very new on Linux. Regards Mechtilde |
|
From: Justus V. <j2j...@ya...> - 2007-11-19 15:36:26
|
Greetings to You. I am trying to install the mdbtools.tar.gz. I changed the name, but i left the extension as it is. It is located in my home directory. so i tried the following command ~$ sudo apt-get install mdbtools.tar.gz it said that the "couldn't find package. so i tried ~$ sudo apt-get install '/home/assisteng/mdbtools.tar.gz' and it gave the same error. I tried ~$ sudo apt-get install /home/assisteng/mdbtools.tar.gz and it still didnot work. I am using ubuntu 7.10 gutsy gibbon. another difficulty i had another computer using the same gutsy gibbon was my openoffice was responding. I tried to install it, but i am not getting through. I am only 3 weeks old in the linux world, so please be patient with me. I will learn with help from good people like you all. Can you please help me. Thank you in advance. Best Regards Justus Victor |
|
From: Ofer <oc...@ne...> - 2007-11-12 10:14:31
|
Hello Lately I start to work with mdb-tools. I try this with small files & everything is ok. When I try with big files I get the next error: # mdb-schema lib_data.mdb ------------------------------------------------------------- -- 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 ------------------------------------------------------------- -- CREATE ANY Relationships ... -- relationships are not supported for access ================================== I get the version of the file: # mdb-ver lib_data.mdb JET4 ================================== I did strace on the file: execve("/usr/bin/mdb-schema", ["mdb-schema", "lib_data.mdb"], [/* 29 vars */]) = 0 brk(0) = 0x804c000 access("/etc/ld.so.preload", R_OK) = -1 ENOENT (No such file or directory) open("/etc/ld.so.cache", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=26343, ...}) = 0 mmap2(NULL, 26343, PROT_READ, MAP_PRIVATE, 3, 0) = 0xb7fd5000 close(3) = 0 open("/usr/lib/libmdb.so.0", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\320;\0\0004\0\0\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0755, st_size=64580, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7fd4000 mmap2(NULL, 116724, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7fb7000 mmap2(0xb7fc6000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0xe) = 0xb7fc6000 mmap2(0xb7fc8000, 47092, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7fc8000 close(3) = 0 open("/lib/libm.so.6", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p4\0\0004\0\0\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0755, st_size=149256, ...}) = 0 mmap2(NULL, 151680, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7f91000 mmap2(0xb7fb5000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x23) = 0xb7fb5000 close(3) = 0 open("/usr/lib/libglib-2.0.so.0", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\240\355\0\0004\0\0\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0755, st_size=608408, ...}) = 0 mmap2(NULL, 608036, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7efc000 mmap2(0xb7f8f000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x93) = 0xb7f8f000 close(3) = 0 open("/lib/libncurses.so.5", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\200\347\0\0004\0\0\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0755, st_size=268880, ...}) = 0 mmap2(NULL, 268548, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7eba000 mmap2(0xb7ef3000, 36864, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x38) = 0xb7ef3000 close(3) = 0 open("/lib/libreadline.so.5", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0\360\316\0\0004\0\0\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0555, st_size=197572, ...}) = 0 mmap2(NULL, 200852, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7e88000 mmap2(0xb7eb4000, 16384, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x2c) = 0xb7eb4000 mmap2(0xb7eb8000, 4244, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7eb8000 close(3) = 0 open("/lib/libc.so.6", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0@a\1\0004\0\0\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0755, st_size=1229084, ...}) = 0 mmap2(NULL, 1234384, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7d5a000 mmap2(0xb7e82000, 12288, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x128) = 0xb7e82000 mmap2(0xb7e85000, 9680, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_ANONYMOUS, -1, 0) = 0xb7e85000 close(3) = 0 open("/lib/libdl.so.2", O_RDONLY) = 3 read(3, "\177ELF\1\1\1\0\0\0\0\0\0\0\0\0\3\0\3\0\1\0\0\0p\n\0\0004\0\0\0"..., 512) = 512 fstat64(3, {st_mode=S_IFREG|0755, st_size=9612, ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7d59000 mmap2(NULL, 12412, PROT_READ|PROT_EXEC, MAP_PRIVATE|MAP_DENYWRITE, 3, 0) = 0xb7d55000 mmap2(0xb7d57000, 8192, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_FIXED|MAP_DENYWRITE, 3, 0x1) = 0xb7d57000 close(3) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7d54000 set_thread_area({entry_number:-1 -> 6, base_addr:0xb7d546c0, limit:1048575, seg_32bit:1, contents:0, read_exec_only:0, limit_in_pages:1, seg_not_present:0, useable:1}) = 0 mprotect(0xb7d57000, 4096, PROT_READ) = 0 mprotect(0xb7e82000, 8192, PROT_READ) = 0 mprotect(0xb7eb4000, 4096, PROT_READ) = 0 mprotect(0xb7f8f000, 4096, PROT_READ) = 0 mprotect(0xb7fb5000, 4096, PROT_READ) = 0 mprotect(0xb7fc6000, 4096, PROT_READ) = 0 mprotect(0x804a000, 4096, PROT_READ) = 0 mprotect(0xb7ff6000, 4096, PROT_READ) = 0 munmap(0xb7fd5000, 26343) = 0 brk(0) = 0x804c000 brk(0x806d000) = 0x806d000 gettimeofday({1194449252, 958424}, NULL) = 0 stat64("lib_data.mdb", {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 open("lib_data.mdb", O_RDONLY) = 3 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 0, SEEK_SET) = 0 read(3, "\0\1\0\0Standard Jet DB\0\1\0\0\0\265n\3b`\t\302U"..., 2048) = 2048 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 8192, SEEK_SET) = 8192 read(3, "\2\1\336\v\0\0\0\0\32\4\0\0Y\6\0\0\205\1\0\0\0\0\0\0\1\0\0\0\377\377\377\377"..., 4096) = 4096 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 24576, SEEK_SET) = 24576 read(3, "\1\1\271\2\0\0\0\0\0\0\0\0\37\0\273\17v\0171\17\354\16\247\16b\16\35\16\330\r\223\r"..., 4096) = 4096 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 24576, SEEK_SET) = 24576 read(3, "\1\1\271\2\0\0\0\0\0\0\0\0\37\0\273\17v\0171\17\354\16\247\16b\16\35\16\330\r\223\r"..., 4096) = 4096 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 51699712, SEEK_SET) = 51699712 read(3, "\5\1\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 24576, SEEK_SET) = 24576 read(3, "\1\1\271\2\0\0\0\0\0\0\0\0\37\0\273\17v\0171\17\354\16\247\16b\16\35\16\330\r\223\r"..., 4096) = 4096 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 51699712, SEEK_SET) = 51699712 read(3, "\5\1\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 10211328, SEEK_SET) = 10211328 read(3, "\1\1\250\17\273\t\0\0\0\0\0\0\1\0\270\17\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 fstat64(3, {st_mode=S_IFREG|0644, st_size=53858304, ...}) = 0 lseek(3, 51699712, SEEK_SET) = 51699712 read(3, "\5\1\0\0\0@\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0"..., 4096) = 4096 fstat64(1, {st_mode=S_IFCHR|0620, st_rdev=makedev(136, 0), ...}) = 0 mmap2(NULL, 4096, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0) = 0xb7fdb000 write(1, "--------------------------------"..., 62) = 62 write(1, "-- MDB Tools - A library for rea"..., 62) = 62 write(1, "-- Copyright (C) 2000-2004 Brian"..., 39) = 39 write(1, "-- Files in libmdb are licensed "..., 67) = 67 write(1, "-- the GPL, see COPYING.LIB and "..., 60) = 60 write(1, "-- Check out http://mdbtools.sou"..., 45) = 45 write(1, "--------------------------------"..., 63) = 63 write(1, "\n\n", 2) = 2 write(1, "-- CREATE ANY Relationships ...\n", 32) = 32 write(1, "\n", 1) = 1 write(1, "-- relationships are not support"..., 46) = 46 close(3) = 0 exit_group(0) = ? ================================== When I'm using odbc-mdb which come with mdb-tools the next error: "No tuples available at this result index". How could I fix this problem? Thanks for the help |
|
From: Jarl F. <ja...@ga...> - 2007-11-10 21:19:33
|
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 |
|
From: Jarl F. <ja...@ga...> - 2007-11-08 20:37:43
|
This patch is improved to be aware of the SQLite ODBC type mapping. |
|
From: Jarl F. <ja...@ga...> - 2007-10-24 13:09:39
|
I have made a patch. There are two user-level features: 1) New sqlite3 backend (for mdb-schema). 2) The mdb-export utility does no longer need table name as argument, if ommitted loops over all tables. Code level changes: Minor refactoring The sqlite3 backend is still under investigation, I want it to match some of the sqliteodbc specific row type definitions. Now an mdb file can be converted into a sqlite3 file in two steps. first use mdb-schema, then mdb-export. Could someone please commit this to CVS. Jarl |
|
From: godfrey <go...@gn...> - 2007-09-28 11:23:02
|
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 |
|
From: david w. <dav...@gm...> - 2007-09-19 12:11:36
|
On 05/09/2007, Andrew Gaffney <aga...@ge...> wrote: > As far as I can tell, the file is not password protected. When I open it in > Access on a machine that it's never been opened on before, it doesn't ask for a > password and I can access the entire database. I have very little experience with MS Access systems, but I once had to work with an application for a short while that had no security and mulitple users (things got messed up---I wonder why). I looked into what it would take to add some security to it and the whole MS Access security model looked like a nightmare to me. One way part of it seemed to work had something to do with being a member of a group and having a group permissions file or something. It didn't necessarily involve a password prompt. The details all got far too nasty for me to continue with it (I reimplemented it using php and mysql) but the point to this ramble is to ask if it is possible that it *is* protected/encrypted and the machines you are opening it on or the user you are opening it as have permission to open the db and therefore do not ask for an explicit password? Can you open it on a machine that has nothing to do with the place that it is installed? Dave > I'll see if I can remember my SF user/pass in a bit and file a bug. > > Jeff Smith wrote: > > Andrew, > > > > This error is usually because the file is password-protected. This is > > not supported. > > > > If this is not the case, my recommendation is to create an entry in our > > bug database, > > and attach a minimal file that exhibits the behavior. > > > > You can just send me the file instead, but you would be taking a higher > > risk of it > > falling through the cracks. I don't have a lot of time right now for > > working on mdbtools. > > > > -- Jeff Smith > > > > > > ----- Original Message ---- > > From: Andrew Gaffney <aga...@ge...> > > To: mdb...@li... > > Sent: Tuesday, September 4, 2007 9:17:31 PM > > Subject: [mdb-dev] mdbtools doesn't like my Access database > > > > I've got an Access 97 format database that's being used with a cash > > register > > application (Micro Register). For some reason, mdbtools doesn't > > recognize it as > > a valid Access database. I've tried upgrading it to Access 2000 and > > 2002, as > > well as doing "Compact & Repair". Here's what I get when I try to play > > around > > with it: > > > > mal ~ # mdb-ver /tmp/microreg.mdb > > JET3 > > mal ~ # mdb-schema /tmp/microreg.mdb > > File does not appear to be an Access database > > mal ~ # mdb-schema -S /tmp/microreg.mdb > > File does not appear to be an Access database > > > > Now, if I export one table from this database into a blank Access 2000 > > database, > > the new file can be read just fine by mdbtools. I tried just removing > > all the > > tables except the one I exported from the original (thinking it was one > > of the > > other tables that was causing problems), but mdbtools didn't like that, > > either. > > > > I'd just do the one-time export and use that, but I need "real-time" > > synchronization between this Access database and an e-commerce site I'm > > putting > > together for the business that runs this cash register application. I've > > looked > > into other solutions such as using an ODBC network gateway, but I can't > > find > > anything that would work with perl or PHP in linux > > > > If it helps, both 0.5 and 0.6_pre1 would segfault if I ran 'mdb-schema > > -S' on > > the file, but a more recent CVS checkout (output above) fails a bit more > > gracefully. I can also post a version of the database with just the > > single table > > I'm interested in but that still fails with mdbtools. I assume anything > > done to > > make mdbtools work with that database would also work with the original. > > > > Thanks for any help that anyone can provide. > > -- > Andrew Gaffney http://dev.gentoo.org/~agaffney/ > Gentoo Linux Developer Catalyst/Installer + x86 release coordinator > > ------------------------------------------------------------------------- > 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 > -- David Whiting |
|
From: Barrie B. <bar...@nt...> - 2007-09-19 11:33:08
|
On Tue, 2007-09-04 at 21:17 -0500, Andrew Gaffney wrote: > I've got an Access 97 format database that's being used with a cash register > application (Micro Register). For some reason, mdbtools doesn't recognize it as > a valid Access database. I've tried upgrading it to Access 2000 and 2002, as > well as doing "Compact & Repair". Here's what I get when I try to play around > with it: > > mal ~ # mdb-ver /tmp/microreg.mdb > JET3 > mal ~ # mdb-schema /tmp/microreg.mdb > File does not appear to be an Access database > mal ~ # mdb-schema -S /tmp/microreg.mdb > File does not appear to be an Access database > > Now, if I export one table from this database into a blank Access 2000 database, > the new file can be read just fine by mdbtools. I tried just removing all the > tables except the one I exported from the original (thinking it was one of the > other tables that was causing problems), but mdbtools didn't like that, either. > > I'd just do the one-time export and use that, but I need "real-time" > synchronization between this Access database and an e-commerce site I'm putting > together for the business that runs this cash register application. I've looked > into other solutions such as using an ODBC network gateway, but I can't find > anything that would work with perl or PHP in linux > > If it helps, both 0.5 and 0.6_pre1 would segfault if I ran 'mdb-schema -S' on > the file, but a more recent CVS checkout (output above) fails a bit more > gracefully. I can also post a version of the database with just the single table > I'm interested in but that still fails with mdbtools. I assume anything done to > make mdbtools work with that database would also work with the original. > > Thanks for any help that anyone can provide. > Have you tried importing the entire microreg.mdb contents into a new blank Access database, then renaming the files such that the new db replaces the old in the application(obviously backing up the original first)? I have used this method to repair corrupt Access databases in the past, sometimes finding that mdbtools will extract data inaccessible via MsAccess. Barrie |
|
From: <ich...@ch...> - 2007-09-16 21:07:23
|
Hello,
i have a problem with mdb-tools pre1.
When i query the tables of the database using mdb-sql i get the data
with no problem, except for one table.
This table has 122 records on it but when i query it using mdb-sql
(or when i use mdb-export) i only get a row with a wierd number on
the first field of the first record.
am i doing something wrong here?
should i try the CVS version?
here are some relevant outputs:
$ mdb-export investigacion.mdb Proyectos
clavepro,titulo,financiamiento,fecha
aceptacion,IVigencia,FVigencia,fecha
termino,monto,linea,responsable,Descripci?
n,Nivel,Area,Objetivo,registro FZ,Finalizado,Colaboradores,informe
felipe,estudiantes doctorado,estudiantes maestria,estudiantes
licenciatura,localizacion,campo aplicacion,tipo de
proyectos,disciplina,BAJA,Motivo Baja
721420288,"","","","","","",,,,"","",,"","",0,"","",,,,"","","","",0,""
mdb-ver investigacion.mdb
JET4
DROP TABLE Proyectos;
CREATE TABLE Proyectos
(
clavepro Long Integer,
titulo Text (500),
financiamiento Text (100),
fecha aceptacion DateTime (Short),
IVigencia DateTime (Short),
FVigencia DateTime (Short),
fecha termino DateTime (Short),
monto Currency,
linea Long Integer,
responsable Long Integer,
Descripci?n Memo/Hyperlink (255),
Nivel Text (100),
Area Long Integer,
Objetivo Memo/Hyperlink (255),
registro FZ Text (100),
Finalizado Boolean,
Colaboradores Text (220),
informe felipe Text (100),
estudiantes doctorado Long Integer,
estudiantes maestria Long Integer,
estudiantes licenciatura Long Integer,
localizacion Text (100),
campo aplicacion Text (400),
tipo de proyectos Text (100),
disciplina Text (100),
BAJA Boolean,
Motivo Baja Memo/Hyperlink (255)
);
$ echo "select * from Proyectos" | mdb-sql /home/fz.uach.mx/data/
investigacion.mdb
+--------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------------------------
+-----------------------------------------------------------------------
-----------------------------+--------------------
+--------------------+--------------------+--------------------
+------------+-------+-----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+-------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----
+-----------------------------------------------------------------------
-----------------------------+---------------------
+--------------------+------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
-----------------------------+----
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------+
|clavepro|
titulo
|
financiamiento
|fecha aceptacion |
IVigencia |FVigencia |fecha termino |
monto |linea |responsable|Descripci?
n
|
Nivel
|Area |
Objetivo
|registro
FZ
|Finalizado|
Colaboradores
|informe
felipe
|estudiantes doctorado|estudiantes maestria|
estudiantes licenciatura|
localizacion
|campo
aplicacion
|tipo de
proyectos
|
disciplina
|BAJA|Motivo
Baja
|
+--------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------------------------
+-----------------------------------------------------------------------
-----------------------------+--------------------
+--------------------+--------------------+--------------------
+------------+-------+-----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+-------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----
+-----------------------------------------------------------------------
-----------------------------+---------------------
+--------------------+------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
-----------------------------+----
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------+
|
72142028|
|
|
| | |
| | |
|
|
|
|
|
|0
|
|
|
| |
|
|
|
|
|0
|
|
+--------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
---------------------------------------------------------------------
+-----------------------------------------------------------------------
-----------------------------+--------------------
+--------------------+--------------------+--------------------
+------------+-------+-----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+-------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------
+-----------------------------------------------------------------------
-----------------------------+----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----
+-----------------------------------------------------------------------
-----------------------------+---------------------
+--------------------+------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------------
+-----------------------------------------------------------------------
-----------------------------
+-----------------------------------------------------------------------
-----------------------------+----
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------------------------------------+
1 Row retrieved
Thanks for your help.
|
|
From: Walter v. H. <wal...@xs...> - 2007-09-10 16:15:06
|
Hello all, After failing to build a CVS version of mdbtools under OS X I tried it on my Debian box and had to run the autogen script twice to get a configure script that actually made it build. Having done that, i took a peek at the famous Northwind.mdb file. I had been hoping to get a hold of the forms inside it, but the prtable tool only appears to provide the data tables in it, not the internal tables themselves. How do I get to those? Regards, Walter |
|
From: Andrew G. <aga...@ge...> - 2007-09-05 11:50:24
|
As far as I can tell, the file is not password protected. When I open it in Access on a machine that it's never been opened on before, it doesn't ask for a password and I can access the entire database. I'll see if I can remember my SF user/pass in a bit and file a bug. Jeff Smith wrote: > Andrew, > > This error is usually because the file is password-protected. This is > not supported. > > If this is not the case, my recommendation is to create an entry in our > bug database, > and attach a minimal file that exhibits the behavior. > > You can just send me the file instead, but you would be taking a higher > risk of it > falling through the cracks. I don't have a lot of time right now for > working on mdbtools. > > -- Jeff Smith > > > ----- Original Message ---- > From: Andrew Gaffney <aga...@ge...> > To: mdb...@li... > Sent: Tuesday, September 4, 2007 9:17:31 PM > Subject: [mdb-dev] mdbtools doesn't like my Access database > > I've got an Access 97 format database that's being used with a cash > register > application (Micro Register). For some reason, mdbtools doesn't > recognize it as > a valid Access database. I've tried upgrading it to Access 2000 and > 2002, as > well as doing "Compact & Repair". Here's what I get when I try to play > around > with it: > > mal ~ # mdb-ver /tmp/microreg.mdb > JET3 > mal ~ # mdb-schema /tmp/microreg.mdb > File does not appear to be an Access database > mal ~ # mdb-schema -S /tmp/microreg.mdb > File does not appear to be an Access database > > Now, if I export one table from this database into a blank Access 2000 > database, > the new file can be read just fine by mdbtools. I tried just removing > all the > tables except the one I exported from the original (thinking it was one > of the > other tables that was causing problems), but mdbtools didn't like that, > either. > > I'd just do the one-time export and use that, but I need "real-time" > synchronization between this Access database and an e-commerce site I'm > putting > together for the business that runs this cash register application. I've > looked > into other solutions such as using an ODBC network gateway, but I can't > find > anything that would work with perl or PHP in linux > > If it helps, both 0.5 and 0.6_pre1 would segfault if I ran 'mdb-schema > -S' on > the file, but a more recent CVS checkout (output above) fails a bit more > gracefully. I can also post a version of the database with just the > single table > I'm interested in but that still fails with mdbtools. I assume anything > done to > make mdbtools work with that database would also work with the original. > > Thanks for any help that anyone can provide. -- Andrew Gaffney http://dev.gentoo.org/~agaffney/ Gentoo Linux Developer Catalyst/Installer + x86 release coordinator |
|
From: Jeff S. <why...@ya...> - 2007-09-05 03:36:18
|
Andrew,=0A=0AThis error is usually because the file is password-protected. = This is not supported.=0A=0AIf this is not the case, my recommendation is = to create an entry in our bug database,=0Aand attach a minimal file that ex= hibits the behavior.=0A=0AYou can just send me the file instead, but you wo= uld be taking a higher risk of it=0Afalling through the cracks. I don't ha= ve a lot of time right now for working on mdbtools.=0A=0A -- Jeff Smith=0A= =0A=0A----- Original Message ----=0AFrom: Andrew Gaffney <agaffney@gentoo.o= rg>=0ATo: mdb...@li...=0ASent: Tuesday, September 4, = 2007 9:17:31 PM=0ASubject: [mdb-dev] mdbtools doesn't like my Access databa= se=0A=0AI've got an Access 97 format database that's being used with a cash= register =0Aapplication (Micro Register). For some reason, mdbtools doesn'= t recognize it as =0Aa valid Access database. I've tried upgrading it to Ac= cess 2000 and 2002, as =0Awell as doing "Compact & Repair". Here's what I g= et when I try to play around =0Awith it:=0A=0Amal ~ # mdb-ver /tmp/microreg= .mdb=0AJET3=0Amal ~ # mdb-schema /tmp/microreg.mdb=0AFile does not appear t= o be an Access database=0Amal ~ # mdb-schema -S /tmp/microreg.mdb=0AFile do= es not appear to be an Access database=0A=0ANow, if I export one table from= this database into a blank Access 2000 database, =0Athe new file can be re= ad just fine by mdbtools. I tried just removing all the =0Atables except th= e one I exported from the original (thinking it was one of the =0Aother tab= les that was causing problems), but mdbtools didn't like that, either.=0A= =0AI'd just do the one-time export and use that, but I need "real-time" =0A= synchronization between this Access database and an e-commerce site I'm put= ting =0Atogether for the business that runs this cash register application.= I've looked =0Ainto other solutions such as using an ODBC network gateway,= but I can't find =0Aanything that would work with perl or PHP in linux=0A= =0AIf it helps, both 0.5 and 0.6_pre1 would segfault if I ran 'mdb-schema -= S' on =0Athe file, but a more recent CVS checkout (output above) fails a bi= t more =0Agracefully. I can also post a version of the database with just t= he single table =0AI'm interested in but that still fails with mdbtools. I = assume anything done to =0Amake mdbtools work with that database would also= work with the original.=0A=0AThanks for any help that anyone can provide.= =0A=0A-- =0AAndrew Gaffney http://dev.gento= o.org/~agaffney/=0AGentoo Linux Developer Catalyst/Installer + = x86 release coordinator=0A=0A=0A=0A=0A=0A=0A=0A =0A__________________= __________________________________________________________________=0ASick s= ense of humor? Visit Yahoo! TV's =0AComedy with an Edge to see what's on, w= hen. =0Ahttp://tv.yahoo.com/collections/222 |
|
From: Andrew G. <aga...@ge...> - 2007-09-05 02:17:49
|
I've got an Access 97 format database that's being used with a cash register application (Micro Register). For some reason, mdbtools doesn't recognize it as a valid Access database. I've tried upgrading it to Access 2000 and 2002, as well as doing "Compact & Repair". Here's what I get when I try to play around with it: mal ~ # mdb-ver /tmp/microreg.mdb JET3 mal ~ # mdb-schema /tmp/microreg.mdb File does not appear to be an Access database mal ~ # mdb-schema -S /tmp/microreg.mdb File does not appear to be an Access database Now, if I export one table from this database into a blank Access 2000 database, the new file can be read just fine by mdbtools. I tried just removing all the tables except the one I exported from the original (thinking it was one of the other tables that was causing problems), but mdbtools didn't like that, either. I'd just do the one-time export and use that, but I need "real-time" synchronization between this Access database and an e-commerce site I'm putting together for the business that runs this cash register application. I've looked into other solutions such as using an ODBC network gateway, but I can't find anything that would work with perl or PHP in linux If it helps, both 0.5 and 0.6_pre1 would segfault if I ran 'mdb-schema -S' on the file, but a more recent CVS checkout (output above) fails a bit more gracefully. I can also post a version of the database with just the single table I'm interested in but that still fails with mdbtools. I assume anything done to make mdbtools work with that database would also work with the original. Thanks for any help that anyone can provide. -- Andrew Gaffney http://dev.gentoo.org/~agaffney/ Gentoo Linux Developer Catalyst/Installer + x86 release coordinator |
|
From: Werner E. <we...@gm...> - 2007-08-28 13:08:52
|
Hello!!! I want to help in PostgreSQL Export Scripts. There's some kind of source code documentation?. I used the tool provided to export the schema and i think it's great (about the DDL), but i wanna help to improve it, exporting the data and indexes too. |
|
From: tanmayee k. <tan...@ya...> - 2007-08-27 18:46:10
|
Good Day,
I want to try using this tool to read access data into a text file. All I have been able to do is to download the files into my unix dir along with the prerequisites. I have unzipped all the files. I have followed the steps given in the site but I still dont have a clear picture of how this tool can be used. Could someone please guide me step by step with this. I also wanted to know if there is any other way of installing this tool other than as root?
Thanks in advance!
Tanmayee
---------------------------------
Take the Internet to Go: Yahoo!Go puts the Internet in your pocket: mail, news, photos & more. |
|
From: Grace L. <mg...@gm...> - 2007-08-02 01:39:33
|
hi, when i tried to access the mdb file using unixodbc DataManager that comes with redhat, fault segmentation occurs. accdg to redhatthe The application left unixODBC on line 2 below, line 1 and 0 are in /usr/local/lib/libmdbodbc.so.0. what do i need to do? pls help. Thanks here's the core dump gdb) bt #0 0x002be00b in mdb_get_relationships (mdb=0x8786d68) at backend.c:232 #1 0x002bb162 in LookupDSN (params=0x878abd8, dsnName=0x878a600 "[K") at connectparams.c:270 #2 0x002367f6 in SQLFetch (statement_handle=0x878a600) at SQLFetch.c:293 #3 0x0805f6c8 in classTables::LoadTables (this=0x8787470) at classTables.cpp:100 #4 0x04fb58a9 in QListView::setOpen (this=0x86b63e8, item=0x8787470, open=true) at widgets/qlistview.cpp:6840 #5 0x04fb9774 in QListView::contentsMousePressEventEx (this=0x86b63e8, e=0xbfec48d0) at widgets/qlistview.cpp:4272 #6 0x04fb9856 in QListView::contentsMousePressEvent (this=0x8786d68, e=0x8786d68) at widgets/qlistview.cpp:4203 #7 0x04fdf27f in QScrollView::viewportMousePressEvent (this=0x86b63e8, e=0xbfec4df0) at widgets/qscrollview.cpp:1731 #8 0x04fe16e0 in QScrollView::eventFilter (this=0x86b63e8, obj=0x86b6d30, e=0xbfec4df0) at widgets/qscrollview.cpp:1497 #9 0x04fb16a8 in QListView::eventFilter (this=0x86b63e8, o=0x86b6d30, e=0xbfec4df0) at widgets/qlistview.cpp:3833 #10 0x04ecee52 in QObject::activate_filters (this=0x86b6d30, e=0xbfec4df0) at kernel/qobject.cpp:902 #11 0x04ecef0b in QObject::event (this=0x86b6d30, e=0xbfec4df0) at kernel/qobject.cpp:735 #12 0x04f072fa in QWidget::event (this=0x86b6d30, e=0xbfec4df0) at kernel/qwidget.cpp:4672 #13 0x04e72b49 in QApplication::internalNotify (this=0xbfec5450, receiver=0x86b6d30, Best Regards, Grace Lim Suy Sing Commercial Corporation Tel#: (632) 247-4134 Fax#: (632) 243-9190 |
26 messages has been excluded from this view by a project administrator.
