mdbtools-dev

[mdb-dev] Possible bug: incorrectly returned Date/Time fields

[Mindaugas K. <Min...@ha...>]

Hello,
=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
fields (format in access db - General Date). During replication process
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
me because when operating with huge databases it causes big differences
in duration and so on...
=20
Tried to select data via mdb-sql to make sure this is mdbtools problem
and this is what I got:
1 =3D> select * from IVR_Calls_NoDet where Start_Date < '01/02/04
00:00:00';
2 =3D> 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
...
...
=20
Where clause was ignored, and data from Date/Time fields was shorter in
1 second.
=20
If it is not a bug so please explain what I am doing wrong. I tried
various Date/Time formats, JET3 and JET4 engines but always get the same
result.
=20
It is really urgent to me, so please respond
=20
Thanks in advance

[mdb-dev] current java port

[Calvin S. <cal...@ho...>]

>I need C++/QT support from mdbtools - so for obvious reasons, am keen
>to see how you intend to support more than one language.
Remember that mdbtools is not C++ and does not use QT
the gui portions are gtk, however I only need libmdb which contains no gui 
code

>Particularly I'd like to be able to avoid using the glib library, and
>to use bounds-checked array accesses.
I use defines to map glib calls to java
for example to create a hashtable in glib and populate it I can use:

#define g_hash_table_new(a,b) new Hashtable();
#define g_hash_table_insert(table,key,value) table.put(key,value)

which maps the calls to the java hashtable object.

You should be able to do something similar to map the glib calls to QT

I'll post a patch tonight or tomorrow when I'm home

your idea to use mdbtools with native qt objects instead of glib sounds 
interesting
and similar to what I'm proposing.

Any offical comments?  Brian?  Fred?

Calvin

Re: [mdb-dev] PHP + unixODBC + MS Access

[<hak...@mp...>]

Hi Jeff,

The problem was that libodbcinst was not among the linked libraries.
When I compiled unixODBC it was named libodbcinst, not libodbcinst.so.=20
So when a configured MDBTools it could not be found and hence not linked=20
(no errors though). I created a symlink called libodbcinst.so,=20
configured and compiled MDBTools again.  This solved the problem.

Thanks!!
/H=E5kan


Jeff Smith wrote:

>The only way to get the error...
>
> =20
>
>>Could not find Database parameter, SQL state 08001 in SQLConnect
>>   =20
>>
>
>should be the entry having an empty Database parameter ("Database =3D")
>or not having a Database parameter at all.  As your entry seems to
>have a valid Database parameter, one thing I can think of is that
>there is another 'MSAccess-dummy' entry that is being picked up,
>perhaps from the user's .odbc.ini file.
>
>Another (remote) possibility may be that libodbcinst was not picked
>up when you were configuring/compiling.  Do an
>'ldd $YOUR_MDBTOOLS_PATH/lib/libmdbodbc.so' and see if libodbcinst
>is in the list of linked libraries.  If not, that may be a problem.
>
> =20
>
>>I downloaded the latest sources from MDBTools repository and used the=20
>>following configuration:
>>   =20
>>
>
>By this, I assume you mean the MDBTools' CVS repository.
>
> -- Jeff Smith
>
>__________________________________________________
>Do You Yahoo!?
>Tired of spam?  Yahoo! Mail has the best spam protection around=20
>http://mail.yahoo.com=20
> =20
>

--=20
M.Sc. H=E5kan Str=F6berg
Marquardt & Partners AB
M=E4ster Samuelsgatan 9
111 44  STOCKHOLM

Tel.  08 - 440 36 75
Mobil 0709 - 46 68 79
Fax.  08 - 440 36 71

[mdb-dev] home page & getting java port current

[Calvin S. <cal...@ho...>]

Any word yet on modifing the home page to include info about the java port?

I've been working at getting the Java port current, i've been able to come 
up with a few defines to compile the same code file as either C or Java.  
right now using the same code files all the C code works as before and the 
Java code can execute the mdb-ver command.  any objections to checking in 
the changes to the .c files? This way the java and c code can stay in sync
if not then i'll do do and then work on mdb-tables, mdb-schema and finally 
mdb-export at which time I can tie it into my jdbc driver, completing the 
task of getting the java port up to current cvs

