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: Toia A. <to...@ke...> - 2003-04-04 13:23:36
|
Hello Sirs
=20
ENVIRONMENT:
Linux Red Hat 8.0
=20
TARGHET:=20
Retrieve data from a .mdb file mounted on linux file system from
PHP-HTML=20
=20
=20
I=92ve successfully installed mdb tools:
./configure =96-with-unixodbc
make
make install
=20
I tried to set up a DSN using ODBCConfig but it seems that the setup
driver file is missing.
So I=92ve manually insert DSN:
=20
*** ODBC.INI:
[MSAccess]
Description =3D Microsoft Access
Driver =3D MDBToolsODBC
Database =3D /var/www/mdb/test.mdb
Servername =3D localhost
UserName =3D
Password =3D=20
Port =3D 5432
=20
*** ODBCINST.INI:
[MDBToolsODBC]
Description =3D MDB Tools ODBC drivers
Driver =3D /usr/local/lib/libmdbodbc.so.0
Setup =3D
FileUsage =3D 1
CPTimeout =3D=20
CPReuse =3D=20
=20
*** myappl.PHP:
<?php
/* connect to microsoft access on dots machine */
$myDB =3D odbc_connect("MSAccess","","");
$query =3D "select mfg from tblModems";
$result =3D odbc_exec($myDB, $query);
$report =3D odbc_fetch_row($result);
echo odbc_result($result, 1);
odbc_close($myDB);
=20
but when I try to use my DSN inside the php-html file MS Explorer tell
me:
Warning: SQL error: [unixODBC]Could not find Database parameter, SQL
state 08001 in SQLConnect in
/usr/keb/apache/htdocs-portal/keb-php/customer.php on line 72
=20
Thanks in advance.
=20
KEB ITALIA S.R.L.
Toia Andrea
Centro Elaborazione Dati
Sistema Qualit=E0
=20
|
|
From: Brian B. <ca...@ai...> - 2003-04-03 14:59:01
|
Hmmm...possibly confused by the relative path, what if you give=20 --with-unixodbc a full path (/home/myuser/src/unixODBC, or whatever)? On Thu, 3 Apr 2003, Toia Andrea wrote: > Hi sir, > =20 > I=92m trying to install =93mdb tools 0.5rc2=94. > This is what I made: > 1. unpacked the .tar.gz file > 2. ./configure =96-prefix=3D/usr/keb/mdbtools =96-enable-sql > =96-with-unixodbc=3D../unixODBC > =20 > after that .. > make > .. > [make 2] *** [odbc.lo] Error 1 > =20 > and make stopped. > =20 > Can someone help me ? > Thanks in advance > =20 > =20 > KEB ITALIA S.R.L. > Toia Andrea > Centro Elaborazione Dati > Sistema Qualit=E0 > =20 >=20 |
|
From: Toia A. <to...@ke...> - 2003-04-03 13:55:09
|
Good morning sir I=92ve successfully installed mdbtools-0.5rc2.tar.gz: ./ configure =96-prefix=3D/usr/keb/mdbtools =96-with-unixodbc make make install =20 Everything seems to work fine: I tested command line utilities and gmdb2 too. I need to get mdbtools works fine also with unixODBC Driver Manager because I must create a DSN that will be able to work with PHP. PHP make a connection with a DSN and then send SQL requests to it to get data back. The problem is to install the driver so that unixODBC Driver Manager can successfully create a DSN. =20 Can anyone help me ? =20 =20 =20 KEB ITALIA S.R.L. Toia Andrea Centro Elaborazione Dati Sistema Qualit=E0 =20 |
|
From: Toia A. <to...@ke...> - 2003-04-03 07:05:19
|
Hi sir, =20 I=92m trying to install =93mdb tools 0.5rc2=94. This is what I made: 1. unpacked the .tar.gz file 2. ./configure =96-prefix=3D/usr/keb/mdbtools =96-enable-sql =96-with-unixodbc=3D../unixODBC =20 after that .. make .. [make 2] *** [odbc.lo] Error 1 =20 and make stopped. =20 Can someone help me ? Thanks in advance =20 =20 KEB ITALIA S.R.L. Toia Andrea Centro Elaborazione Dati Sistema Qualit=E0 =20 |
|
From: Brian B. <ca...@ai...> - 2003-03-27 11:49:00
|
If you send me the database offline I can take a look. Brian On Thu, 27 Mar 2003, Daniel Austin wrote: > [Moderator: Please note, previously sent from a different, unsubscribed > address. Sorry for the inconvenience.] > > Hi, > > This list seems pretty low-activity. Hope it's still active. > > MDB Tools is a great effort -- kudos to all involved. The only problem I > have (and others seem to have too, judging by the list archive and > Sourceforge bug list) is that JET4 MDB files get some of their columns > shuffled. > > I'm using 0.5rc2 and have applied two patches for JET4 found in the > Sourceforge bug list but no joy. The database has 20 columns, the > shuffling starts at the 9th column. > > Has anyone experiencing this problem found a solution? It's mainly > mdb-export that I need although mdb-sql produces identical behaviour so > it's probably a libmdb problem. (One of my column headings also gets > truncated: "General Construction Description of Buil" -- should be > "Building", not "Buil"). > > I have some budget to pay for contract programming work although > deadlines are now really tight -- I've been battling this on my own for > a little too long. > > Hope someone can help. > > Thanks. > > Dan > |
|
From: Daniel A. <dan...@we...> - 2003-03-27 03:24:21
|
[Moderator: Please note, previously sent from a different, unsubscribed address. Sorry for the inconvenience.] Hi, This list seems pretty low-activity. Hope it's still active. MDB Tools is a great effort -- kudos to all involved. The only problem I have (and others seem to have too, judging by the list archive and Sourceforge bug list) is that JET4 MDB files get some of their columns shuffled. I'm using 0.5rc2 and have applied two patches for JET4 found in the Sourceforge bug list but no joy. The database has 20 columns, the shuffling starts at the 9th column. Has anyone experiencing this problem found a solution? It's mainly mdb-export that I need although mdb-sql produces identical behaviour so it's probably a libmdb problem. (One of my column headings also gets truncated: "General Construction Description of Buil" -- should be "Building", not "Buil"). I have some budget to pay for contract programming work although deadlines are now really tight -- I've been battling this on my own for a little too long. Hope someone can help. Thanks. Dan -- Daniel Austin (Internet Technology Manager, Westfield Ltd) Phone: +61 2 9358 7983; Fax: +61 2 9358 7188 |
|
From: Daniel A. <dan...@we...> - 2003-03-27 00:47:34
|
Hi, This list seems pretty low-activity. Hope it's still active. MDB Tools is a great effort -- kudos to all involved. The only problem I have (and others seem to have too, judging by the list archive and Sourceforge bug list) is that JET4 MDB files get some of their columns shuffled. I'm using 0.5rc2 and have applied two patches for JET4 found in the Sourceforge bug list but no joy. The database has 20 columns, the shuffling starts at the 9th column. Has anyone experiencing this problem found a solution? It's mainly mdb-export that I need although mdb-sql produces identical behaviour so it's probably a libmdb problem. (One of my column headings also gets truncated: "General Construction Description of Buil" -- should be "Building", not "Buil"). I have some budget to pay for contract programming work although deadlines are now really tight -- I've been battling this on my own for a little too long. Hope someone can help. Thanks. Dan -- Daniel Austin (Internet Technology Manager, Westfield Ltd) Phone: +61 2 9358 7983; Fax: +61 2 9358 7188 |
|
From: Brian B. <ca...@ai...> - 2003-03-20 23:46:52
|
Hi, The API is unfortunately not extremely stable, but all changes over the past few versions have been minor. I would not expect any major upheavels in the future (an options parameter to mdb_open is planned), so most version differences could be ifdef'd without too much ugliness. MS stores unicode in UCS-2 format for most of its products, Jet included. It is my hope to use libiconv to convert it to UTF-8 format in the future, but currently we take the short cut of lopping the high order byte off which reduces it to iso-1 (roughly speaking). This is acceptable for most western european languages but obviously break for cyrillic, mid-eastern and asian languages among others. Brian On 20 Mar 2003, Joseph Wenninger wrote: > Hi > > I found this project by accident, and I'd like to use it for importing > data into kexi (KOffice upcoming database frontend). There for I have > two questions > 1) how stable is the API for opening/reading a database > 2) At least jet4 (not sure about 3), if I'm not mistaken supports > unicode data. How is that encoded ? utf8, utf16, ... ? I couldn't see > any information about that. > > Kind regards > Joseph Wenninger |
|
From: Joseph W. <jo...@kd...> - 2003-03-20 22:30:52
|
Hi I found this project by accident, and I'd like to use it for importing data into kexi (KOffice upcoming database frontend). There for I have two questions 1) how stable is the API for opening/reading a database 2) At least jet4 (not sure about 3), if I'm not mistaken supports unicode data. How is that encoded ? utf8, utf16, ... ? I couldn't see any information about that. Kind regards Joseph Wenninger |
|
From: Edouard F. <edo...@pa...> - 2003-03-13 10:23:54
|
Hi everybody, As axxel (post of 2002-12-27), my mdb-sql works fine in interactive mode but when i pipe some sql statements into mdb-sql it returns segmentation faults : [uranus]# echo "SELECT * FROM droits" | mdb-sql /data.mdb 1 => 2 => Segmentation fault I have mdbtools 0.4 and readline-4.3-3 Before updating readline from version 4.2a-4 to 4.3-3, i had : [uranus]# echo "SELECT * FROM droits" | mdb-sql /data.mdb readline: warning: rl_prep_terminal: cannot get terminal settings1 => readline: warning: rl_prep_terminal: cannot get terminal settings2 => Segmentation fault Any idea or comment about that ? Thx for any answer and for this projet. Ed. |
|
From: mayur k <ma...@pr...> - 2003-03-11 14:28:09
|
Pls help The information provided for getting the row wise data is pretty confusing.There is no delimiter or record length of each row of record Where can i find this information in the file. Thanks in advance. -- __________________________________________________________ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup |
|
From: <inf...@cu...> - 2003-03-06 03:19:22
|
Excuse my. I do not speak english. I need to insert registries in Data Base from Access. Since I do it. This is possible. Is it possible to insert lines in Data Base -Access-? Thanks. |
|
From: <inf...@cu...> - 2003-03-06 03:07:36
|
Excuse my. I do not speak english. I need to insert registries in Data Base from Access. Since I do it. This is possible. Is it possible to insert lines in Data Base -Access-? Thanks. |
|
From: Stephen N. <sen...@td...> - 2003-03-02 20:42:09
|
Hello all... I'm trying to access an Access file using JDBC, the Sun ODBC driver, unixODBC, and the mdbtools-odbc driver. I've configured unixODBC to access the correct data source. However, whenever I attempt to run the program concerned, I get a "Signal 11". The error log is reproduced at the end of the message. I am able to access the file using gmdb2, which reports it as Jet version 4, 135 pages, 42 objects. I can produce the Java source code and the MDB file as needed. Any help would be greatly appreciated. Error log: An unexpected exception has been detected in native code outside the VM. Unexpected Signal : 11 occurred at PC=0x4D3031D7 Function=mdb_fetch_row+0x17 Library=/usr/lib/libmdbodbc.so Current Java thread: at sun.jdbc.odbc.JdbcOdbc.fetch(Native Method) at sun.jdbc.odbc.JdbcOdbc.SQLFetch(JdbcOdbc.java:3125) at sun.jdbc.odbc.JdbcOdbcResultSet.next(JdbcOdbcResultSet.java:1295) at sun.jdbc.odbc.JdbcOdbcConnection.buildTypeInfo(JdbcOdbcConnection.java:1498) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:381) at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174) - locked <0x4442cf98> (a sun.jdbc.odbc.JdbcOdbcDriver) at java.sql.DriverManager.getConnection(DriverManager.java:512) - locked <0x4881b700> (a java.lang.Class) at java.sql.DriverManager.getConnection(DriverManager.java:193) - locked <0x4881b700> (a java.lang.Class) at Edu.Cmu.Cs.Se.Pet.DataBase.DBConnection.initializeConnection(DBConnection.java:62) at Edu.Cmu.Cs.Se.Pet.DataBase.DBConnection.<init>(DBConnection.java:25) at Edu.Cmu.Cs.Se.Pet.DataBase.DBConnection.CreateConnection(DBConnection.java:33) at Edu.Cmu.Cs.Se.Pet.DataBase.DBBroker.<init>(DBBroker.java:32) at Edu.Cmu.Cs.Se.Pet.Business.LifeCycle.validateDataBase(LifeCycle.java:92) at Edu.Cmu.Cs.Se.Pet.UI.PetCycleForm.LifeCycleButton_actionPerformed(PetCycleForm.java:156) at Edu.Cmu.Cs.Se.Pet.UI.PetCycleForm$2.actionPerformed(PetCycleForm.java:104) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1764) at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1817) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:419) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:257) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:245) at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:227) at java.awt.Component.processMouseEvent(Component.java:5093) at java.awt.Component.processEvent(Component.java:4890) at java.awt.Container.processEvent(Container.java:1566) at java.awt.Component.dispatchEventImpl(Component.java:3598) at java.awt.Container.dispatchEventImpl(Container.java:1623) at java.awt.Component.dispatchEvent(Component.java:3439) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:3450) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3165) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3095) at java.awt.Container.dispatchEventImpl(Container.java:1609) at java.awt.Window.dispatchEventImpl(Window.java:1585) at java.awt.Component.dispatchEvent(Component.java:3439) at java.awt.EventQueue.dispatchEvent(EventQueue.java:450) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:197) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:150) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:144) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:136) at java.awt.EventDispatchThread.run(EventDispatchThread.java:99) Dynamic libraries: 08048000-0804e000 r-xp 00000000 03:02 981801 /usr/java/j2sdk1.4.1_01/bin/java 0804e000-0804f000 rw-p 00005000 03:02 981801 /usr/java/j2sdk1.4.1_01/bin/java 40000000-40012000 r-xp 00000000 03:02 3597442 /lib/ld-2.2.93.so 40012000-40013000 rw-p 00012000 03:02 3597442 /lib/ld-2.2.93.so 40013000-4001c000 r-xp 00000000 03:02 2845640 /usr/java/j2sdk1.4.1_01/jre/lib/i386/native_threads/libhpi.so 4001c000-4001d000 rw-p 00008000 03:02 2845640 /usr/java/j2sdk1.4.1_01/jre/lib/i386/native_threads/libhpi.so 4001e000-40021000 r--s 00000000 03:02 33411 /usr/java/j2sdk1.4.1_01/jre/lib/ext/dnsns.jar 40021000-40022000 r-xp 00000000 03:02 2174833 /usr/X11R6/lib/X11/locale/common/xlcUTF8Load.so.2 40022000-40023000 rw-p 00000000 03:02 2174833 /usr/X11R6/lib/X11/locale/common/xlcUTF8Load.so.2 40023000-40024000 rw-s 00000000 00:04 77889567 /SYSV79027ec3 (deleted) 40025000-40032000 r-xp 00000000 03:02 1798727 /lib/i686/libpthread-0.10.so 40032000-40035000 rw-p 0000d000 03:02 1798727 /lib/i686/libpthread-0.10.so 40056000-40058000 r-xp 00000000 03:02 3597455 /lib/libdl-2.2.93.so 40058000-40059000 rw-p 00001000 03:02 3597455 /lib/libdl-2.2.93.so 40059000-40371000 r-xp 00000000 03:02 3254878 /usr/java/j2sdk1.4.1_01/jre/lib/i386/client/libjvm.so 40371000-40525000 rw-p 00317000 03:02 3254878 /usr/java/j2sdk1.4.1_01/jre/lib/i386/client/libjvm.so 40535000-40547000 r-xp 00000000 03:02 3597459 /lib/libnsl-2.2.93.so 40547000-40548000 rw-p 00012000 03:02 3597459 /lib/libnsl-2.2.93.so 4054a000-4056b000 r-xp 00000000 03:02 1798725 /lib/i686/libm-2.2.93.so 4056b000-4056c000 rw-p 00021000 03:02 1798725 /lib/i686/libm-2.2.93.so 4056c000-4057c000 r-xp 00000000 03:02 1357666 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libverify.so 4057c000-4057e000 rw-p 0000f000 03:02 1357666 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libverify.so 4057e000-4059f000 r-xp 00000000 03:02 1357654 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libjava.so 4059f000-405a1000 rw-p 00020000 03:02 1357654 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libjava.so 405a1000-405b6000 r-xp 00000000 03:02 1357667 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libzip.so 405b6000-405b8000 rw-p 00014000 03:02 1357667 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libzip.so 405b8000-41c86000 r--s 00000000 03:02 2470024 /usr/java/j2sdk1.4.1_01/jre/lib/rt.jar 41cc9000-41ce0000 r--s 00000000 03:02 2470025 /usr/java/j2sdk1.4.1_01/jre/lib/sunrsasign.jar 41ce0000-41d51000 r--s 00000000 03:02 2470018 /usr/java/j2sdk1.4.1_01/jre/lib/jsse.jar 41d51000-41d64000 r--s 00000000 03:02 2470017 /usr/java/j2sdk1.4.1_01/jre/lib/jce.jar 41f8e000-41f9c000 r--s 00000000 03:02 33412 /usr/java/j2sdk1.4.1_01/jre/lib/ext/ldapsec.jar 41f9c000-41f9e000 r-xp 00000000 03:02 1782502 /usr/lib/gconv/ISO8859-1.so 41f9e000-41f9f000 rw-p 00001000 03:02 1782502 /usr/lib/gconv/ISO8859-1.so 41fa0000-41fa9000 r-xp 00000000 03:02 3597475 /lib/libnss_files-2.2.93.so 41fa9000-41faa000 rw-p 00008000 03:02 3597475 /lib/libnss_files-2.2.93.so 41faa000-41fc7000 r--s 00000000 03:02 33414 /usr/java/j2sdk1.4.1_01/jre/lib/ext/sunjce_provider.jar 41fc7000-41ff7000 r--s 00000000 03:02 213506 /home/steven/PET/Pet.jar 41ff7000-41ffe000 r-xp 00000000 03:02 3254083 /usr/X11R6/lib/libXp.so.6.2 41ffe000-41fff000 rw-p 00006000 03:02 3254083 /usr/X11R6/lib/libXp.so.6.2 42000000-42126000 r-xp 00000000 03:02 1798723 /lib/i686/libc-2.2.93.so 42126000-4212b000 rw-p 00126000 03:02 1798723 /lib/i686/libc-2.2.93.so 4212f000-423eb000 r--s 00000000 03:02 2470005 /usr/java/j2sdk1.4.1_01/jre/lib/charsets.jar 443eb000-443ef000 r-xp 00000000 03:02 3254093 /usr/X11R6/lib/libXtst.so.6.1 443ef000-443f0000 rw-p 00004000 03:02 3254093 /usr/X11R6/lib/libXtst.so.6.1 4c471000-4c630000 r--p 00000000 03:02 474210 /usr/lib/locale/locale-archive 4c834000-4c8d3000 r--s 00000000 03:02 33413 /usr/java/j2sdk1.4.1_01/jre/lib/ext/localedata.jar 4c8d3000-4cb9a000 r-xp 00000000 03:02 1357646 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libawt.so 4cb9a000-4cbaf000 rw-p 002c6000 03:02 1357646 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libawt.so 4cbd4000-4cc27000 r-xp 00000000 03:02 1357662 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libmlib_image.so 4cc27000-4cc28000 rw-p 00052000 03:02 1357662 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libmlib_image.so 4cc28000-4cc2e000 r--s 00000000 03:02 1782557 /usr/lib/gconv/gconv-modules.cache 4cc3a000-4cc88000 r-xp 00000000 03:02 3254091 /usr/X11R6/lib/libXt.so.6.0 4cc88000-4cc8c000 rw-p 0004d000 03:02 3254091 /usr/X11R6/lib/libXt.so.6.0 4cc8c000-4cc99000 r-xp 00000000 03:02 3254071 /usr/X11R6/lib/libXext.so.6.4 4cc99000-4cc9a000 rw-p 0000c000 03:02 3254071 /usr/X11R6/lib/libXext.so.6.4 4cc9a000-4cd75000 r-xp 00000000 03:02 3254063 /usr/X11R6/lib/libX11.so.6.2 4cd75000-4cd78000 rw-p 000da000 03:02 3254063 /usr/X11R6/lib/libX11.so.6.2 4cd78000-4cd80000 r-xp 00000000 03:02 3254061 /usr/X11R6/lib/libSM.so.6.0 4cd80000-4cd81000 rw-p 00007000 03:02 3254061 /usr/X11R6/lib/libSM.so.6.0 4cd81000-4cd95000 r-xp 00000000 03:02 3254057 /usr/X11R6/lib/libICE.so.6.3 4cd95000-4cd96000 rw-p 00013000 03:02 3254057 /usr/X11R6/lib/libICE.so.6.3 4cd98000-4ce5e000 r-xp 00000000 03:02 1357650 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libfontmanager.so 4ce5e000-4ce79000 rw-p 000c5000 03:02 1357650 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libfontmanager.so 4ce79000-4cead000 r-xp 00000000 03:02 360920 /usr/lib/libstdc++-2-libc6.1-1-2.9.0.so 4cead000-4ceb9000 rw-p 00033000 03:02 360920 /usr/lib/libstdc++-2-libc6.1-1-2.9.0.so 4cf3c000-4cf58000 r-xp 00000000 03:02 2174831 /usr/X11R6/lib/X11/locale/common/ximcp.so.2 4cf58000-4cf5a000 rw-p 0001b000 03:02 2174831 /usr/X11R6/lib/X11/locale/common/ximcp.so.2 4d260000-4d26f000 r-xp 00000000 03:02 1357645 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libJdbcOdbc.so 4d26f000-4d270000 rw-p 0000e000 03:02 1357645 /usr/java/j2sdk1.4.1_01/jre/lib/i386/libJdbcOdbc.so 4d282000-4d292000 r-xp 00000000 03:02 361168 /usr/lib/libodbcinst.so.1.0.0 4d292000-4d293000 rw-p 0000f000 03:02 361168 /usr/lib/libodbcinst.so.1.0.0 4d293000-4d2f2000 r-xp 00000000 03:02 361162 /usr/lib/libodbc.so.1.0.0 4d2f2000-4d2f7000 rw-p 0005f000 03:02 361162 /usr/lib/libodbc.so.1.0.0 4d2f7000-4d308000 r-xp 00000000 03:02 361250 /usr/lib/libmdbodbc.so.0.0.0 4d308000-4d30a000 rw-p 00010000 03:02 361250 /usr/lib/libmdbodbc.so.0.0.0 4d316000-4d33b000 r-xp 00000000 03:02 359759 /usr/lib/libglib-1.2.so.0.0.10 4d33b000-4d33c000 rw-p 00025000 03:02 359759 /usr/lib/libglib-1.2.so.0.0.10 Local Time = Sun Feb 23 15:36:45 2003 Elapsed Time = 7 # # The exception above was detected in native code outside the VM # # Java VM: Java HotSpot(TM) Client VM (1.4.1_01-b01 mixed mode) # I can provide the Java code if necessary. |
|
From: Marcos L. <ma...@eu...> - 2003-02-16 21:23:20
|
hi!!
i'm new in this list and i have joined it because i have a doubt of mdbtoo=
ls using java in linux. I've looking in Internet how to connect to a MS acc=
ess database but i can't manage it.=20
i'll explain you what i've done and if you see something wrong correct me =
please.
here is the code in java which i have used :
private void Conectar ()
//m=E9todo que realiza las conexiones necesarias a la base de datos.
//Solo se va a hacer una vez en todo el juego, Connection y Stateme=
nt
//se van pasando a las demas clases.
{
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e1){
System.out.println("Imposible cargar la Base de Datos");
}
try {
con =3D DriverManager.getConnection("jdbc:odbc:mine","","");
stmt =3D con.createStatement();
}catch (SQLException e1) {
System.out.println (e1.getMessage());
}
}
then in odbc.ini i have put this:
[mine]
Description =3D mine
Driver =3D MDBToolsODBC
Database =3D /home/raist/prog/mine.mdb
servername =3D localhost
UserName =3D
Password =3D
Port =3D 5432
and in odbcinst.ini :
=09
[MDBToolsODBC]
Description =3D MDB Tools ODBC drivers
Driver =3D /usr/lib/libmdbodbc.so.0
Setup =3D
FileUsage =3D 1
CPTimeout =3D
CPReuse =3D
and finally when i execute it the error is:
raist@palanthas:~/prog$ java hola
No suitable driver
=09
any advice? something wrong? something missing? please reply if you now som=
ething. Thank you
bye
P.D: sorry for my english. I'm spanish and i dont know if i have expressed =
myself well.=20
|
|
From: Paul S. <po...@ma...> - 2003-02-13 12:09:39
|
Hi all,
Apologies for the long mail ! I have developed this patch to get
mdbtools running on OSX so are submitting it for possible inclusion. If
I have got it wrong please tell me so I can fix it, I'm not much of a C
coder :-)
CHEERS
Paul
diff -urN mdbtools-0.5rc2/include/mdbsql.h
mdbtools-0.5rc2mac/include/mdbsql.h
--- mdbtools-0.5rc2/include/mdbsql.h Thu Mar 28 00:00:01 2002
+++ mdbtools-0.5rc2mac/include/mdbsql.h Thu Feb 13 22:24:06 2003
@@ -3,6 +3,12 @@
#include <glib.h>
#include <mdbtools.h>
+#ifdef MAIN
+#define EXTERN
+#else
+#define EXTERN extern
+#endif
+
#ifndef _mdbsql_h_
#define _mdbsql_h_
@@ -39,7 +45,7 @@
MdbSarg *sarg;
} MdbSQLSarg;
-char *g_input_ptr;
+EXTERN char *g_input_ptr;
#undef YY_INPUT
#define YY_INPUT(b, r, ms) (r = mdb_sql_yyinput(b, ms));
diff -urN mdbtools-0.5rc2/include/mdbtools.h
mdbtools-0.5rc2mac/include/mdbtools.h
--- mdbtools-0.5rc2/include/mdbtools.h Mon Jan 13 09:59:42 2003
+++ mdbtools-0.5rc2mac/include/mdbtools.h Thu Feb 13 22:23:42 2003
@@ -17,6 +17,12 @@
* Boston, MA 02111-1307, USA.
*/
+#ifdef MAIN
+#define EXTERN
+#else
+#define EXTERN extern
+#endif
+
#ifndef _mdbtools_h_
#define _mdbtools_h_
@@ -110,7 +116,7 @@
#define IS_JET3(mdb) (mdb->f->jet_version==MDB_VER_JET3)
/* hash to store registered backends */
-GHashTable *mdb_backends;
+EXTERN GHashTable *mdb_backends;
typedef struct {
char **types_table;
diff -urN mdbtools-0.5rc2/src/gmdb2/main2.c
mdbtools-0.5rc2mac/src/gmdb2/main2.c
--- mdbtools-0.5rc2/src/gmdb2/main2.c Wed Jan 15 13:02:07 2003
+++ mdbtools-0.5rc2mac/src/gmdb2/main2.c Thu Feb 13 22:28:34 2003
@@ -15,6 +15,7 @@
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
02111-1307 USA
*/
+#define MAIN
#include <gnome.h>
#include <libgnome/gnome-help.h>
#include <glade/glade.h>
diff -urN mdbtools-0.5rc2/src/util/mdb-array.c
mdbtools-0.5rc2mac/src/util/mdb-array.c
--- mdbtools-0.5rc2/src/util/mdb-array.c Tue Aug 13 03:37:05 2002
+++ mdbtools-0.5rc2mac/src/util/mdb-array.c Thu Feb 13 22:24:52 2003
@@ -21,6 +21,7 @@
/* this is inherited from mdb-export.c, modified to make arrays
similar to
those generated by parsecsv.c */
+#define MAIN
#include "mdbtools.h"
main (int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/mdb-export.c
mdbtools-0.5rc2mac/src/util/mdb-export.c
--- mdbtools-0.5rc2/src/util/mdb-export.c Wed Dec 11 10:35:25 2002
+++ mdbtools-0.5rc2mac/src/util/mdb-export.c Thu Feb 13 22:25:09 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
#define is_text_type(x) (x==MDB_TEXT || x==MDB_MEMO ||
x==MDB_SDATETIME)
diff -urN mdbtools-0.5rc2/src/util/mdb-header.c
mdbtools-0.5rc2mac/src/util/mdb-header.c
--- mdbtools-0.5rc2/src/util/mdb-header.c Tue Aug 13 03:37:05 2002
+++ mdbtools-0.5rc2mac/src/util/mdb-header.c Thu Feb 13 22:25:18 2003
@@ -19,6 +19,7 @@
/* this utility dumps the C headers for an existing database */
/* it will create three files - types.h and dump_types.[ch] */
+#define MAIN
#include "mdbtools.h"
#include <string.h>
diff -urN mdbtools-0.5rc2/src/util/mdb-schema.c
mdbtools-0.5rc2mac/src/util/mdb-schema.c
--- mdbtools-0.5rc2/src/util/mdb-schema.c Tue Dec 31 03:38:52 2002
+++ mdbtools-0.5rc2mac/src/util/mdb-schema.c Thu Feb 13 22:25:43 2003
@@ -18,6 +18,7 @@
/* this utility dumps the schema for an existing database */
+#define MAIN
#include "mdbtools.h"
main (int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/mdb-sql.c
mdbtools-0.5rc2mac/src/util/mdb-sql.c
--- mdbtools-0.5rc2/src/util/mdb-sql.c Mon Jan 6 01:58:33 2003
+++ mdbtools-0.5rc2mac/src/util/mdb-sql.c Thu Feb 13 22:37:42 2003
@@ -21,6 +21,7 @@
#ifdef HAVE_READLINE
#include <readline/readline.h>
#endif
+#define MAIN
#include <string.h>
#include "mdbsql.h"
diff -urN mdbtools-0.5rc2/src/util/mdb-tables.c
mdbtools-0.5rc2mac/src/util/mdb-tables.c
--- mdbtools-0.5rc2/src/util/mdb-tables.c Mon Jan 6 10:49:57 2003
+++ mdbtools-0.5rc2mac/src/util/mdb-tables.c Thu Feb 13 22:25:52 2003
@@ -18,6 +18,7 @@
/* this utility dumps the schema for an existing database */
+#define MAIN
#include "mdbtools.h"
main (int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/mdb-ver.c
mdbtools-0.5rc2mac/src/util/mdb-ver.c
--- mdbtools-0.5rc2/src/util/mdb-ver.c Thu Jan 2 09:29:42 2003
+++ mdbtools-0.5rc2mac/src/util/mdb-ver.c Thu Feb 13 22:25:56 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
main(int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/prcat.c
mdbtools-0.5rc2mac/src/util/prcat.c
--- mdbtools-0.5rc2/src/util/prcat.c Tue Aug 13 03:37:05 2002
+++ mdbtools-0.5rc2mac/src/util/prcat.c Thu Feb 13 22:26:00 2003
@@ -16,6 +16,7 @@
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
02111-1307 USA
*/
+#define MAIN
#include "mdbtools.h"
main(int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/prdata.c
mdbtools-0.5rc2mac/src/util/prdata.c
--- mdbtools-0.5rc2/src/util/prdata.c Tue Aug 13 03:37:05 2002
+++ mdbtools-0.5rc2mac/src/util/prdata.c Thu Feb 13 22:26:04 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
main(int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/prdump.c
mdbtools-0.5rc2mac/src/util/prdump.c
--- mdbtools-0.5rc2/src/util/prdump.c Tue Aug 13 03:37:05 2002
+++ mdbtools-0.5rc2mac/src/util/prdump.c Thu Feb 13 22:26:10 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
main(int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/prindex.c
mdbtools-0.5rc2mac/src/util/prindex.c
--- mdbtools-0.5rc2/src/util/prindex.c Mon Jan 13 09:59:44 2003
+++ mdbtools-0.5rc2mac/src/util/prindex.c Thu Feb 13 22:26:14 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
extern char idx_to_text[];
diff -urN mdbtools-0.5rc2/src/util/prkkd.c
mdbtools-0.5rc2mac/src/util/prkkd.c
--- mdbtools-0.5rc2/src/util/prkkd.c Tue Aug 13 03:37:05 2002
+++ mdbtools-0.5rc2mac/src/util/prkkd.c Thu Feb 13 22:26:18 2003
@@ -16,6 +16,7 @@
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA
02111-1307 USA
*/
+#define MAIN
#include "mdbtools.h"
main(int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/prole.c
mdbtools-0.5rc2mac/src/util/prole.c
--- mdbtools-0.5rc2/src/util/prole.c Mon Jan 6 01:58:33 2003
+++ mdbtools-0.5rc2mac/src/util/prole.c Thu Feb 13 22:26:22 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
void dump_ole(MdbTableDef *table, char *colname, char *sargname);
diff -urN mdbtools-0.5rc2/src/util/prtable.c
mdbtools-0.5rc2mac/src/util/prtable.c
--- mdbtools-0.5rc2/src/util/prtable.c Tue Aug 13 03:37:05 2002
+++ mdbtools-0.5rc2mac/src/util/prtable.c Thu Feb 13 22:26:26 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
main(int argc, char **argv)
diff -urN mdbtools-0.5rc2/src/util/updrow.c
mdbtools-0.5rc2mac/src/util/updrow.c
--- mdbtools-0.5rc2/src/util/updrow.c Thu Jan 2 09:29:42 2003
+++ mdbtools-0.5rc2mac/src/util/updrow.c Thu Feb 13 22:26:33 2003
@@ -18,6 +18,7 @@
* Boston, MA 02111-1307, USA.
*/
+#define MAIN
#include "mdbtools.h"
void read_to_row(MdbTableDef *table, char *sargname);
|
|
From: Brian B. <ca...@ai...> - 2003-02-09 21:54:51
|
The HACKING document refers primarily to Jet 3 with specific differences mentioned for Jet 4. I'm working on a revision of the document that should elevate the Jet 4 stuff to a better standing. I don't know when I'll be able to finish it though. On Sun, 9 Feb 2003, Brett Hunter wrote: > Hi, > I have been going through the HACKING doc and find that it does not apply > to JET 4 files (eg instead of a 3 bytes gap there is 7 byte gap). Is this > true or am I missing something? > Thanks > Brett |
|
From: Brian B. <ca...@ai...> - 2003-02-09 21:41:50
|
Hi, Unfortunately, gmdb2 requires Gnome 2.0 with all its accompanying dependancy hell. In order to make it work with Gnome 1.x and Gnome 2, I would have had to do far too much duplication of effort, so I decided to go straight to Gnome 2 with the unfortunate side effect of not being able to be used by as many people as I'd like. Fortunately the next generation of distro's come with gnome2 already (RedHat 8 for instance has it). The dependancy I know of are listed in the user guide http://mdbtools.sourceforge.net/install/c98.htm In this case you need glib2, gnome2 and libglade2 and anything they rely on. You might want to try garnome for an easy install from sources, or at least that's what I hear. Regarding underscore in mdb-sql that bug fix is in CVS, but didn't get into 0.5, you could manually edit the src/sql/lexer.l and add _ to the NAME and IDENT tokens, see the list archive for more precise instructions. On 4 Feb 2003, Marc Cassuto wrote: > Good evening, > > I was running almost perfectly mdbtools 0.4 (with gmdb) > (On slackware 8.1) > I still had problems with columns using JET4 Databases > but it was enough for my purpose. > > I tried installing the version 0.5 hoping a full-fonctionnal viewer. > But... > > - now mdb-sql does not support the underscore character > (but it did with the version 0.4 ! ) > - now I tried to used gmdb (gmdb2 does not compil) and it crash while > loading > my database > - so I tried to compile gmdb2 and this start to be a long long run : > -> first to get mdbtools 0.5 compiling I had to install glib2, > pkgconfig & gettext > -> mdbtools did compile but there was still error about libglad > (and no binary file > for gmdb) > -> so I installed libglade, but It asked for libxml, atk, gtk+ > (this asked for pango) > -> But I did still not have my binary file for gmdb2 > -> in fact it asked for libgnomeui (that ask for libgnome-2.0 >= > 1.104.0 libgnomecanvas-2.0 >= 1.104.0 libbonoboui-2.0 > >= 1.97.0 gconf-2.0 >= 1.1.1) and I am fed up with this long install... > > Is the way from gmdb still long ? > Is there really no way to get gmdb2 running simply ? > Will I still have gmdb1 running with the new libmdb ? > Can I have a version of libmdg dealing with the underscore ? > > Please help (and excuse-me for this full-of-mistakes engkish language) > > Marc Cassuto. > > |
|
From: Brett H. <ba...@bi...> - 2003-02-09 08:25:49
|
Hi, I have been going through the HACKING doc and find that it does not apply to JET 4 files (eg instead of a 3 bytes gap there is 7 byte gap). Is this true or am I missing something? Thanks Brett --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 |
|
From: Marc C. <mar...@pl...> - 2003-02-04 15:19:24
|
Good evening,
I was running almost perfectly mdbtools 0.4 (with gmdb)
(On slackware 8.1)
I still had problems with columns using JET4 Databases
but it was enough for my purpose.
I tried installing the version 0.5 hoping a full-fonctionnal viewer.
But...
- now mdb-sql does not support the underscore character
(but it did with the version 0.4 ! )
- now I tried to used gmdb (gmdb2 does not compil) and it crash while
loading
my database
- so I tried to compile gmdb2 and this start to be a long long run :
-> first to get mdbtools 0.5 compiling I had to install glib2,
pkgconfig & gettext
-> mdbtools did compile but there was still error about libglad
(and no binary file
for gmdb)
-> so I installed libglade, but It asked for libxml, atk, gtk+
(this asked for pango)
-> But I did still not have my binary file for gmdb2
-> in fact it asked for libgnomeui (that ask for libgnome-2.0 >=
1.104.0 libgnomecanvas-2.0 >= 1.104.0 libbonoboui-2.0
>= 1.97.0 gconf-2.0 >= 1.1.1) and I am fed up with this long install...
Is the way from gmdb still long ?
Is there really no way to get gmdb2 running simply ?
Will I still have gmdb1 running with the new libmdb ?
Can I have a version of libmdg dealing with the underscore ?
Please help (and excuse-me for this full-of-mistakes engkish language)
Marc Cassuto.
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
|
|
From: James M. <ja...@he...> - 2003-02-03 01:18:05
|
Don't know how easy that will be.=20 Any chance you use XML as a medium instead? It might make things easier. = What are you using the data source with?=20 -James hi all, =20 i need to know how to make a data source (DSN) on a linux platform, = for an Access db =20 plz reply if u can help =20 Regards, =20 |
|
From: Rania <ro...@So...> - 2003-02-03 00:19:23
|
hi all, =20 i need to know how to make a data source (DSN) on a linux platform, for = an Access db =20 plz reply if u can help =20 Regards, |
|
From: Brian B. <ca...@ai...> - 2003-01-30 10:26:43
|
Hi,
Do you have any info about the database. Is it possibly encrypted, access
version 2.0 or anything funky like that?
Brian
On Wed, 29 Jan 2003, Wagner Matthias wrote:
> Hi,
>
> I tried both binary .deb-packages and self compiled version of mdbtools
> (with sql-support) to grab some data out of an Access DB which consists
> of 4 tables without any relations or keys. mdb-ver <DB> returns
> "unkown", and every other mdb-* tool segfaults. I debugged it a bit and
> the error seems to be on line 39 of data.c
>
> Program received signal SIGSEGV, Segmentation fault.
> 0x40016a31 in mdb_bind_column (table=0x804ca68, col_num=1,
> bind_ptr=0xbffff918) at data.c:39
> 39 col=g_ptr_array_index(table->columns, col_num - 1);
> [...]
> list
>
> 34 MdbColumn *col;
> 35
> 36 /*
> 37 ** the column arrary is 0 based, so decrement to get 1 based parameter
> 38 */
> 39 col=g_ptr_array_index(table->columns, col_num - 1);
> 40 col->bind_ptr = bind_ptr;
> 41 }
> 42 void mdb_bind_len(MdbTableDef *table, int col_num, int *len_ptr)
> 43 {
>
> And if I inspect the table-pointer, it returns a null pointer (MdbTableDef *) 0x0
> (explains the segfault ;)
> Yet I am in a hurry and can't try to fix that on my own as it was a lot of work..
> any ideas what's wrong?
>
> mfg
> Nec
>
>
> -------------------------------------------------------
> This SF.NET email is sponsored by:
> SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See!
> http://www.vasoftware.com
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
|
|
From: Brian B. <ca...@ai...> - 2003-01-29 13:41:11
|
Hi all, I've checked in the index stuff. I'm pretty sure it doesn't work on Access 2000 databases yet, but haven't been able to look into it. You can turn on following indexes by setting the MDBOPTS environment variable to "use_index", this is temporary until all the issues are sorted. From mdb-sql you can use "set showplan on" to view the query tree and strategy, like: $ mdb-sql Northwind.mdb 1 => set showplan on 1 => set noexec on 1 => select * from Shippers where ShipperID = 1 or ShipperID = 3 2 => go root ---> or left --->---> = 3 right --->---> = 1 Table scanning Shippers 1 => select * from Shippers where ShipperID = 1 2 => go root ---> = 1 Index scanning Shippers using PrimaryKey 1 => setting noexec on, makes the SQL Engine generate a plan but then doesn't execute it. You can check out the efficiency of the query planner using "set stats on/off" like so, 1 => set stats on 1 => select * from Orders where OrderID < 11050 ... 1 => set stats off Physical Page Reads: 26 1 => compared with a table scan: Physical Page Reads: 61 Some of this is probably a bit buggy still but should shake itself out in the next couple of weeks. The main point of all this is supporting joins, there's a pretty big win for large databases but small ones probably won't even notice much difference on single table selects. By the way, once joins are in place we should be able to start executing Access queries directly, which should be neat. In other news, I've modified everything in the libmdb, sql, and util directories to compile with dmalloc and found and fixed some memory leaks. I've (barely) started prepping for doing i18n/l10n stuff, if you speak something other than english and want to localize for that language, speak up (pun intended). And, I'm still working on getting rid of the gcc -Wall warnings. Work not checked in includes an mdb-import utility to import CSV files to tables, which is currently limited to tables which have no indexes. Once, I get it sorted a bit more, that'll be hitting the tree. I'm on vacation starting sunday for a week, and will be incommunicato most of that time. Cheers, Brian |
|
From: Wagner M. <ne...@gm...> - 2003-01-29 12:07:17
|
Hi,
I tried both binary .deb-packages and self compiled version of mdbtools
(with sql-support) to grab some data out of an Access DB which consists
of 4 tables without any relations or keys. mdb-ver <DB> returns
"unkown", and every other mdb-* tool segfaults. I debugged it a bit and
the error seems to be on line 39 of data.c
Program received signal SIGSEGV, Segmentation fault.
0x40016a31 in mdb_bind_column (table=0x804ca68, col_num=1,
bind_ptr=0xbffff918) at data.c:39
39 col=g_ptr_array_index(table->columns, col_num - 1);
[...]
list
34 MdbColumn *col;
35
36 /*
37 ** the column arrary is 0 based, so decrement to get 1 based parameter
38 */
39 col=g_ptr_array_index(table->columns, col_num - 1);
40 col->bind_ptr = bind_ptr;
41 }
42 void mdb_bind_len(MdbTableDef *table, int col_num, int *len_ptr)
43 {
And if I inspect the table-pointer, it returns a null pointer (MdbTableDef *) 0x0
(explains the segfault ;)
Yet I am in a hurry and can't try to fix that on my own as it was a lot of work..
any ideas what's wrong?
mfg
Nec
|
26 messages has been excluded from this view by a project administrator.
