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: Mike P. <mj...@fi...> - 2005-02-16 22:04:30
|
Hi all, Just getting my head around mdb-tools, and I thought I'd throw this out in case it sparks an 'ah-ha' with someone more familiar with the code. In the nutshell, I've got a JET3 mdb which works fine querying via mdb-sql... however, using PHP and UnixODBC, I get a segfault running a select query that retrieves a memo field with more than 255 characters in it. I'm guessing that perhaps some part of the code is reporting a smaller size for this field than is being allocated, but at a cursory inspection, the whole mechanism for field lengths looks as if it needs more than a cursory inspection! The GDB backtrace doesn't help much as it's not in the mdb-tools code! (gdb) bt #0 0x081724e3 in zend_hash_find () #1 0x081791fd in zend_assign_to_variable_reference () #2 0x0817ddce in execute () #3 0x0816d9d9 in zend_execute_scripts () #4 0x0814522d in php_execute_script () #5 0x08180acf in main () I'll keep on digging, but if anyone has any ideas.... Fedora Core 2 PHP 4.3.10 Unix ODBC 2.2.8 CVS version of mdb-tools As an aside, I've also coded up queries for date comparisons in sargs.cm, and return of GUID fields and equality comparison - is this worth submitting in, or have other people been working on this ? |
From: <pa...@ti...> - 2005-02-16 09:34:27
|
Hi... I have been following the development of the MDBTools for some time n= ow and a coupele of months ago, the command-line tools started to mess u= p the output when you had accented characters. I.e. : mdb-sql /home/paag/BR4K/bdb4k.mdb 1 =3D> select * from directores where Apellidos like 'Previn' 2 =3D> go +-----------+--------------------------------------------------+-----= ---------------------------------------------+ |IdDirector |Apellidos =20 |Nombre | +-----------+--------------------------------------------------+-----= ---------------------------------------------+ |96 |Previn =20 |Andr=C3=A9 | +-----------+--------------------------------------------------+-----= ---------------------------------------------+ 1 Row retrieved The column 'Nombre' should show Andr=E9. Is there someone working on = this? Then, I'd also like to point out that mdb-sql is extremely interestin= g=20 for many quick prototyping applications, but only if it can be used as a coprocess. = For=20 that you need to add an fflush(stdout); after every fprintf(stdout,"\n"); I know it sounds tedious, but the application for this is really=20 _great_. I could provide a patch for adding this. Thanks for a great work... --=20 Pedro Andr=E9s Aranda Guti=E9rrez Telef=F3nica I+D IP Network Access Technologies Consultant mailto:pa...@ti... C./ Emilio Vargas, 6 Tlf +34-91 337 4702 E-28043 Madrid, Spain FAX +34-91 337 4502 Fragen sind nicht da, um beantwortet zu werden. Fragen sind da, um gestellt zu werden - Georg Kreisler |
From: Martin E. <m.a...@nc...> - 2005-02-11 20:39:17
|
On Friday 11 Feb 2005 19:46, michael geary wrote: > fink chokes on glib2 on my machine. It says it needs to install 17 > dependencies first, and then dies on the gmp package, long before > it gets to glib2... :c( > > I don't believe that gmp is _really_ needed for glib2. Any ideas on > how I can override fink's dependency mechanism? I'm guessing fink downloads packages to /sw/var/cache/apt/archives or something like that. You could dpkg -i --force-depends /sw/var/cache/apt/archives/*glib*deb but it's probably not a great long term solution because apt will be convinced it's broken. I guess it's probably better to just go with what fink, er, finks (sorry) and install the dependencies. What's the gmp error? It might be easier to fix that. Martin |
From: michael g. <lis...@ge...> - 2005-02-11 19:46:14
|
fink chokes on glib2 on my machine. It says it needs to install 17 dependencies first, and then dies on the gmp package, long before it gets to glib2... :c( I don't believe that gmp is _really_ needed for glib2. Any ideas on how I can override fink's dependency mechanism? thanks, michael geary On Feb 11, 2005, at 3:04 AM, Neil Tiffin wrote: > glib and glib2 both install fine using fink. > > http://fink.sourceforge.net/index.php > > Neil |
From: Brian B. <bri...@gm...> - 2005-02-11 16:23:31
|
Hi all, There was a change related to the java stuff (i think) with a "METHOD" define in mem.c. I couldn't get it to compile with it in there, although it might have been related to my automake problems too. Anyway, I commented them out, can someone tell me what they are supposed to do? Secondly, I checked in a couple of fixes to mdb-import and friends. mdb-export will now see an imported row, although Access itself still doesn't see it, but I think I know what that is. A long list of caveats still apply (only leaf pages support, single column fixed length keys, no compressed indexes) making it all but useless, but it's progress. Cheers, Brian |
From: Neil T. <nt...@ea...> - 2005-02-11 10:04:39
|
glib and glib2 both install fine using fink. http://fink.sourceforge.net/index.php Neil At 11:03 AM -0700 2/9/05, michael geary wrote: >well, i have problems getting glib 2.6.0 to make. These are my last few lines: > >ld: multiple definitions of symbol _libintl_textdomain >.libs/libglib-2.0.lax/libcharset.a/textdomain.o definition of >_libintl_textdomain in section (__TEXT,__text) >.libs/libglib-2.0.lax/libintl.a/textdomain.o definition of >_libintl_textdomain in section (__TEXT,__text) >/usr/lib/libiconv.dylib(localcharset.o) definition of _locale_charset >make[4]: *** [libglib-2.0.la] Error 1 >make[3]: *** [all-recursive] Error 1 >make[2]: *** [all] Error 2 >make[1]: *** [all-recursive] Error 1 >make: *** [all] Error 2 |
From: Jeff S. <why...@ya...> - 2005-02-10 06:38:03
|
--- Artur Frysiak <wi...@pl...> wrote: > Attached patch fix getting values of inlime memo fields. Thanks for the patch. You inspired me to fix another form of memo field as well. -- Jeff Smith __________________________________ Do you Yahoo!? Yahoo! Mail - Helps protect you from nasty viruses. http://promotions.yahoo.com/new_mail |
From: Jeff S. <why...@ya...> - 2005-02-10 06:34:40
|
--- David Mansfield <mdb...@dm...> wrote: > Wait... May has 31, it's JUNE that has 30. Ouch, my birthday is in May even... Now fixed in CVS. -- Jeff Smith __________________________________ Do you Yahoo!? Yahoo! Mail - now with 250MB free storage. Learn more. http://info.mail.yahoo.com/mail_250 |
From: michael g. <lis...@ge...> - 2005-02-09 18:04:01
|
well, i have problems getting glib 2.6.0 to make. These are my last few lines: ld: multiple definitions of symbol _libintl_textdomain .libs/libglib-2.0.lax/libcharset.a/textdomain.o definition of _libintl_textdomain in section (__TEXT,__text) .libs/libglib-2.0.lax/libintl.a/textdomain.o definition of _libintl_textdomain in section (__TEXT,__text) /usr/lib/libiconv.dylib(localcharset.o) definition of _locale_charset make[4]: *** [libglib-2.0.la] Error 1 make[3]: *** [all-recursive] Error 1 make[2]: *** [all] Error 2 make[1]: *** [all-recursive] Error 1 make: *** [all] Error 2 However, as this isn't a glib list, I don't presume to get support on this here (though of course I wouldn't reject it!). I'll try to get glib installed, and try again with mdbtools. michael geary On Feb 9, 2005, at 10:28 AM, Martin Ellis wrote: > On Wednesday 09 Feb 2005 16:54, michael geary wrote: >> I've been trying to get mdbtools to compile on OS X. I don't have >> GTK installed, but all I really want are the command-line tools. Is >> there a way to configure/make in such a way that I don't need GTK? > > I do this, but not on a Mac > > You'll need the glib development stuff, but shouldn't need the gtk > stuff. > Configure should just whinge a bit because gtk's not there, but it > should compile everything else. > > Where exactly do things go wrong? > > Martin |
From: Martin E. <m.a...@nc...> - 2005-02-09 17:29:24
|
On Wednesday 09 Feb 2005 16:54, michael geary wrote: > I've been trying to get mdbtools to compile on OS X. I don't have > GTK installed, but all I really want are the command-line tools. Is > there a way to configure/make in such a way that I don't need GTK? I do this, but not on a Mac You'll need the glib development stuff, but shouldn't need the gtk stuff. Configure should just whinge a bit because gtk's not there, but it should compile everything else. Where exactly do things go wrong? Martin |
From: Sam M. <pa...@gm...> - 2005-02-09 17:15:56
|
Thats a sourceforge issue. ( 2005-02-09 08:58:54 - Project CVS Service ) As of 2005-02-09 there is an outage of anonymous CVS (tarballs, pserver-based CVS and ViewCVS) for projects whose UNIX names start with the letters m, n, p, q, t, y and z. We are currently working on resolving this issue. (https://sourceforge.net/docman/display_doc.php?group_id=1&docid=2352#1107968334) It should be back online ASAP, keep your eyes on that page and it'll tell you when. On Wed, 9 Feb 2005 09:54:03 -0700, michael geary <lis...@ge...> wrote: > Hi Folks, > > I've been trying to get mdbtools to compile on OS X. I don't have GTK > installed, but all I really want are the command-line tools. Is there a > way to configure/make in such a way that I don't need GTK? > > Also, I can't access the CVS source. Neil T. posted recently that the > CVS version compiles on OS X, but I can't check it out. When I try: > > cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools > login > > I get a timeout error. > > help...? Thanks! > > michael geary > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
From: michael g. <lis...@ge...> - 2005-02-09 16:54:13
|
Hi Folks, I've been trying to get mdbtools to compile on OS X. I don't have GTK installed, but all I really want are the command-line tools. Is there a way to configure/make in such a way that I don't need GTK? Also, I can't access the CVS source. Neil T. posted recently that the CVS version compiles on OS X, but I can't check it out. When I try: cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools login I get a timeout error. help...? Thanks! michael geary |
From: Artur F. <wi...@pl...> - 2005-02-07 17:14:37
|
Hello Attached patch fix getting values of inlime memo fields. Regards -- Artur Frysiak http://www.pld-linux.org/ |
From: David M. <mdb...@dm...> - 2005-02-06 21:53:40
|
Wait... May has 31, it's JUNE that has 30. (sorry about the word wrap in the patch. You get the idea: change 150 to 151 for non-leap change 151 to 152 for leap.) Hence: --- data.c.orig 2005-02-06 16:50:25.000000000 -0500 +++ data.c 2005-02-06 16:50:28.000000000 -0500 @@ -707,8 +707,8 @@ long int day, time; int yr, q; int *cal; - int noleap_cal[] = {0,31,59,90,120,150,181,212,243,273,304,334,365}; - int leap_cal[] = {0,31,60,91,121,151,182,213,244,274,305,335,366}; + int noleap_cal[] = {0,31,59,90,120,151,181,212,243,273,304,334,365}; + int leap_cal[] = {0,31,60,91,121,152,182,213,244,274,305,335,366}; switch (datatype) { case MDB_BOOL: David |
From: David M. <mdb...@dm...> - 2005-02-06 20:26:35
|
Hi Brian, list, I've been using an in-house heavily patched version of 0.5 for a long time now, and finally decided to try to update to the latest CVS, because you guys have made a lot of great progress. Many things are greatly improved over the old 0.5 version. I found a small bug that actually traces back to a mis-merge of some patches I sent you a year ago! The issue is the the structure for a table, num_rows contains a total count of rows in the table (actually, only counts non-deleted rows). However, the method mdb_read_row takes a row number relative to the block only. The bug occurs when you have a table with a small number of rows, all in one block, but with a bunch of deleted rows. In my case there are 33 total non-deleted rows (table->num_rows == 33). There are 44 rows in the first block, and 3 in the second. Doing the math, there are 14 deleted rows. However, the check in mdb_read_row: if (table->num_rows <= row) return 0; in mdb_read_row causes the routine to skip row indexes 33 -> 44 in the first data block. Looking back at my source (0.5 plus patches) the code reads: if (table->num_rows == 0) return 0; which is what it had been for years before that, and I think is still valid as an optimization. Changing the code back makes it work for me again. This may be white-space mangled due to cut and paste. =================================================================== RCS file: /cvsroot/mdbtools/mdbtools/src/libmdb/data.c,v retrieving revision 1.87 diff -u -r1.87 data.c --- src/libmdb/data.c 15 Jan 2005 05:02:08 -0000 1.87 +++ src/libmdb/data.c 6 Feb 2005 20:16:21 -0000 @@ -229,7 +229,7 @@ MdbField fields[256]; int num_fields; - if (table->num_rows <= row) + if (table->num_rows == 0) return 0; row_start = mdb_pg_get_int16(mdb, (fmt->row_count_offset + 2) + (row*2)); |
From: Jeff S. <why...@ya...> - 2005-02-04 04:02:40
|
--- Mindaugas Kirsanskas <Min...@ha...> wrote: > data in mysql database differ from ms access, particulary Date/Time > fields (format in access db - General Date). During replication process What is the replication process you are using? > almost half of data was damaged (Date/Time was short by one second), and > there is no rule which data damaged. This is really serious problem to I believe this is a rounding problem that I (hopefully) fixed several weeks ago in CVS. > Tried to select data via mdb-sql to make sure this is mdbtools problem > and this is what I got: > 1 => select * from IVR_Calls_NoDet where Start_Date < '01/02/04 00:00:00'; > 2 => go > Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() for > type 8 > ( my data .... ) > Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() for > type 8 > ... > ... mdbtools does not yet handle comparison operations on dates. -- Jeff Smith __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com |
From: Tony T. <to...@gr...> - 2005-02-03 05:10:08
|
At 12:39 PM 02-03-2005 +1000, you wrote: >I've experienced issues myself with corrupt db's returning errors - >loading them up into to Access and repairing them seems to fix most >cases. FWIW the only real way to ensure Access MDBs are free from corruption is to also import them into a new MDB. Just repairing isn't always sufficient as minor corruptions can still exist and thus grow in major corruptions. This is according to Peter Miller of PK Solutions who retrieves data from corrupt MDBs. >Based on the Page Usage Maps section of the HACKING document, >there is a theoretical limit of about 1GB for Jet3 and 2GB for >Jet4. I have not worked with any files of that size, so I do >not have any first-hand experience. This is correct. There's a misleading error that occurs once the MDB gets too large. I forget the exact text though. Tony ----- Tony Toews, Microsoft Access MVP Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm |
From: Jeff S. <why...@ya...> - 2005-02-03 04:09:53
|
--- William Maddler <ne...@ma...> wrote: > is there any reported problem in working with >1GB .mdb files? > I have no problems working with small files. > I made some testing with ~10MB files and I was able to list tables, > export structures and data. > Larger files are "ignored", no tables listed, no data extracted. > > I tried 0.6pre1 on a Slackware 10.1 box. > > Any clue? Based on the Page Usage Maps section of the HACKING document, there is a theoretical limit of about 1GB for Jet3 and 2GB for Jet4. I have not worked with any files of that size, so I do not have any first-hand experience. In checking the Changelog, I made a few changes/bugfixes back in August 2004 that might affect this, so you might see if it works better (or worse) with the CVS version of mdbtools. -- Jeff Smith __________________________________ Do you Yahoo!? Yahoo! Mail - You care about security. So do we. http://promotions.yahoo.com/new_mail |
From: Sam M. <pa...@gm...> - 2005-02-03 02:39:35
|
I've experienced issues myself with corrupt db's returning errors - loading them up into to Access and repairing them seems to fix most cases. On Thu, 3 Feb 2005 11:57:11 +1100, Matthew Palmer <mp...@he...> wrote: > On Wed, Feb 02, 2005 at 08:29:03PM +0100, William Maddler wrote: > > is there any reported problem in working with >1GB .mdb files? > > I have no problems working with small files. > > I made some testing with ~10MB files and I was able to list tables, > > export structures and data. > > Larger files are "ignored", no tables listed, no data extracted. > > > > Any clue? > > I'm not an mdbtools hacker, but I don't know of any limitations on larger > files (and 1GB seems like an odd place to stick a limitation), but in my > experience mdbtools is less forgiving of MDB corruption than Jet is, and > larger files do like to get corrupted far more than small files do. I have > observed corrupted MDB files which don't list any available tables, as well > as a wide variety of other f**ked up symptoms. > > I'd run a complete repair/cleanup over the big files before going too far > down the path of looking for size-limit bugs in mdbtools. > > - Matt > > > |
From: Matthew P. <mp...@he...> - 2005-02-03 00:57:23
|
On Wed, Feb 02, 2005 at 08:29:03PM +0100, William Maddler wrote: > is there any reported problem in working with >1GB .mdb files? > I have no problems working with small files. > I made some testing with ~10MB files and I was able to list tables, > export structures and data. > Larger files are "ignored", no tables listed, no data extracted. >=20 > Any clue? I'm not an mdbtools hacker, but I don't know of any limitations on larger files (and 1GB seems like an odd place to stick a limitation), but in my experience mdbtools is less forgiving of MDB corruption than Jet is, and larger files do like to get corrupted far more than small files do. I have observed corrupted MDB files which don't list any available tables, as well as a wide variety of other f**ked up symptoms. I'd run a complete repair/cleanup over the big files before going too far down the path of looking for size-limit bugs in mdbtools. - Matt |
From: William M. <ne...@ma...> - 2005-02-02 19:29:27
|
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi all, is there any reported problem in working with >1GB .mdb files? I have no problems working with small files. I made some testing with ~10MB files and I was able to list tables, export structures and data. Larger files are "ignored", no tables listed, no data extracted. I tried 0.6pre1 on a Slackware 10.1 box. Any clue? Thx -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCASn+1ALxG2OcY+8RAiHVAJ44NCBcGrr1uuneHoleowbScuqcVwCffk8M EwCpJl12tU1OHgKS3biLngE= =pq3M -----END PGP SIGNATURE----- |
From: Jeff S. <why...@ya...> - 2005-02-02 14:06:59
|
--- Jon Manning <des...@gm...> wrote: > Is there any ability in mdb-tools that allows for the extraction of > queries and forms? If not, is there any development being done on it? Jon, There is a patch submitted by Lenny LeBlanc (IIRC) for extracting queries, which I plan to review and commit as soon as I get the time. I am not aware of any such thing for forms at this time. -- Jeff Smith __________________________________ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250 |
From: Jon M. <des...@gm...> - 2005-02-02 00:36:26
|
Hey guys, Is there any ability in mdb-tools that allows for the extraction of queries and forms? If not, is there any development being done on it? Thanks, Jon Manning |
From: Sam M. <pa...@gm...> - 2005-01-31 13:45:06
|
Considering this has only just hit the list afaik (well, my gmail account just popped up with it), as a simple solution just add a second on to the times when they come out. I can't personally see an issue with your SQL. Also, what version of mdb-tools are you using? On Thu, 27 Jan 2005 09:48:41 +0200, Mindaugas Kirsanskas <Min...@ha...> wrote: > =20 > =20 >=20 > Hello,=20 >=20 > =20 >=20 > I don't know if such situation was reported, but recently I noticed that > data in mysql database differ from ms access, particulary Date/Time field= s > (format in access db - General Date). During replication process almost h= alf > of data was damaged (Date/Time was short by one second), and there is no > rule which data damaged. This is really serious problem to me because whe= n > operating with huge databases it causes big differences in duration and s= o > on=E2=80=A6=20 >=20 > =20 >=20 > Tried to select data via mdb-sql to make sure this is mdbtools problem an= d > this is what I got:=20 >=20 > 1 =3D> select * from IVR_Calls_NoDet where Start_Date < '01/02/04 00:00:0= 0';=20 >=20 > 2 =3D> go=20 >=20 > Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() for t= ype > 8=20 >=20 > ( my data =E2=80=A6. )=20 >=20 > Calling mdb_test_sarg on unknown type. Add code to mdb_test_sarg() for t= ype > 8=20 >=20 > =E2=80=A6=20 >=20 > =E2=80=A6=20 >=20 > =20 >=20 > Where clause was ignored, and data from Date/Time fields was shorter in 1 > second.=20 >=20 > =20 >=20 > If it is not a bug so please explain what I am doing wrong. I tried vario= us > Date/Time formats, JET3 and JET4 engines but always get the same result.= =20 >=20 > =20 >=20 > It is really urgent to me, so please respond=20 >=20 > =20 >=20 > Thanks in advance |
From: Neil T. <nt...@ea...> - 2005-01-29 14:06:11
|
For anyone that is interested MDB seems to work fine with Apple OS X. Thanks for a great tool. If I can do anything else to help please let me know. I had to make the following changes to the cvs version checked out Jan 29, 2005 in order for MDB to compile on Apple OS X version 10.3.7. The command line tools all seem to work fine (have not done any extensive testing). I ran all tools from the build location and did not attempt to install them. Did not test the GUI version. All dependencies were installed using Fink. Filed as patch 1112035 Neil ne...@gn... ntiffin% cvs diff -uw cvs diff: Diffing . cvs diff: Diffing doc cvs diff: Diffing doc/reference cvs diff: Diffing doc/reference/libmdb cvs diff: Diffing include cvs diff: Diffing src cvs diff: Diffing src/extras cvs diff: Diffing src/gmdb cvs diff: Diffing src/gmdb2 Index: src/gmdb2/debug.c =================================================================== RCS file: /cvsroot/mdbtools/mdbtools/src/gmdb2/debug.c,v retrieving revision 1.18 diff -u -w -r1.18 debug.c --- src/gmdb2/debug.c 15 Jan 2005 05:02:12 -0000 1.18 +++ src/gmdb2/debug.c 29 Jan 2005 13:33:07 -0000 @@ -38,7 +38,8 @@ static guint32 get_uint32(unsigned char *c); static long gmdb_get_max_page(MdbHandle *mdb); static void gmdb_debug_display(GladeXML *xml, guint32 page); -static void gmdb_debug_jump(GtkWidget *w, GladeXML *xml, int msb); +/* static void gmdb_debug_jump(GtkWidget *w, GladeXML *xml, int msb); */ +static void gmdb_debug_jump(GladeXML *xml, int msb); /* value to string stuff */ typedef struct GMdbValStr { cvs diff: Diffing src/gmdb2/gladefiles cvs diff: Diffing src/gmdb2/help cvs diff: Diffing src/gmdb2/help/C cvs diff: Diffing src/gmdb2/help/C/figures cvs diff: Diffing src/gmdb2/pixmaps cvs diff: Diffing src/libmdb Index: src/libmdb/mem.c =================================================================== RCS file: /cvsroot/mdbtools/mdbtools/src/libmdb/mem.c,v retrieving revision 1.36 diff -u -w -r1.36 mem.c --- src/libmdb/mem.c 15 Jan 2005 05:02:08 -0000 1.36 +++ src/libmdb/mem.c 29 Jan 2005 13:33:07 -0000 @@ -26,6 +26,9 @@ #include "dmalloc.h" #endif #endif /* JAVA */ + +#define METHOD + /** * mdb_init: * cvs diff: Diffing src/odbc cvs diff: Diffing src/sql cvs diff: Diffing src/util |