if you want I can send you a patch (just supply a diff command you like) and 
you can preview my changes

Re: [mdb-dev] PHP + unixODBC + MS Access

[Jeff S. <why...@ya...>]

The only way to get the error...

> Could not find Database parameter, SQL state 08001 in SQLConnect

should be the entry having an empty Database parameter ("Database =")
or not having a Database parameter at all.  As your entry seems to
have a valid Database parameter, one thing I can think of is that
there is another 'MSAccess-dummy' entry that is being picked up,
perhaps from the user's .odbc.ini file.

Another (remote) possibility may be that libodbcinst was not picked
up when you were configuring/compiling.  Do an
'ldd $YOUR_MDBTOOLS_PATH/lib/libmdbodbc.so' and see if libodbcinst
is in the list of linked libraries.  If not, that may be a problem.

> I downloaded the latest sources from MDBTools repository and used the 
> following configuration:

By this, I assume you mean the MDBTools' CVS repository.

 -- Jeff Smith

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

[mdb-dev] ISQL and DataManager problem to access mdb file

[<eri...@ac...>]

Hi,
i have a problem on a RH 7.3 on a itanium 64 bit

i installed unixODBC and MDBtools
and configured odbc like this

odbcinst.ini

[PostgreSQL]
Description         = ODBC for PostgreSQL
Driver         = /usr/lib/libodbcpsql.so
Setup         = /usr/lib/libodbcpsqlS.so
FileUsage         = 1

[ODBC]
Trace         = Yes
Trace File         = /tmp/sql.log
Pooling         = No

[msACCESS]
Description         =
Driver         = /opt/mdbtools/lib/libmdbodbc.0.0.0
Setup         = /opt/mdbtools/lib/libmdbodbc.0.0.0
FileUsage         = 1
CPTimeout         =
CPReuse         =


odbc.ini
[constatBEA9802]
Description         = msACCESS
Driver         = msACCESS
Database         = /mnt/cdrom/bea.mdb

When i do isql -v constatBEA9802
it's ok i'm connected
but when i type help to have the list of tables isql crashes

here's the /tmp/sql.log

[ODBC][2210][__handles.c][357]
       Exit:[SQL_SUCCESS]
               Environment = 0x6000000000006c00
[ODBC][2210][SQLAllocHandle.c][294]
       Entry:
               Handle Type = 2
               Input Handle = 0x6000000000006c00
[ODBC][2210][SQLAllocHandle.c][383]
       Exit:[SQL_SUCCESS]
               Output Handle = 0x6000000000007150
[ODBC][2210][SQLConnect.c][2125]
       Entry:            
               Connection = 0x6000000000007150            
               Server Name = [constatBEA9802][length = 14 (SQL_NTS)]  
        
               User Name = [][length = 0 (SQL_NTS)]            
               Authentication = [][length = 0 (SQL_NTS)]
[ODBC][2210][SQLConnect.c][2672]
       Exit:[SQL_SUCCESS]
[ODBC][2210][SQLError.c][360]
       Entry:                
               Connection = 0x6000000000007150                
               SQLState = 0x60000fffffff90e0                
               Native = 0x60000fffffff90f4                
               Message Text = 0x60000fffffff8ee0                
               Buffer Length = 500                
               Text Len Ptr = 0x60000fffffff90f0
[ODBC][2210][SQLError.c][396]
       Exit:[SQL_NO_DATA]
[ODBC][2210][SQLError.c][439]
       Entry:                
               Environment = 0x6000000000006c00                
               SQLState = 0x60000fffffff90e0                
               Native = 0x60000fffffff90f4                
               Message Text = 0x60000fffffff8ee0                
               Buffer Length = 500                
               Text Len Ptr = 0x60000fffffff90f0
[ODBC][2210][SQLError.c][475]
       Exit:[SQL_NO_DATA]
[ODBC][2210][SQLAllocHandle.c][430]
       Entry:
               Handle Type = 3
               Input Handle = 0x6000000000007150
