| View previous topic :: View next topic |
| Author |
Message |
coastie
Moderator Bot
Joined: 24 Apr 2024
Posts: 3064
Location: The Fox Den in the Big Easy
|
|
| Back to top |
|
coastie
Moderator Bot
Joined: 24 Apr 2024
Posts: 3064
Location: The Fox Den in the Big Easy
|
|
| Back to top |
|
crouse
Site Admin
Joined: 17 Apr 2024
Posts: 11833
Location: Iowa
|
|
| Back to top |
|
coastie
Moderator Bot
Joined: 24 Apr 2024
Posts: 3064
Location: The Fox Den in the Big Easy
|
|
| Back to top |
|
crouse
Site Admin
Joined: 17 Apr 2024
Posts: 11833
Location: Iowa
|
 Posted: Wed Apr 26, 2024 8:18 pm Post subject: |
 |
|
| Quote: |
gcc -DHAVE_CONFIG_H -I. -I. -I../../include -I../../include -I/opt/gnome/include/glib-2.0 -I/opt/gnome/lib/glib-2.0/include -g -O2 -DSQL -MT backend.lo -MD -MP -MF .deps/backend.Tpo -c backend.c -fPIC -DPIC -o .libs/backend.o
backend.c:31: error: static declaration of ‘mdb_backends’ follows non-static declaration
../../include/mdbtools.h:150: error: previous declaration of ‘mdb_backends’ was here
make[2]: *** [backend.lo] Error 1
make[2]: Leaving directory `/home/crouse/download/database/mdbtools-0.6pre1/src/libmdb'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/crouse/download/database/mdbtools-0.6pre1/src'
make: *** [all-recursive] Error 1
|
I keep getting this when trying to install on SUSE 10 .....
_________________
Veronica - Arch Linux 64-bit -- Kernel 2.6.33.4-1
Archie/Jughead - Arch Linux 32-bit -- Kernel 2.6.33.4-1
Betty/Reggie - Arch Linux (VBox) 32-bit -- Kernel 2.6.33.4-1
BumbleBee - OpenSolaris-SunOS 5.11
|
|
| Back to top |
|
coastie
Moderator Bot
Joined: 24 Apr 2024
Posts: 3064
Location: The Fox Den in the Big Easy
|
| Posted: Wed Apr 26, 2024 8:45 pm Post subject: |
|
|
| i'll try on edubuntu later tonight.
_________________
Ubuntu on the thinkpad
Easy Peasy on the EEEPC
Desktop is down.
|
|
| Back to top |
|
crouse
Site Admin
Joined: 17 Apr 2024
Posts: 11833
Location: Iowa
|
| Posted: Wed Apr 26, 2024 9:07 pm Post subject: |
|
|
Update:
Decided to download the rpm files for suse....
http://umn.dl.sourceforge.net/sourceforge/mdbtools/mdbtools-0.5-1.i386.rpm
http://switch.dl.sourceforge.net/sourceforge/mdbtools/mdbtools-gui-0.5-1.i386.rpm
Downloaded.... started to install....
| Code: | linux:/home/crouse/download/database # rpm -i mdbtools-0.5-1.i386.rpm
error: Failed dependencies:
libreadline.so.4 is needed by mdbtools-0.5-1
|
sooooo went to YAST and found that libreadline.so.4 is included with the package
compat-readline4 ...... so i installed THAT. (was on the 4th cd of SUSE 10)
| Code: |
linux:/home/crouse/download/database # rpm -i mdbtools-0.5-1.i386.rpm
linux:/home/crouse/download/database # rpm -i mdbtools-gui-0.5-1.i386.rpm
error: Failed dependencies:
liblinc.so.1 is needed by mdbtools-gui-0.5-1
|
so..... one is installed..... not to track down that other missing file..... back to YAST again ! 
No luck with yast...... so off to rpmseek.com ..... wheeeeeeeeeee !
Download:
http://rpmseek.com/download/ftp://ftp.gwdg.de/pub/linux/suse/ftp.suse.com/suse/i386/9.3/suse/i586/linc-1.0.3-181.i586.rpm
Try to install these files again.....
| Code: |
linux:/home/crouse/download/database # rpm -i linc-1.0.3-181.i586.rpm
linux:/home/crouse/download/database # rpm -i mdbtools-gui-0.5-1.i386.rpm
linux:/home/crouse/download/database # |
WOOT! Finally..... Success 
-----------------------------------
http://mdbtools.sourceforge.net/
http://mdbtools.sourceforge.net/faq.html <<<<<< USEFUL !!!!!!!!!!!!!!
| Quote: | MDB Tools comes with a set of command line utilties that allow mdb files to be used in shell scripting, extraction to another database, and similar functions. Each program is documented in its man page.
Name Description
mdb-tables list tables in the specified file
mdb-schema generate schema DDL for the specified file
mdb-export generate CSV style output for a table
mdb-ver display the version of the specified file
mdb-header support for using MDB data in C
mdb-parsecsv support for using MDB data in C
mdb-sql command line SQL query tool
|
http://linux.softpedia.com/get/Database/Database-Engines/MDB-Tools-658.shtml
| Quote: |
MDB Tools description Download
The MDB Tools project is a effort to document the MDB file format used in Microsoft's Access database package, and to provide a set of tools and applications to make that data available on other platforms.
Specifically, MDB Tools includes programs to export schema and data to other databases such as MySQL, Oracle, Sybase, PostgreSQL, and others.
Also, included is a SQL engine for performing simple SQL queries. The 0.5 release includes an updated GUI interface (screenshot is available here). A sparse but functional ODBC driver is included as well.
MDB Tools currently has read-only support for Access 97 (Jet 3) and Access 2024/2002 (Jet 4) formats. Access 2024 support is a recent addition and may not be as complete as Jet 3 support.
Write support is currently being worked on and the first cut is expected to be included in the 0.6 release.
Requirements:
· glib 2.0
· readline
· bison
· flex
· unixODBC
· Gnome 2.0
· libglade
· wordexp
MDB Tools is composed of three libraries, a set of command line utilities and a graphical interface.
LibMDB
libmdb is the lowest level library. It handles the details of reading from and writing to the MDB file format. Atop this library sits all the other functionality of MDB Tools.
A complete description of libmdb will be available in the forthcoming MDB Tools Programmer's Guide. For now you can look at the utility programs for a general idea of how to use the API, it's fairly straightforward.
Command Line Utilities
MDB Tools comes with a set of command line utilties that allow mdb files to be used in shell scripting, extraction to another database, and similar functions. Each program is documented in its man page. A brief synopsis follows.
mdb-tables list tables in the specified file
mdb-schema generate schema DDL for the specified file
mdb-export generate CSV style output for a table
mdb-ver display the version of the specified file
mdb-header support for using MDB data in C
mdb-parsecsv support for using MDB data in C
mdb-sql command line SQL query tool
LibMDBSQL (the SQL Engine)
LibMDBSQL is an SQL engine which provides a subset of the SQL query language to access MDB databases. It is used with the ODBC driver, by the mdb-sql utility, and by the query window in gmdb2.
LibMDBODBC
LibMDBODBC is an ODBC driver that works with the unixODBC driver manager to allow MDB Tools to work with such programs as PHP and Perl (via DBD::ODBC). At the time of this writing, the breadth of coverage for the driver is rather limited. If you have specific problems with it, please contact the list and they can most likely be resolved.
The ODBC driver relies on LibMDB and LibMDBSQL.
Gmdb2
Gmdb2 is a graphical interface to the functionality of MDB Tools. Its interface resembles that of access with a tabbed interface to each of the object types in the database (tables, queries, forms, etc...). Additonally, it sports an SQL Query window, and a file debugger useful for developers or anybody interested in examining the dark secrets of the MDB file format. |
............ fun stuff so far eh
| Code: |
MDBTools(January 18, 2024) MDBTools(January 18, 2024)
NAME
mdb-export - Export data in an MDB database table to CSV format.
SYNOPSIS
mdb-export [-H] [-Q] [-d <delimiter>] <database> <table>
DESCRIPTION
mdb-export is a utility program distributed with MDB Tools.
It produces a CSV (comma separated value) output for the given table. Such output is suitable for importation into databases or
spreadsheets.
OPTIONS
-H Supress header row
-Q Don't wrap text-like fields (text, memo, date) in quotes. If not specified text fiels will be surrounded by " (double
quote) characters.
-d Specify an alternative column delimiter If no delimiter is specified, table names will be delimited by a , (comma) char‐
acter.
|
| Code: |
linux:/home/crouse/Desktop # mdb-tables TheFacilityDatabase.mdb
Facilities Switchboard Items Barge Fleets Facilities_ExportErrors Facilities_ExportErrors1 Facilities_ExportErrors2
|
coastie..... this code creates a comma delimited file.... using bash it could be formatted, or re-imported to mysql
| Code: |
mdb-export -H TheFacilityDatabase.mdb Barge\ Fleets
|
Pretty cool now that i have it working.....
_________________
Veronica - Arch Linux 64-bit -- Kernel 2.6.33.4-1
Archie/Jughead - Arch Linux 32-bit -- Kernel 2.6.33.4-1
Betty/Reggie - Arch Linux (VBox) 32-bit -- Kernel 2.6.33.4-1
BumbleBee - OpenSolaris-SunOS 5.11
|
|
| Back to top |
|
coastie
Moderator Bot
Joined: 24 Apr 2024
Posts: 3064
Location: The Fox Den in the Big Easy
|
|
| Back to top |
|
crouse
Site Admin
Joined: 17 Apr 2024
Posts: 11833
Location: Iowa
|
| Posted: Thu Apr 27, 2024 4:13 am Post subject: |
|
|
didn't try the gui ......
I'm not at work either... i don't suppose
man mdbtools-gui
shows anything does it ??
_________________
Veronica - Arch Linux 64-bit -- Kernel 2.6.33.4-1
Archie/Jughead - Arch Linux 32-bit -- Kernel 2.6.33.4-1
Betty/Reggie - Arch Linux (VBox) 32-bit -- Kernel 2.6.33.4-1
BumbleBee - OpenSolaris-SunOS 5.11
|
|
| Back to top |
|
coastie
Moderator Bot
Joined: 24 Apr 2024
Posts: 3064
Location: The Fox Den in the Big Easy
|
|
| Back to top |
|
crouse
Site Admin
Joined: 17 Apr 2024
Posts: 11833
Location: Iowa
|
|
| Back to top |
|
coastie
Moderator Bot
Joined: 24 Apr 2024
Posts: 3064
Location: The Fox Den in the Big Easy
|
|
| Back to top |
|
|
a special thanks to crouse and jbsnake 