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: <br...@br...> - 2004-06-17 18:27:10
|
No UTF-8 in this release, however it may show up in a later 0.6-pre release. Hardly anyone has asked about it, so it wasn't high on my list. I may try to sneak it into the -pre2 release now that I know someone is actively interested. There are a couple big issues. 1) We don't know how to tell what codeset the database file is encoded in. This is not a problem for Jet4 since everything is UCS-2 LE. 2) iconv introduces a new dependency which needs to be looked for in configure, and my track record on confgure.in changes isn't exactly great so I don't want to do it right before release. The actual code is fairly simple to implement (I did the same thing with FreeTDS a few years back). Brian On Thu, 17 Jun 2004 14:23:36 -0300, Luciano Miguel Wolf wrote: > > Hi Brian, > > Will this release have UTF-8 support? > > Thanks, > Luciano > > On Wed, 2004-06-16 at 19:38, br...@br... wrote: > > David, > > > > I checked this change in this evening. I can't imagine anyone typing > > in a table name longer than 256 even if it is allowed ;-) > > > > I'm shooting for a 0.6pre1 release this weekend unless I hear any > > objections. This will simply be a base line from which to get a > > handle on outstanding issues and branch the tree, so we can stabilize > > it for the real deal. After that, only bug fixes and such will be > > going in. > > > > The hard part is going to be ensuring that fixes get applied to both > > branches. > > > > Brian > > > > On Wed, 16 Jun 2004 14:45:45 -0400, David Mansfield wrote: > > > > > It's cool. I didn't mean anything by it. By the way, the latest > > > 'catch' was that table names can apparently be quite a bit longer > > than > > > 30 characters. I changed it to 50, but probably 256 is more > > accurate. > > > Maybe something like: > > > > > > -#define MDB_MAX_OBJ_NAME 30 > > > +#define MDB_MAX_OBJ_NAME 256 > > > > > > Maybe there's a spec somewhere that says what the maximum object > name > > > length is. > > > > > > David > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference > > Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer > > Conference, June 28 - July 1 at the Moscone Center in San Francisco, > CA > > REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code > NWMGYKND > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > > > ------------------------------------------------------- > This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference > Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer > Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA > REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code > NWMGYKND > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev |
|
From: Luciano M. W. <lu...@fs...> - 2004-06-17 17:24:04
|
Hi Brian, Will this release have UTF-8 support? Thanks, Luciano On Wed, 2004-06-16 at 19:38, br...@br... wrote: > David, > > I checked this change in this evening. I can't imagine anyone typing > in a table name longer than 256 even if it is allowed ;-) > > I'm shooting for a 0.6pre1 release this weekend unless I hear any > objections. This will simply be a base line from which to get a > handle on outstanding issues and branch the tree, so we can stabilize > it for the real deal. After that, only bug fixes and such will be > going in. > > The hard part is going to be ensuring that fixes get applied to both > branches. > > Brian > > On Wed, 16 Jun 2004 14:45:45 -0400, David Mansfield wrote: > > > It's cool. I didn't mean anything by it. By the way, the latest > > 'catch' was that table names can apparently be quite a bit longer > than > > 30 characters. I changed it to 50, but probably 256 is more > accurate. > > Maybe something like: > > > > -#define MDB_MAX_OBJ_NAME 30 > > +#define MDB_MAX_OBJ_NAME 256 > > > > Maybe there's a spec somewhere that says what the maximum object name > > length is. > > > > David > > > ------------------------------------------------------- > This SF.Net email is sponsored by The 2004 JavaOne(SM) Conference > Learn from the experts at JavaOne(SM), Sun's Worldwide Java Developer > Conference, June 28 - July 1 at the Moscone Center in San Francisco, CA > REGISTER AND SAVE! http://java.sun.com/javaone/sf Priority Code NWMGYKND > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
|
From: Calvin S. <cal...@ho...> - 2004-06-17 00:12:45
|
Thanks Brian!! All the latest code for the java port is now in cvs. I'll keep this updated as I build the jdbc driver Calvin ----Original Message Follows---- Calvin, I granted you CVS commits, which I think will give you the ability to do what you need. If not, somebody please tell me what else is needed. I'm not setting up cvs_acls or anything, so be careful. How about mdbtools-java or just mdbtools-j for a module name (thus extending nicely if we add other languages (or bindings) down the road)? Brian On Fri, 11 Jun 2004 17:56:05 -0500, "Calvin Smith" wrote: > > Instead of a creating a separate cvs repository why not just create a > new > module inside of the repository you have now? > Right now the module to checkout is: mdbtools > If you create a new module: java-mdbtools then you can checkout > whichever > module you want and only get java or only get c > > > ----Original Message Follows---- > I would like to create a separate cvs repository, so the java folks > don't have to download the C stuff and vice versa. Unfortunately, > looking at sourceforge, I'm having difficulty seeing how that is done. > Still looking. > > Brian > > On Fri, 11 Jun 2004 11:29:49 -0700 (PDT), Jeff Smith wrote: > > &gt; > &gt; --- Calvin Smith &lt;cal...@ho...&gt; wrote: > &gt; &gt; P.S. > &gt; &gt; How's anyone coming on allowing me to check in the java > port? > &gt; > &gt; As Brian Bruns is the project leader, I think he will have be the > one > &gt; to > &gt; make that call. > &gt; > &gt; -- Jeff Smith > &gt; > &gt; > &gt; > &gt; > &gt; > &gt; __________________________________ > &gt; Do you Yahoo!? > &gt; Friends. Fun. Try the all-new Yahoo! Messenger. > &gt; http://messenger.yahoo.com/ > &gt; > &gt; > &gt; ------------------------------------------------------- > &gt; This SF.Net email is sponsored by the new InstallShield X. > &gt; From Windows to Linux, servers to mobile, InstallShield X is the > &gt; one installation-authoring solution that does it all. Learn more > and > &gt; evaluate today! http://www.installshield.com/Dev2Dev/0504 > &gt; _______________________________________________ > &gt; mdbtools-dev mailing list > &gt; mdb...@li... > &gt; https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > ------------------------------------------------------- > This SF.Net email is sponsored by the new InstallShield X. > From Windows to Linux, servers to mobile, InstallShield X is the > one installation-authoring solution that does it all. Learn more and > evaluate today! http://www.installshield.com/Dev2Dev/0504 > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > _________________________________________________________________ > Get fast, reliable Internet access with MSN 9 Dial-up now 3 months > FREE! > http://join.msn.click-url.com/go/onm00200361ave/direct/01/ _________________________________________________________________ Get fast, reliable Internet access with MSN 9 Dial-up now 3 months FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/ |
|
From: <br...@br...> - 2004-06-16 22:48:06
|
Calvin, I granted you CVS commits, which I think will give you the ability to do what you need. If not, somebody please tell me what else is needed. I'm not setting up cvs_acls or anything, so be careful.=20=20 How about mdbtools-java or just mdbtools-j for a module name (thus extending nicely if we add other languages (or bindings) down the road)? Brian On Fri, 11 Jun 2004 17:56:05 -0500, "Calvin Smith" wrote: >=20 > Instead of a creating a separate cvs repository why not just create a > new=20 > module inside of the repository you have now? > Right now the module to checkout is: mdbtools > If you create a new module: java-mdbtools then you can checkout > whichever=20 > module you want and only get java or only get c >=20 >=20 > ----Original Message Follows---- > I would like to create a separate cvs repository, so the java folks > don't have to download the C stuff and vice versa. Unfortunately, > looking at sourceforge, I'm having difficulty seeing how that is done. > Still looking. >=20 > Brian >=20 > On Fri, 11 Jun 2004 11:29:49 -0700 (PDT), Jeff Smith wrote: >=20 > > > > --- Calvin Smith <cal...@ho...> wrote: > > > P.S. > > > How's anyone coming on allowing me to check in the java > port? > > > > As Brian Bruns is the project leader, I think he will have be the > one > > to > > make that call. > > > > -- Jeff Smith > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Friends. Fun. Try the all-new Yahoo! Messenger. > > http://messenger.yahoo.com/ > > > > > > ------------------------------------------------------- > > This SF.Net email is sponsored by the new InstallShield X. > > From Windows to Linux, servers to mobile, InstallShield X is the > > one installation-authoring solution that does it all. Learn more > and > > evaluate today! http://www.installshield.com/Dev2Dev/0504 > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev >=20 >=20 > ------------------------------------------------------- > This SF.Net email is sponsored by the new InstallShield X. > From Windows to Linux, servers to mobile, InstallShield X is the > one installation-authoring solution that does it all. Learn more and > evaluate today! http://www.installshield.com/Dev2Dev/0504 > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev >=20 > _________________________________________________________________ > Get fast, reliable Internet access with MSN 9 Dial-up =96 now 3 months > FREE!=20 > http://join.msn.click-url.com/go/onm00200361ave/direct/01/ |
|
From: <br...@br...> - 2004-06-16 22:38:46
|
David, I checked this change in this evening. I can't imagine anyone typing in a table name longer than 256 even if it is allowed ;-) I'm shooting for a 0.6pre1 release this weekend unless I hear any objections. This will simply be a base line from which to get a handle on outstanding issues and branch the tree, so we can stabilize it for the real deal. After that, only bug fixes and such will be going in. The hard part is going to be ensuring that fixes get applied to both branches. Brian On Wed, 16 Jun 2004 14:45:45 -0400, David Mansfield wrote: > It's cool. I didn't mean anything by it. By the way, the latest > 'catch' was that table names can apparently be quite a bit longer than > 30 characters. I changed it to 50, but probably 256 is more accurate. > Maybe something like: > > -#define MDB_MAX_OBJ_NAME 30 > +#define MDB_MAX_OBJ_NAME 256 > > Maybe there's a spec somewhere that says what the maximum object name > length is. > > David |
|
From: David M. <mdb...@dm...> - 2004-06-16 18:45:55
|
On Wed, 2004-06-16 at 14:25, br...@br... wrote: > On Mon, 14 Jun 2004 15:35:24 -0400, David Mansfield wrote: > > > > On Mon, 2004-06-14 at 14:58, Matt Reynolds wrote: > > > On Sun, 2004-06-13 at 10:56, David Mansfield wrote: > > > > Try 0.5 (stock, not the debian version) plus attached patch (my > > combined > > > > patchset). It can read your file and export the data. > > > > > > > > I'm not sure why my patches to stabilize mdbtools were not > > included in > > > > later releases, but this combined patch contains 21 fixes to the > > 0.5 > > > > release, and I have no know issues anymore with extracting data. > > > > > David, > > I applied your patches to the CVS tree, but there have been no > releases since 0.5. > > I haven't had the time to work on things recently, so I'm consider > pushing the new stuff back into 0.7 or later and stablizing for a 0.6 > release with what is currently in CVS. > > After some kind of release is out, my plan is to branch and do point > releases for 0.6.x for bug fixes, along with the new development on > the HEAD tree. So, we shouldn't have this situation again where the > bug fixes are mixed in with the new stuff. > It's cool. I didn't mean anything by it. By the way, the latest 'catch' was that table names can apparently be quite a bit longer than 30 characters. I changed it to 50, but probably 256 is more accurate. Maybe something like: -#define MDB_MAX_OBJ_NAME 30 +#define MDB_MAX_OBJ_NAME 256 Maybe there's a spec somewhere that says what the maximum object name length is. David |
|
From: <br...@br...> - 2004-06-16 18:25:37
|
On Mon, 14 Jun 2004 15:35:24 -0400, David Mansfield wrote: > > On Mon, 2004-06-14 at 14:58, Matt Reynolds wrote: > > On Sun, 2004-06-13 at 10:56, David Mansfield wrote: > > > Try 0.5 (stock, not the debian version) plus attached patch (my > combined > > > patchset). It can read your file and export the data. > > > > > > I'm not sure why my patches to stabilize mdbtools were not > included in > > > later releases, but this combined patch contains 21 fixes to the > 0.5 > > > release, and I have no know issues anymore with extracting data. > > David, I applied your patches to the CVS tree, but there have been no releases since 0.5. I haven't had the time to work on things recently, so I'm consider pushing the new stuff back into 0.7 or later and stablizing for a 0.6 release with what is currently in CVS. After some kind of release is out, my plan is to branch and do point releases for 0.6.x for bug fixes, along with the new development on the HEAD tree. So, we shouldn't have this situation again where the bug fixes are mixed in with the new stuff. Cheers, Brian |
|
From: Robyn G. <ro...@oz...> - 2004-06-16 13:55:51
|
I am having trouble with where clause searching for text fields in Access 2000. Works fine for number fields as in "where numfield=123456" but for text fields "where textfield='abc' " does not work. Any clues? |
|
From: Fergus A. <f_W...@ya...> - 2004-06-15 22:22:42
|
As a design point, table names should only be case sensitive when delimited Thus: Select * from tbl_Neo Select * from TBL_NEO Are identical, but Select * from "tbl_Neo" Select * from "TBL_NEO" Are different. Example assumes double quote is the delimiter character. Regards Fergus Allan -----Original Message----- From: mdb...@li... [mailto:mdb...@li...] On Behalf Of David Mansfield Sent: 14 June 2004 22:06 To: Matt Reynolds Cc: MDB Tools List Subject: Re: [mdb-dev] Segfault when listing tables andproblemsexportingtables On Mon, 2004-06-14 at 16:06, Matt Reynolds wrote: > On Mon, 2004-06-14 at 12:35, David Mansfield wrote: > > On Mon, 2004-06-14 at 14:58, Matt Reynolds wrote: > > /usr/local/mdbtools/bin/mdb-export 05260930_orlando.mdb \ > > QcpCdma1xActiveSetInfo_XXX > > > > Actually, I think I lied. This does work, but isn't the table I want to > dump. > > This command: > mdb-export 05260930_orlando.mdb \ QcpCDMA1xRadioLinkProtocolStats_XXX > > Still doesn't output anything. > > So, looking into it a bit more, I realized that mdb-tables isn't dumping > the table I'm interested in. It shows : > QcpCdma1xRevPwrCtrl_XXX_FltStats QcpCdma1xRadioLinkProtocolStats > QcpCdma1xRadioLinkProtocolStats_ QcpCdma1xRadioLinkProtocolStats_ > QcpCdma1xRadioLinkProtocolStats_ > > Those last three tables are supposed to be : > QcpCdma1xRadioLinkProtocolStats_XXX > QcpCdma1xRadioLinkProtocolStats_XXX_IntBest > QcpCdma1xRadioLinkProtocolStats_XXX_UI4$I2 > > I think that's why I can't dump them. Any idea why these tables aren't > being dumped? Hmm. You're right. There's something really funky going on. If you look closely at the output of mdb-tables, or mdb-schema, there are some 'unprintable' characters being generated as part of the table name for some tables, including these. So the table name is not being extracted correctly. That's probably a bug somewhere... Possibly in the unicode string extraction or something. Let's see... Ok. It seems as though the 'hardcoded' max object name length of 30 is screwing you up. If we hardcode it to 50 it works. (begs a different question but....). So try the attached patch on top of the combined patch and it seems to work. NOTE: the table names ARE case sensitive, so be sure to use mdb-tables to get the exact name, then cut-and-paste for mdb-export. David |
|
From: leonardo c. <le...@li...> - 2004-06-15 20:31:44
|
Hi Fabiano, I've been able to use mdbtools even if I don't remember exactly how. I had some troubles due to sql queries that freezed the application (but i = had=20 a maxi database). I promise you I will take a look and told you how. The system where I=20 installed them are SuSE 9.0 and Mandrake 9.2. =46inally I used a commercial solution (ODBC bridge by OpenLink) but I thin= k=20 mdbtools are good (not great) for little dbs. I remember,the difficulties were just the config files . Best regards,=20 Leonardo Alle 15:56, luned=EC 14 giugno 2004, Fabiano Martins ha scritto: > Hi.. > > I installed the MDB tools. When I take a look at the documentation, I saw > that I must set some things in odbc.ini file such as "Driver =3D > /usr/local/lib/libmdbodbc.so". > > So I did that but aparently I couldn't access the data base. I was look f= or > the error and found that I didn't have libmdbodbc.so in any directory of > the system... So I assume the file is missing... > > I would like to know if I need to install other packages to get it. > > I already installed the follwing packages: > > mdbtools-0.5-1.i386.rpm > MLDBM-Sync-0.30.tar.gz > MLDBM-2.01.tar.gz > > (and all dependences for these) > > Any help will be welcome... > > Regards > > Fabiano |
|
From: Fabiano M. <fma...@ao...> - 2004-06-15 07:33:19
|
Hi.. I installed the MDB tools. When I take a look at the documentation, I saw th= at I must set some things in odbc.ini file such as "Driver =3D /usr/local/li= b/libmdbodbc.so". So I did that but aparently I couldn't access the data base. I was look for=20= the error and found that I didn't have libmdbodbc.so in any directory of the= system... So I assume the file is missing... I would like to know if I need to install other packages to get it. I already installed the follwing packages: mdbtools-0.5-1.i386.rpm MLDBM-Sync-0.30.tar.gz MLDBM-2.01.tar.gz (and all dependences for these) Any help will be welcome... Regards Fabiano |
|
From: Jon D. <dix...@ly...> - 2004-06-15 03:09:27
|
I have now tried the [], (), //, and \\ as delimiters to quote the table name, but none of them have been effective. Any other things I should look at? Jon --- Jon Dixon dix...@ly... http://dixonjon.tripod.com/ --------- Original Message --------- >MS Access uses "[" and "]" to quote things. I haven't tried this, but >maybe mdbtools does too. ____________________________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10 |
|
From: Matt R. <mre...@te...> - 2004-06-14 21:23:17
|
On Mon, 2004-06-14 at 14:06, David Mansfield wrote: > Hmm. You're right. There's something really funky going on. If you > look closely at the output of mdb-tables, or mdb-schema, there are some > 'unprintable' characters being generated as part of the table name for > some tables, including these. >=20 > So the table name is not being extracted correctly. That's probably a > bug somewhere... Possibly in the unicode string extraction or > something. >=20 > Let's see... Ok. It seems as though the 'hardcoded' max object name > length of 30 is screwing you up. If we hardcode it to 50 it works.=20 > (begs a different question but....). So try the attached patch on top > of the combined patch and it seems to work. >=20 > NOTE: the table names ARE case sensitive, so be sure to use mdb-tables > to get the exact name, then cut-and-paste for mdb-export. This works! Thank you. I'm now getting all the relevant data out of those tables. I did double-check the case-sensitivity. Any reason the tables are case sensitive? I thought MS didn't require that. Seems like it'd be "nice" to have :) Thank you again. --=20 Matt Reynolds <mre...@te...> |
|
From: David M. <da...@co...> - 2004-06-14 21:06:17
|
On Mon, 2004-06-14 at 16:06, Matt Reynolds wrote: > On Mon, 2004-06-14 at 12:35, David Mansfield wrote: > > On Mon, 2004-06-14 at 14:58, Matt Reynolds wrote: > > /usr/local/mdbtools/bin/mdb-export 05260930_orlando.mdb \ > > QcpCdma1xActiveSetInfo_XXX > > > > Actually, I think I lied. This does work, but isn't the table I want to > dump. > > This command: > mdb-export 05260930_orlando.mdb \ QcpCDMA1xRadioLinkProtocolStats_XXX > > Still doesn't output anything. > > So, looking into it a bit more, I realized that mdb-tables isn't dumping > the table I'm interested in. It shows : > QcpCdma1xRevPwrCtrl_XXX_FltStats QcpCdma1xRadioLinkProtocolStats > QcpCdma1xRadioLinkProtocolStats_ QcpCdma1xRadioLinkProtocolStats_ > QcpCdma1xRadioLinkProtocolStats_ > > Those last three tables are supposed to be : > QcpCdma1xRadioLinkProtocolStats_XXX > QcpCdma1xRadioLinkProtocolStats_XXX_IntBest > QcpCdma1xRadioLinkProtocolStats_XXX_UI4$I2 > > I think that's why I can't dump them. Any idea why these tables aren't > being dumped? Hmm. You're right. There's something really funky going on. If you look closely at the output of mdb-tables, or mdb-schema, there are some 'unprintable' characters being generated as part of the table name for some tables, including these. So the table name is not being extracted correctly. That's probably a bug somewhere... Possibly in the unicode string extraction or something. Let's see... Ok. It seems as though the 'hardcoded' max object name length of 30 is screwing you up. If we hardcode it to 50 it works. (begs a different question but....). So try the attached patch on top of the combined patch and it seems to work. NOTE: the table names ARE case sensitive, so be sure to use mdb-tables to get the exact name, then cut-and-paste for mdb-export. David |
|
From: Matt R. <mre...@te...> - 2004-06-14 20:06:33
|
On Mon, 2004-06-14 at 12:35, David Mansfield wrote: > On Mon, 2004-06-14 at 14:58, Matt Reynolds wrote: > /usr/local/mdbtools/bin/mdb-export 05260930_orlando.mdb \ > QcpCdma1xActiveSetInfo_XXX >=20 Actually, I think I lied. This does work, but isn't the table I want to dump. This command: mdb-export 05260930_orlando.mdb \ QcpCDMA1xRadioLinkProtocolStats_XXX Still doesn't output anything. So, looking into it a bit more, I realized that mdb-tables isn't dumping the table I'm interested in. It shows : QcpCdma1xRevPwrCtrl_XXX_FltStats QcpCdma1xRadioLinkProtocolStats QcpCdma1xRadioLinkProtocolStats_ QcpCdma1xRadioLinkProtocolStats_ QcpCdma1xRadioLinkProtocolStats_ Those last three tables are supposed to be : QcpCdma1xRadioLinkProtocolStats_XXX QcpCdma1xRadioLinkProtocolStats_XXX_IntBest QcpCdma1xRadioLinkProtocolStats_XXX_UI4$I2 I think that's why I can't dump them. Any idea why these tables aren't being dumped? --=20 Matt Reynolds <mre...@te...> |
|
From: Matt R. <mre...@te...> - 2004-06-14 19:55:16
|
On Mon, 2004-06-14 at 12:35, David Mansfield wrote: > I don't know. I just tried and got everything working with these exact > commands on a Fedora Core 2 system. I developed the patches on Red Hat > 9 and have deployed successfully on Red Hat 7.2 and 7.3 and RHEL 3 as > well. Not sure what your exact problem is. Can you try this exactly: >=20 > (assumes patch in ~/patches, and your mdb file in ~) >=20 > mkdir tmp=20 > cd tmp=20 > wget http://download.sourceforge.net/mdbtools/mdbtools-0.5.tar.gz > tar xvzf mdbtools-0.5.tar.gz=20 > cd mdbtools-0.5=20 > patch -p1 <~/patches/mdbtools-combined.patch=20 > ./configure --prefix=3D/usr/local/mdbtools=20 > make=20 > make install=20 > /usr/local/mdbtools/bin/mdb-schema ~/05260930_orlando.mdb > /usr/local/mdbtools/bin/mdb-export 05260930_orlando.mdb \ > QcpCdma1xActiveSetInfo_XXX >=20 > Works for me. >=20 > Can you cut and paste the error if you still get it? >=20 > David I found it. When I ran configure, lex/bison weren't installed and configure didn't include them later. So yes, this runs fine now I think. --=20 Matt Reynolds <mre...@te...> |
|
From: David M. <da...@co...> - 2004-06-14 19:35:34
|
On Mon, 2004-06-14 at 14:58, Matt Reynolds wrote: > On Sun, 2004-06-13 at 10:56, David Mansfield wrote: > > Try 0.5 (stock, not the debian version) plus attached patch (my combined > > patchset). It can read your file and export the data. > > > > I'm not sure why my patches to stabilize mdbtools were not included in > > later releases, but this combined patch contains 21 fixes to the 0.5 > > release, and I have no know issues anymore with extracting data. > > Downloaded the 0.5 code from : > http://download.sourceforge.net/mdbtools/mdbtools-0.5.tar.gz > > Applied the patch and tried to build, getting the errors in the > associated make_output file. Am I missing a library? I don't know. I just tried and got everything working with these exact commands on a Fedora Core 2 system. I developed the patches on Red Hat 9 and have deployed successfully on Red Hat 7.2 and 7.3 and RHEL 3 as well. Not sure what your exact problem is. Can you try this exactly: (assumes patch in ~/patches, and your mdb file in ~) mkdir tmp cd tmp wget http://download.sourceforge.net/mdbtools/mdbtools-0.5.tar.gz tar xvzf mdbtools-0.5.tar.gz cd mdbtools-0.5 patch -p1 <~/patches/mdbtools-combined.patch ./configure --prefix=/usr/local/mdbtools make make install /usr/local/mdbtools/bin/mdb-schema ~/05260930_orlando.mdb /usr/local/mdbtools/bin/mdb-export 05260930_orlando.mdb \ QcpCdma1xActiveSetInfo_XXX Works for me. Can you cut and paste the error if you still get it? David |
|
From: Matt R. <mre...@te...> - 2004-06-14 18:58:28
|
On Sun, 2004-06-13 at 10:56, David Mansfield wrote: > Try 0.5 (stock, not the debian version) plus attached patch (my combined > patchset). It can read your file and export the data. > > I'm not sure why my patches to stabilize mdbtools were not included in > later releases, but this combined patch contains 21 fixes to the 0.5 > release, and I have no know issues anymore with extracting data. Downloaded the 0.5 code from : http://download.sourceforge.net/mdbtools/mdbtools-0.5.tar.gz Applied the patch and tried to build, getting the errors in the associated make_output file. Am I missing a library? -- Matt Reynolds <mre...@te...> |
|
From: Calvin S. <cal...@ho...> - 2004-06-14 18:34:56
|
Is there a timeframe for including your patches into cvs? or has the project discarded them for a reason that your addressing? I'm asking 'cause since their bug fixes they should be in the java port as well and it's easier to keep in synch if there is only a single master to synch with Calvin ----Original Message Follows---- > I'm running MDB Tools on Debian/Unstable. It appears I'm using version > 0.5. > > ii mdbtools 0.5.99-2 JET / MS Access database > (MDB) tools > > I'm having trouble dumping schema from this database : > http://dev.loopysoft.com/05260930_orlando.mdb.bz2 > > QcpCDMA1xRadioLinkProtocolStats_XXX Try 0.5 (stock, not the debian version) plus attached patch (my combined patchset). It can read your file and export the data. I'm not sure why my patches to stabilize mdbtools were not included in later releases, but this combined patch contains 21 fixes to the 0.5 release, and I have no know issues anymore with extracting data. David << mdbtools-combined.patch >> _________________________________________________________________ MSN 9 Dial-up Internet Access fights spam and pop-ups now 3 months FREE! http://join.msn.click-url.com/go/onm00200361ave/direct/01/ |
|
From: Matt R. <mre...@te...> - 2004-06-14 18:08:54
|
On Sun, 2004-06-13 at 10:56, David Mansfield wrote: > Try 0.5 (stock, not the debian version) plus attached patch (my combined > patchset). It can read your file and export the data. Excellent. I'll submit a bug against the Debian packages, including your patch, and probably a link to this email thread. Thank you :) > I'm not sure why my patches to stabilize mdbtools were not included in > later releases, but this combined patch contains 21 fixes to the 0.5 > release, and I have no know issues anymore with extracting data. Hopefully the bug should fix this. Debian maintainers sometimes only track major releases, and then only fix bugs when asked by users. So I'll ask. Thanks again. PS: I'm subscribed to the list, no need to CC me. --=20 Matt Reynolds <mre...@te...> |
|
From: Matt R. <mre...@te...> - 2004-06-14 18:07:04
|
On Mon, 2004-06-14 at 02:01, Michael Wood wrote: > The CVS server was originally cvs.mdbtools.sourceforge.net, but is now > apparently cvs.sourceforge.net. Make sure you're using the right server > name. I think the cvs.mdbtools.sf.net is a cname for cvs.sf.net. As it turns out, it was just a bit of network downtime. > For access to CVS via pserver, "cvs login" only adds a line to your > ~/.cvspass file. If you have the correct server, but "cvs login" > doesn't work, just add the following line to your ~/.cvspass file and > try a checkout. (Of course if the login failed, the checkout probably > will too...): <snip> Thanks, yeah, I ended up doing this manually. BTW, I'm subscribed to the list, no need to CC me on mail. --=20 Matt Reynolds <mre...@te...> |
|
From: Michael W. <mw...@ic...> - 2004-06-14 09:07:00
|
On Sun, Jun 13, 2004 at 09:39:49PM -0400, Jon Dixon wrote: > I have a database I need to access that has hyphens in the middle of > some of the table names, ie Members-Personal. If I try: > SELECT * FROM Members-Personal > I get parse error at the '-' (not unexpected). > However, if I try quoting the table name with single quotes I get > parse error near 'Members-Personal'. > (SELECT * FROM 'Members-Personal') > It also fails to work with double quotes. > > This occurs both using gmdb2 and with mdb-sql. In both cases I can > get a list of the tables, including the hyphenated ones. In gmdb2 I > can even use the Data button under tables to view the data. But I > can't get a query to work. > > Is there something I'm overlooking here? MS Access uses "[" and "]" to quote things. I haven't tried this, but maybe mdbtools does too. -- Michael Wood <mw...@ic...> |
|
From: Michael W. <mw...@ic...> - 2004-06-14 09:02:06
|
On Fri, Jun 11, 2004 at 04:10:06PM -0700, Matt Reynolds wrote: > On Fri, 2004-06-11 at 14:46, br...@br... wrote: > > I would like to create a separate cvs repository, so the java folks > > don't have to download the C stuff and vice versa. Unfortunately, > > looking at sourceforge, I'm having difficulty seeing how that is done. > > Still looking. > > > > Brian > > AFAI remember, SF doesn't really let you create new reps, just new > modules in the reps. You could just create a new module called "java" > and have it grab just the folders you want? > > Also, I'm trying to download the repository from CVS, but I can't seem > to login (just never returning from login). Any ideas why that might > be? The CVS server was originally cvs.mdbtools.sourceforge.net, but is now apparently cvs.sourceforge.net. Make sure you're using the right server name. For access to CVS via pserver, "cvs login" only adds a line to your ~/.cvspass file. If you have the correct server, but "cvs login" doesn't work, just add the following line to your ~/.cvspass file and try a checkout. (Of course if the login failed, the checkout probably will too...): /1 :pserver:ano...@cv...:2401/cvsroot/mdbtools A The "A" is the encoded form of the null password. -- Michael Wood <mw...@ic...> |
|
From: Jon D. <dix...@ly...> - 2004-06-14 01:40:05
|
I have a database I need to access that has hyphens in the middle of some of the table names, ie Members-Personal. If I try: SELECT * FROM Members-Personal I get parse error at the '-' (not unexpected). However, if I try quoting the table name with single quotes I get parse error near 'Members-Personal'. (SELECT * FROM 'Members-Personal') It also fails to work with double quotes. This occurs both using gmdb2 and with mdb-sql. In both cases I can get a list of the tables, including the hyphenated ones. In gmdb2 I can even use the Data button under tables to view the data. But I can't get a query to work. Is there something I'm overlooking here? Jon --- Jon Dixon dix...@ly... http://dixonjon.tripod.com/ ____________________________________________________________ Find what you are looking for with the Lycos Yellow Pages http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.asp?SRC=lycos10 |
|
From: David M. <da...@co...> - 2004-06-13 17:56:26
|
> I'm running MDB Tools on Debian/Unstable. It appears I'm using version > 0.5. > > ii mdbtools 0.5.99-2 JET / MS Access database > (MDB) tools > > I'm having trouble dumping schema from this database : > http://dev.loopysoft.com/05260930_orlando.mdb.bz2 > > QcpCDMA1xRadioLinkProtocolStats_XXX Try 0.5 (stock, not the debian version) plus attached patch (my combined patchset). It can read your file and export the data. I'm not sure why my patches to stabilize mdbtools were not included in later releases, but this combined patch contains 21 fixes to the 0.5 release, and I have no know issues anymore with extracting data. David |
26 messages has been excluded from this view by a project administrator.