[ODBC][2210][SQLAllocHandle.c][787]
       Exit:[SQL_SUCCESS]
               Output Handle = 0x6000000000025e30
[ODBC][2210][SQLTables.c][148]
       Entry:            
               Statement = 0x6000000000025e30            
               Catalog Name = [NULL]            
               Schema Name = [NULL]            
               Table Name = [NULL]            
               Table Type = [NULL]
[ODBC][2210][SQLTables.c][369]
       Exit:[SQL_SUCCESS]
[ODBC][2210][SQLNumResultCols.c][129]
       Entry:            
               Statement = 0x6000000000025e30            
               Column Count = 0x60000fffffff12c0
[ODBC][2210][SQLNumResultCols.c][220]
       Exit:[SQL_SUCCESS]                
               Count = 0x60000fffffff12c0 -> 0
[ODBC][2210][SQLNumResultCols.c][129]
       Entry:            
               Statement = 0x6000000000025e30            
               Column Count = 0x60000fffffff1140
[ODBC][2210][SQLNumResultCols.c][220]
       Exit:[SQL_SUCCESS]                
               Count = 0x60000fffffff1140 -> 0
[ODBC][2210][SQLFetch.c][142]
       Entry:            
               Statement = 0x6000000000025e30

I have the same problem with Datamanager ...
seems like it crashes with SQLTables !!???

When i do mdb-tables /mnt/cdrom/bea.mdb
i have no table list ie a blank line

eric

[mdb-dev] ISQL and DataManager problem to access mdb file

[<eri...@ac...>]

Hi,
i have a problem on a RH 7.3 on a itanium 64 bit

i installed unixODBC and MDBtools
and configured odbc like this

odbcinst.ini

[PostgreSQL]
Description         = ODBC for PostgreSQL
Driver         = /usr/lib/libodbcpsql.so
Setup         = /usr/lib/libodbcpsqlS.so
FileUsage         = 1

[ODBC]
Trace         = Yes
Trace File         = /tmp/sql.log
Pooling         = No

[msACCESS]
Description         =
Driver         = /opt/mdbtools/lib/libmdbodbc.0.0.0
Setup         = /opt/mdbtools/lib/libmdbodbc.0.0.0
FileUsage         = 1
CPTimeout         =
CPReuse         =


odbc.ini
[constatBEA9802]
Description         = msACCESS
Driver         = msACCESS
Database         = /mnt/cdrom/bea.mdb

When i do isql -v constatBEA9802
it's ok i'm connected
but when i type help to have the list of tables isql crashes

here's the /tmp/sql.log

[ODBC][2210][__handles.c][357]
        Exit:[SQL_SUCCESS]
                Environment = 0x6000000000006c00
[ODBC][2210][SQLAllocHandle.c][294]
        Entry:
                Handle Type = 2
                Input Handle = 0x6000000000006c00
[ODBC][2210][SQLAllocHandle.c][383]
        Exit:[SQL_SUCCESS]
                Output Handle = 0x6000000000007150
[ODBC][2210][SQLConnect.c][2125]
        Entry:            
                Connection = 0x6000000000007150            
                Server Name = [constatBEA9802][length = 14 (SQL_NTS)]  
         
                User Name = [][length = 0 (SQL_NTS)]            
                Authentication = [][length = 0 (SQL_NTS)]
[ODBC][2210][SQLConnect.c][2672]
        Exit:[SQL_SUCCESS]
[ODBC][2210][SQLError.c][360]
        Entry:                
                Connection = 0x6000000000007150                
                SQLState = 0x60000fffffff90e0                
                Native = 0x60000fffffff90f4                
                Message Text = 0x60000fffffff8ee0                
                Buffer Length = 500                
                Text Len Ptr = 0x60000fffffff90f0
[ODBC][2210][SQLError.c][396]
        Exit:[SQL_NO_DATA]
[ODBC][2210][SQLError.c][439]
        Entry:                
                Environment = 0x6000000000006c00                
                SQLState = 0x60000fffffff90e0                
                Native = 0x60000fffffff90f4                
                Message Text = 0x60000fffffff8ee0                
                Buffer Length = 500                
                Text Len Ptr = 0x60000fffffff90f0
[ODBC][2210][SQLError.c][475]
        Exit:[SQL_NO_DATA]
[ODBC][2210][SQLAllocHandle.c][430]
        Entry:
                Handle Type = 3
                Input Handle = 0x6000000000007150
[ODBC][2210][SQLAllocHandle.c][787]
        Exit:[SQL_SUCCESS]
                Output Handle = 0x6000000000025e30
[ODBC][2210][SQLTables.c][148]
        Entry:            
                Statement = 0x6000000000025e30            
                Catalog Name = [NULL]            
                Schema Name = [NULL]            
                Table Name = [NULL]            
                Table Type = [NULL]
[ODBC][2210][SQLTables.c][369]
        Exit:[SQL_SUCCESS]
[ODBC][2210][SQLNumResultCols.c][129]
        Entry:            
                Statement = 0x6000000000025e30            
                Column Count = 0x60000fffffff12c0
[ODBC][2210][SQLNumResultCols.c][220]
        Exit:[SQL_SUCCESS]                
                Count = 0x60000fffffff12c0 -> 0
[ODBC][2210][SQLNumResultCols.c][129]
        Entry:            
                Statement = 0x6000000000025e30            
                Column Count = 0x60000fffffff1140
[ODBC][2210][SQLNumResultCols.c][220]
        Exit:[SQL_SUCCESS]                
                Count = 0x60000fffffff1140 -> 0
[ODBC][2210][SQLFetch.c][142]
        Entry:            
                Statement = 0x6000000000025e30

I have the same problem with Datamanager ...
seems like it crashes with SQLTables !!???

eric

[mdb-dev] PHP + unixODBC + MS Access

[<hak...@mp...>]

Hi,

I want to access *.mdb files within my php scripts. I have a Linux web=20
server with unixODBC installed. When I access the database with the=20
following php code:

<?php
$mydb =3D odbc_connect("MSAccess-dummy","","");
$query =3D "select * from Addresses";
$result =3D odbc_exec($mydb,$query);
$report =3D odbc_fetch_row($result);
echo odbc_result($result, 1);
odbc_close($mydb);
?>

I get this error back:

*Warning*: SQL error: [unixODBC]Could not find Database parameter, SQL=20
state 08001 in SQLConnect in */usr/local/httpd/htdocs/odbc.php* on line *=
3*
*Warning*: odbc_exec(): supplied argument is not a valid ODBC-Link=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *5*
*Warning*: odbc_fetch_row(): supplied argument is not a valid ODBC=20
result resource in */usr/local/httpd/htdocs/odbc.php* on line *6*
*Warning*: odbc_result(): supplied argument is not a valid ODBC result=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *7*
*Warning*: odbc_close(): supplied argument is not a valid ODBC-Link=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *8*

The triling warnings are due to the first one but what am I missing???=20
Which parameter??

I downloaded the latest sources from MDBTools repository and used the=20
following configuration:

$ ./configure --prefix=3D/usr/local/mdbodbc=20
--with-unixodbc=3D/usr/local/unixODBC --enable-sql

My odbcinst.ini looks like:

[MDBODBC]
Description =3D MDB Tools ODBC Driver
Driver      =3D /usr/local/mdbodbc/lib/libmdbodbc.so
Setup       =3D
FileUsage   =3D 1
CPTimeout   =3D
CPReuse     =3D


My odbc.ini file looks like:

[MSAccess-dummy]
Description =3D Microsoft Access Events database
Driver      =3D MDBODBC
Database    =3D /home/hakans/dummy.mdb
Servername  =3D localhost
UserName    =3D
Password    =3D
Port        =3D 5432

$ ll /home/hakans/dummy.mdb
-rw-r--r--  1 hakans users 180224 Jan 12 11:10 /home/hakans/dummy.mdb


Grateful for any kind of help.

Regards,
/H=E5kan

[mdb-dev] PHP + unixODBC + MS Access

[<hak...@mp...>]

Hi,

I want to access *.mdb files within my php scripts. I have a Linux web=20
server with unixODBC installed. When I access the database with the=20
following php code:

<?php
$mydb =3D odbc_connect("MSAccess-dummy","","");
$query =3D "select * from Addresses";
$result =3D odbc_exec($mydb,$query);
$report =3D odbc_fetch_row($result);
echo odbc_result($result, 1);
odbc_close($mydb);
?>

I get this error back:

*Warning*: SQL error: [unixODBC]Could not find Database parameter, SQL=20
state 08001 in SQLConnect in */usr/local/httpd/htdocs/odbc.php* on line *=
3*
*Warning*: odbc_exec(): supplied argument is not a valid ODBC-Link=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *5*
*Warning*: odbc_fetch_row(): supplied argument is not a valid ODBC=20
result resource in */usr/local/httpd/htdocs/odbc.php* on line *6*
*Warning*: odbc_result(): supplied argument is not a valid ODBC result=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *7*
*Warning*: odbc_close(): supplied argument is not a valid ODBC-Link=20
resource in */usr/local/httpd/htdocs/odbc.php* on line *8*

The triling warnings are due to the first one but what am I missing???=20
Which parameter??

I downloaded the latest sources from MDBTools repository and used the=20
following configuration:

$ ./configure --prefix=3D/usr/local/mdbodbc=20
--with-unixodbc=3D/usr/local/unixODBC --enable-sql

My odbcinst.ini looks like:

[MDBODBC]
Description =3D MDB Tools ODBC Driver
Driver      =3D /usr/local/mdbodbc/lib/libmdbodbc.so
Setup       =3D
FileUsage   =3D 1
CPTimeout   =3D
CPReuse     =3D


My odbc.ini file looks like:

[MSAccess-dummy]
Description =3D Microsoft Access Events database
Driver      =3D MDBODBC
Database    =3D /home/hakans/dummy.mdb
Servername  =3D localhost
UserName    =3D
Password    =3D
Port        =3D 5432

$ ll /home/hakans/dummy.mdb
-rw-r--r--  1 hakans users 180224 Jan 12 11:10 /home/hakans/dummy.mdb


Grateful for any kind of help.

Regards,
/H=E5kan

[mdb-dev] Re: mdb-queries

[Lenny L. <lle...@ma...>]

Here is the latest source of mdb-queries.  It's been a while since I've 
done any work on it, but feel free to send me any questions if you have 
them.  Are you planning on doing some development work on this or do you 
just have an interest in using it?

Place in the src/util directory.
Edit the src/util/Makefile.am and add mdb-queries to the list of 
bin_PROGRAMS.
Then, I believe you should run the autogen.sh script to bring the 
Makefiles up to date.

It was fully tested and appeared to work fine on the tests that I ran.

--
Lenny Leblanc

Artur Frysiak wrote:

>Hello
>I looking for sources of mdb-queries utility.
>
>Best regards
>  
>

Re: [mdb-dev] problem with queries

[Sam M. <pa...@gm...>]

Just as a diagnostic have you tried adding limit statements to see
when and where the problem triggers itself?

Sam


On Mon, 10 Jan 2005 15:36:19 +0100 (MET), Lorenzo Natile
<l.n...@ci...> wrote:
> Hi all,
> I'm using java version of mdbtools and I have a problem with a query
> (select IDTITOLARE from TITOLARE).
> The error message is:
> java.lang.RuntimeException: offset 32842465280 is beyond EOF
>         at mdbtools.libmdb.file._mdb_read_pg(Unknown Source)
>         at mdbtools.libmdb.file.mdb_read_alt_pg(Unknown Source)
>         at mdbtools.libmdb.Table.mdb_read_table(Unknown Source)
>         at mdbtools.libmdb.Catalog.mdb_read_catalog(Unknown Source)
>         at mdbtools.jdbc2.MDBConnection.<init>(Unknown Source)
>         at mdbtools.jdbc2.Driver.connect(Unknown Source)
>         at java.sql.DriverManager.getConnection(DriverManager.java:512)
>         at java.sql.DriverManager.getConnection(DriverManager.java:193)
>         at mdbtools.jdbc.Test.main(Unknown Source)
> 
> I suppose the problem is the .mdb file size (3.278.848 bytes).
> I've tried with another file containing the same table (TITOLARE) which
> size is 159.744 bytes and it works correctly.
> Anyone can help me?
> 
> Thanks,
> Lorenzo
> 
> -------------------------------------------------------
> The SF.Net email is sponsored by: Beat the post-holiday blues
> Get a FREE limited edition SourceForge.net t-shirt from ThinkGeek.
> It's fun and FREE -- well, almost....http://www.thinkgeek.com/sfshirt
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

[mdb-dev] problem with queries

[Lorenzo N. <l.n...@ci...>]

Hi all,
I'm using java version of mdbtools and I have a problem with a query 
(select IDTITOLARE from TITOLARE).
The error message is:
java.lang.RuntimeException: offset 32842465280 is beyond EOF
        at mdbtools.libmdb.file._mdb_read_pg(Unknown Source)
        at mdbtools.libmdb.file.mdb_read_alt_pg(Unknown Source)
        at mdbtools.libmdb.Table.mdb_read_table(Unknown Source)
        at mdbtools.libmdb.Catalog.mdb_read_catalog(Unknown Source)
        at mdbtools.jdbc2.MDBConnection.<init>(Unknown Source)
        at mdbtools.jdbc2.Driver.connect(Unknown Source)
        at java.sql.DriverManager.getConnection(DriverManager.java:512)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at mdbtools.jdbc.Test.main(Unknown Source)

I suppose the problem is the .mdb file size (3.278.848 bytes).
I've tried with another file containing the same table (TITOLARE) which 
size is 159.744 bytes and it works correctly.
Anyone can help me?

Thanks,
Lorenzo

Re: [mdb-dev] New to list + Internal doco

[Jeff S. <why...@ya...>]

--- Martin Ellis <m.a...@nc...> wrote:
> Firstly, I'm new to the list - if anyone could send me the list 
> archives in mbox or maildir format I'd be _very_ grateful.  Reading 
> online at SF is so painfully slow.

Sorry, can't help you out there (though I agree with the SF comment).

> Secondly, what tool is being used to produce API documentation?

gtk-doc.  I would prefer doxygen (at least for everything outside
gmdb and gmdb2), but it wasn't my decision to make.  I don't have
gtk-doc installed (but may soon as I have started messing with
gmdb2), so I don't know how well it really works.

> Thanks
> Martin

 -- Jeff


		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - Helps protect you from nasty viruses. 
http://promotions.yahoo.com/new_mail

[mdb-dev] New to list + Internal doco

[Martin E. <m.a...@nc...>]

Hi all,

I have a couple of questions re. mdbtools.

Firstly, I'm new to the list - if anyone could send me the list 
archives in mbox or maildir format I'd be _very_ grateful.  Reading 
online at SF is so painfully slow.

Secondly, what tool is being used to produce API documentation?

I've seen comments like:
/**
 * mdb_get_relationships
 * @mdb: Handle to open MDB database file
 *
 * Generates relationships by reading the MSysRelationships table.
 */
but don't recognise the @<arg-name> notation (I've only used Doxygen 
before and it whinges bitterly that it doesn't understand the input).

Thanks
Martin

[mdb-dev] new home page

[Calvin S. <cal...@ho...>]

Attached is a reworked home page that mentions the java port. Making it more 
visible.  A java port is useful for anyone coding in java as it's much 
easier to setup than the jdbc-odbc route.
Could someone please post this?
I just checked in my latest code and it compiles cleanly now.  If you want I 
can also supply a build of the current code to place in the download 
section.  which is what the download link should point to.

[mdb-dev] status of 0.6

[Calvin S. <cal...@ho...>]

I have been really busy with new job to work much on the java port, but on 
the plus side it is fairly complete except for joins and missing sql 
functions.  the sql functions are fairly simple to add so if anyone needs a 
particular one, just ask.
The java version is quite old and not able to handle as many mdb files as 
current cvs, however, it is still the latest realeased code.  What is the 
status of 0.6?  Is it stable?  If I port it to java will it change much 
between now and official 0.6?  or is 0.6 official due to be released soon?

Re: [mdb-dev] mdb-export and no dates become 1970

[David W. <dav...@ya...>]

Hi Jeff,

 --- Jeff Smith <why...@ya...> wrote: 
> David,
> 
> First, here is a little background info, FWIW.  In
> an MDB,
> date/time info is stored as a 'double' containing
> the
> number days from 12/30/1899.  Internally there is no
> distinction between 6:00 and 12/30/1899 6:00 (0.25).
> I believe information on how to format the output in
> Access is stored elsewhere in the MDB.  Try
> exporting
> a table with a date-less time from Access to a text
> file
> and you will see a date with it there too.

Gotcha. 


> mdbtools has been using gmtime to populate a 'tm'
> structure.
> That only really works for 'unix time' though (1970
> - 2038).
> I am looking at ways to populate it that would work
> for dates
> from 1/1/100 to 12/31/9999, as Access allows.  This
> would
> still have the same issue with exporting as Access
> does.  But
> maybe 1899 would be more acceptable in your case
> than 1970.

Currently I don't have a specific problem, I am trying
to think ahead and anticipate problems that might crop
up. 1899 will probably be less common than 1970, so
this should help. I will add a note (based on your
comments if that's okay) warning users about times
without dates.

> 
> BTW, with mdb-export you can use -D to set the
> output format,
> but this will be applied to the whole table, which
> is probably
> not what you had in mind.

Yes, I use this to make sure the dates/times come out
in a standard format. I think I'll add an option to
change the default that I use.

Thanks for your help.

Dave

> 
>  -- Jeff Smith
> 
> 
> --- David Whiting <dav...@ya...> wrote:
> > Hi,
> > 
> > I am playing with developing some wrappers to use
> > mdbtools with a statistical package
> > (www.r-project.org). I notice that mdb-export will
> > export data stored as Date/Time type that only
> contain
> > the time component with the default date of
> > 01/01/1970. This means that it will not be
> possible
> > for me to distinguish between real dates of
> 01/01/1970
> > and times with missing dates. Is there any way to
> > distinguish between the two, or is this a
> limitation
> > of the way access stores the data in the first
> place? 
> > 
> > Dave
> 
> 
> 
> 
> 		
> __________________________________ 
> Do you Yahoo!? 
> The all-new My Yahoo! - What will yours do?
> http://my.yahoo.com 
> 
> 
>
-------------------------------------------------------
> 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://productguide.itmanagersjournal.com/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
>
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>  


	
	
		
___________________________________________________________ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com

Re: [mdb-dev] mdb-export and no dates become 1970

[Jeff S. <why...@ya...>]

> mdbtools has been using gmtime to populate a 'tm' structure.
> That only really works for 'unix time' though (1970 - 2038).
> I am looking at ways to populate it that would work for dates
> from 1/1/100 to 12/31/9999, as Access allows.  This would
> still have the same issue with exporting as Access does.  But
> maybe 1899 would be more acceptable in your case than 1970.

I have made the necessary changes and committed them to CVS.
Please test it out.

 -- Jeff Smith

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [mdb-dev] mdb-export and no dates become 1970

[Jeff S. <why...@ya...>]

David,

First, here is a little background info, FWIW.  In an MDB,
date/time info is stored as a 'double' containing the
number days from 12/30/1899.  Internally there is no
distinction between 6:00 and 12/30/1899 6:00 (0.25).
I believe information on how to format the output in
Access is stored elsewhere in the MDB.  Try exporting
a table with a date-less time from Access to a text file
and you will see a date with it there too.

mdbtools has been using gmtime to populate a 'tm' structure.
That only really works for 'unix time' though (1970 - 2038).
I am looking at ways to populate it that would work for dates
from 1/1/100 to 12/31/9999, as Access allows.  This would
still have the same issue with exporting as Access does.  But
maybe 1899 would be more acceptable in your case than 1970.

BTW, with mdb-export you can use -D to set the output format,
but this will be applied to the whole table, which is probably
not what you had in mind.

 -- Jeff Smith


--- David Whiting <dav...@ya...> wrote:
> Hi,
> 
> I am playing with developing some wrappers to use
> mdbtools with a statistical package
> (www.r-project.org). I notice that mdb-export will
> export data stored as Date/Time type that only contain
> the time component with the default date of
> 01/01/1970. This means that it will not be possible
> for me to distinguish between real dates of 01/01/1970
> and times with missing dates. Is there any way to
> distinguish between the two, or is this a limitation
> of the way access stores the data in the first place? 
> 
> Dave




		
__________________________________ 
Do you Yahoo!? 
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com 

[mdb-dev] mdb-export and no dates become 1970

[David W. <dav...@ya...>]

Hi,

I am playing with developing some wrappers to use
mdbtools with a statistical package
(www.r-project.org). I notice that mdb-export will
export data stored as Date/Time type that only contain
the time component with the default date of
01/01/1970. This means that it will not be possible
for me to distinguish between real dates of 01/01/1970
and times with missing dates. Is there any way to
distinguish between the two, or is this a limitation
of the way access stores the data in the first place? 

Dave


	
	
		
___________________________________________________________ 
ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com

Re: [mdb-dev] java mdb tools

[Jeff S. <why...@ya...>]

Yes, there is a java version of mdbtools, kindly ported by Calvin Smith.
Note that it is a port of version 0.5, which is a bit old.

It is available from CVS.  The module name is mdbtools-java.

 -- Jeff Smith


--- Lorenzo Natile <l.n...@ci...> wrote:
> Hi all,
> I'd like to manage mdb files from a java servlet under linux.
> How can I do this?
> Is there a java version of mdb tools?
> How can I get it?
> 
> Thanks,
> Lorenzo

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Re: [mdb-dev] cvs password

[Sam M. <pa...@gm...>]

Just a small update, after a while CVS came back with this:
cvs [login aborted]: connect to
cvs.mdbtools.sourceforge.net(66.35.250.209):2401 failed: Connection
timed out

and I just realized that isn't it:
cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools login 

Just tried that and it works.

Sam

On Thu, 23 Dec 2004 12:47:04 +1000, Sam Moffatt <pa...@gm...> wrote:
> The password should be blank, just hit enter at the prompt
> (http://sourceforge.net/cvs/?group_id=2294). Although I just tried and
> it seems that CVS has died or something.
> 
> Sourceforge doesn' t mention anything either. Strange.
> 
> On Wed, 22 Dec 2004 21:40:34 +0100 (MET), Lorenzo Natile
> <l.n...@ci...> wrote:
> > Hi all,
> > what's the cvs password to log in with the command:
> > cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools
> > login ?
> >
> > Thanks,
> > Lorenzo
> >
> > -------------------------------------------------------
> > 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://productguide.itmanagersjournal.com/
> > _______________________________________________
> > mdbtools-dev mailing list
> > mdb...@li...
> > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> >
>

Re: [mdb-dev] cvs password

[Sam M. <pa...@gm...>]

The password should be blank, just hit enter at the prompt
(http://sourceforge.net/cvs/?group_id=2294). Although I just tried and
it seems that CVS has died or something.

Sourceforge doesn' t mention anything either. Strange.

On Wed, 22 Dec 2004 21:40:34 +0100 (MET), Lorenzo Natile
<l.n...@ci...> wrote:
> Hi all,
> what's the cvs password to log in with the command:
> cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools
> login ?
> 
> Thanks,
> Lorenzo
> 
> -------------------------------------------------------
> 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://productguide.itmanagersjournal.com/
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>

[mdb-dev] cvs password

[Lorenzo N. <l.n...@ci...>]

Hi all,
what's the cvs password to log in with the command:
cvs -d:pserver:ano...@cv...:/cvsroot/mdbtools 
login ?

Thanks,
Lorenzo

[mdb-dev] java mdb tools

[Lorenzo N. <l.n...@ci...>]

Hi all,
I'd like to manage mdb files from a java servlet under linux.
How can I do this?
Is there a java version of mdb tools?
How can I get it?

Thanks,
Lorenzo