mdbtools-dev

[mdb-dev] mdbtools with tcl

[Christian L. <chr...@la...>]

  I wrote some code to use mdbsql from tcl.

  Here is a usage example :
% load libMdb
% ::mdb::connect liste.mdb
cnx1
% cnx1 tables
AOM_ANCIEN BRANCHE DEPARTEMENT DIRECTION EQUIPE IDENTITE OPTIONS SITE
UNITE
% cnx1 columns UNITE
{LBL Text} {ID {Long Integer}}
% cnx1 sql "select * from UNITE where ID=1902"
{Financial 1902}
% cnx1 sql -headers "select * from UNITE where ID=1902"
{LBL ID} {Financial 1902}

  Is anybody interested in it ?

Bye, Pif.

[mdb-dev] mdb-export producing bad results on one particular table

[Christian L. <chr...@la...>]

  I've got the same problem than Max Bowsher
(http://sourceforge.net/mailarchive/message.php?msg_id=9588463)
but I can't "Compact Database" because I work under linux, on a single
jet4 file that is sent "as is" by an external export routine.

  In fact, mdb-export and "select *" with mdb-sql give the same
result : some rows of some tables are missing (all of them for one
table).
  The same requests with 0.5 work fine.
  I don't know anything about mdb structure, so I can't help anyway,
but I can send the mdb file in private if it helps (2.5Mb).

Bye, Pif.

[mdb-dev] don't compile if no readline.h

[Christian L. <chr...@la...>]

Hello,
  I use mdbtools 0.5 for a personal project since last week.
  I just downloaded 0.6pre version, and "make" failed.
  "configure" correctly found that readline.h is not installed, but
mdb-sql.c doesn't nest "*_history" function calls with
"ifdef HAVE_READLINE".

  Here is a patch to apply to mdb-sql.c file to add these ifdef

  Hope this helps,

Bye, Pif.

[mdb-dev] Writing

[Avner P. <av...@in...>]

Hello!

I'm having problems with writing (for example using the updrow 
application) in latest mdbtools cvs.

when changing a numerical value, the value and the value next to it turn 
into garbage.

when changing a string value, the following things happens:

if my table, t_people, looks like this

id      first_name       last_name      age    zipcode
1       avner               peled              21       9540
2       ...                      ....                   ...

and I enter

updrow avner1.mdb t_people "id = 1" last_name=shalom

then this:

0fdb  05 00 01 00 00 00 15 00  00 00 44 25 00 00 ff fe   ..........D%....
0feb  61 76 6e 65 72 ff fe 70  65 6c 65 64 1c 00 15 00   avner..peled....
0ffb  0e 00 02 00 1f                                                    
      .....

turns into this:

0000  05 00 01 00 00 00 15 00  00 00 44 25 00 00 ff fe      ..........D%....
0010  61 76 6e 65 72 73 68 61  6c 6f 6d 1b 00 15 00 0e   avnershalom.....
0020  00 02 00 1f  

when viewing the table after the update, last_name appears as "sao" 
instead of "shalom"

it seems the update ignores the "ff fe" in the start of the string, what 
is that anwway?

Any ideas? any help would be appreciated.
If anyone wants I will also post the nuber update which turns small 
numbers into negative and very big numbers.

Thanks!

Avner Peled
av...@in...

Re: [mdb-dev] RPM packaging errors

[Kenneth P. <sh...@se...>]

--On Tuesday, October 12, 2004 5:35 AM -0700 Jeff Smith 
<why...@ya...> wrote:

> mdbtools-0.6-0.pre1.tar.gz comes with an older version of ltmain.sh
> (1.5).  With it, the '.so' is missing from the file names.  With version
> 1.5.6, the correct files are created (for me at least).  If you have
> libtool installed, you may be able to copy the file from
> /usr/local/share/libtool/.

Ok, I got around that by symlinking the current version into the build 
directory. I could probably go as far as regenerating configure with 
autoconf but most packages don't do that.

I also fixed the name mdb-dump to mdb-hexdump.

With that done, the build completes and I'm left with these "unpackaged" 
files:

   /usr/bin/mdb-import
   /usr/bin/mdb-prop
   /usr/bin/prcat
   /usr/bin/prdata
   /usr/bin/prdump
   /usr/bin/prindex
   /usr/bin/prkkd
   /usr/bin/prole
   /usr/bin/prtable
   /usr/bin/unittest
   /usr/bin/updrow
   /usr/include/connectparams.h
   /usr/include/gmdb.h
   /usr/include/mdbodbc.h
   /usr/include/mdbprivate.h
   /usr/include/mdbver.h
   /usr/lib/pkgconfig/libmdb.pc
   /usr/lib/pkgconfig/libmdbsql.pc

Should all of these be left out of the RPM? Or is this an oversight?

Right now the subpackages include base, devel, odbc, and gui. I'd guess the 
utilities in /usr/bin should go in base, and the pkgconfig stuff in include 
and lib should go in devel. Does any of it go in odbc or gui, or get left 
out altogether?

Re: [mdb-dev] RPM packaging errors

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

mdbtools-0.6-0.pre1.tar.gz comes with an older version of ltmain.sh (1.5).  With
it, the '.so' is missing from the file names.  With version 1.5.6, the correct
files are created (for me at least).  If you have libtool installed, you may be
able to copy the file from /usr/local/share/libtool/.

BTW, according to CVS, there has never been a file 'BUGS' so feel free to take
it out of that packaging list.

Based on CVS contents, it seems that so far, the maintainers have been keeping
generated files in CVS to a minimum.  Hopefully Brian can respond as to your
final suggestion.

 -- Jeff Smith


--- Kenneth Porter <sh...@se...> wrote:

> I'm trying to build an RPM from the 0.6pre1 tarball. After tweaking the 
> tarball filenames in the spec file to handle the "beta-ness", I'm getting 
> errors due to problems in the %files section. (Red Hat's rpmbuild is fairly 
> strict about packaged files to protect one from packaging errors.)
> 
> Processing files: mdbtools-0.6-0.pre1
> error: File not found by glob: /home/buildmeister/var/tmp/usr/lib/libmdb.so*
> error: File not found by glob: 
> /home/buildmeister/var/tmp/usr/lib/libmdbsql.so*
> error: File not found: /home/buildmeister/var/tmp/usr/bin/mdb-dump
> 
> Where do the so's get created? I thought libtool might do it but don't see 
> it creating the files.
> 
> cp: cannot stat `BUGS': No such file or directory
> 
> This one's easy enough to fix. Did the file get lost?
> 
> In %files gui we have:
> 
> %{_datadir}/gnome/help/gmdb/C/*
> %{_datadir}/gnome/help/gmdb/C/figures/*
> 
> This results in double-listing the PNG files. Only the parent listing is 
> needed.
> 
> Once I get this working I can post a patch for the spec file. There really 
> should be a spec file (not just a spec.in) in the tarball so that one can 
> rebuild the RPM using "rpmbuild -ta xxxx.tar.gz". The tarball building 
> procedure should be tweaked to accomplish that.



		
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

[mdb-dev] RPM packaging errors

[Kenneth P. <sh...@se...>]

I'm trying to build an RPM from the 0.6pre1 tarball. After tweaking the 
tarball filenames in the spec file to handle the "beta-ness", I'm getting 
errors due to problems in the %files section. (Red Hat's rpmbuild is fairly 
strict about packaged files to protect one from packaging errors.)

Processing files: mdbtools-0.6-0.pre1
error: File not found by glob: /home/buildmeister/var/tmp/usr/lib/libmdb.so*
error: File not found by glob: 
/home/buildmeister/var/tmp/usr/lib/libmdbsql.so*
error: File not found: /home/buildmeister/var/tmp/usr/bin/mdb-dump

Where do the so's get created? I thought libtool might do it but don't see 
it creating the files.

cp: cannot stat `BUGS': No such file or directory

This one's easy enough to fix. Did the file get lost?

In %files gui we have:

%{_datadir}/gnome/help/gmdb/C/*
%{_datadir}/gnome/help/gmdb/C/figures/*

This results in double-listing the PNG files. Only the parent listing is 
needed.

Once I get this working I can post a patch for the spec file. There really 
should be a spec file (not just a spec.in) in the tarball so that one can 
rebuild the RPM using "rpmbuild -ta xxxx.tar.gz". The tarball building 
procedure should be tweaked to accomplish that.

Re: [mdb-dev] Cannot open shared object file

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

1. --enable-sql is implicit with --with-unixodbc, so you don't need it.  No harm
   in leaving it there either.

2. Make sure you get rid of libmdb* in your /usr/local/lib directory before
   proceeding, because anything from mdbtools that is there right now is total
   junk that can only be swept up 'manually'.

3. As for the actual problem, it appears that 0.6pre1 packaged an older
   ltmain.sh than it should have.  If you have libtool installed, just
   copy /usr/local/share/libtool/ltmain.sh into your mdbtools-0.6pre1
   directory and start back at the configure stage.

   The libtool version that comes with Slackware 10 seems to be 1.5.6, which
   is what I have on my system.  The one that was packaged with mdbtools-0.6pre1
   appears to be 1.5.

   If you need me to, I can email you the relevant file.

 -- Jeff Smith


--- Barrie Backhurst <bar...@nt...> wrote:
> Hi
> 
> Just installed mdbtools-0.6pre1 on Slackware 10, configured with ./configure 
> --enable-sql --with-unixodbc=/usr/local, as per the install text. When I try 
> to invoke the programs, I get the following error
> 
> mdb-tables: error while loading shared libraries: libmdb.0: cannot open shared 
> object file: No such file or directory
> 
> I have attached the config.log, if that should give any clues. I have not done 
> many source installs, so probably missing something obvious.
> 
> Barrie


		
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com

[mdb-dev] Cannot open shared object file

[Barrie B. <bar...@nt...>]

Hi

Just installed mdbtools-0.6pre1 on Slackware 10, configured with ./configure 
--enable-sql --with-unixodbc=/usr/local, as per the install text. When I try 
to invoke the programs, I get the following error

mdb-tables: error while loading shared libraries: libmdb.0: cannot open shared 
object file: No such file or directory

I have attached the config.log, if that should give any clues. I have not done 
many source installs, so probably missing something obvious.

Barrie

[mdb-dev] Re: Welcome to the "mdbtools-dev" mailing list

[Rodrigo C. <gr...@ca...>]

Dear Folks!

I saw this project and I am very enthusiastic with it.

I searched on the change log os the 0.6 pre1 but without find any=20
concrete if on this version the write possibility on MDB=B4s was possible=
,

Please, inform about this and if not, how can I help to finish the=20
development of this feature, that is very important for me.

Cheers

Rodrigo Miranda Carvalhaes
DBA PostgreSQL


mdb...@li... wrote:
> Welcome to the mdb...@li... mailing list!
>=20
> To post to this list, send your email to:
>=20
>   mdb...@li...
>=20
> General information about the mailing list is at:
>=20
>   https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>=20
> If you ever want to unsubscribe or change your options (eg, switch to
> or from digest mode, change your password, etc.), visit your
> subscription page at:
>=20
>   https://lists.sourceforge.net/lists/options/mdbtools-dev/grupos%40car=
valhaes.net
>=20
>=20
> You can also make such adjustments via email by sending a message to:
>=20
>   mdb...@li...
>=20
> with the word `help' in the subject or body (don't include the
> quotes), and you will get back a message with instructions.
>=20
> You must know your password to change your options (including changing
> the password, itself) or to unsubscribe.  It is:
>=20
>   141096
>=20
> If you forget your password, don't worry, you will receive a monthly
> reminder telling you what all your lists.sourceforge.net mailing list
> passwords are, and how to unsubscribe or change your options.  There
> is also a button on your options page that will email your current
> password to you.
>=20
> You may also have your password mailed to you automatically off of the
> Web page noted above.
>=20

[mdb-dev] problems with quoted fields in 0.6pre

[Enriko G. [Zoranet] <enr...@zo...>]

Hi!

I have a Debian Sarge desktop which has mdbtools 0.6pre installed from a 
quite recent package (gmdb installed too). I have used an older 
mdb-tools and gmdb under Mandrake before to lookup data in table before.

With 0.6pre I am unable to see fields that have quotes in them. The file 
I use an 43MB file containing zipcode information. It is in JET4 format.

I just installed an older (0.5) mdb-tools on a FreeBSD system (from 
ports). This exported the quoted data fine.

Is this a known issue?

-- 
Enriko Groen
Zoranet systems administrator

enr...@zo... // +31 38 455 95 62
Zoranet // 8025 BS 6c // Zwolle // Netherlands

[mdb-dev] mdbtools bugs under mingw environment

[Pietro B. <pie...@ya...>]

Hi all,

I tried to compile mdbtools-0.5 under windows ME with
minGW environment and I had success, but I found a
couple
of bug that make the package not-working under this 
environment.

My goal was to convert an old mdb file built with
access 95 using
the utility mdb-export.

Under linux environment the whole file is correctly
dumped to a csv
format, while under windows only the first 6 records
are dumped.
The problem seems to be in mdb_fetch_row() procedure
with the call
to mdb_read_next_dpg() failing and making the program
end.

Going inside the code I found that the access to mdb
file itself goes
wrong and I think that the cause is the way file is
open in _mdb_open().
I think the flag _O_BINARY should be included in
open() call.
This makes the package go beyond the first 6 records.

Another problem I found is related to the last
variable size field
in mdb record.
It seems to have a negative length so the field is
handled by the library
as empty.
The bug seems to be solved by modifying the length and
adding 256 to the negative value;
this is what mdb_read_row() does for each other
variable field in record.
So moving the following code ( taken from
mdb_read_row() source ) :

		if (len<0)
			len+=256;

outside the else branch of
"if(var_cols_found==var_cols)" test
make the mdb-export work pretty well.

I Hope this is helpful for making mdbtools even better
!

Regards
	Pietro 
 



		
___________________________________
Scopri Mister Yahoo! - il fantatorneo sul calcio di Yahoo! Sport
http://it.seriea.fantasysports.yahoo.com/

Re: [mdb-dev] Very very weird connection error - unixODBC

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

I doubt the problem has to do with Unicode, not that I would completely rule it out,
either.  If you can, please try running the script from the command line
('php /srv/www/htdocs/odbc-test.php')
and let me know if you see any additional information.  Also, is that the only entry in
odbc.ini?

 -- Jeff Smith


--- Rob Pomeroy <ro...@el...> wrote:

> I'm getting this error (or slight variations of it):
> 
> Warning: SQL error: x)@[wØÈÿ¿ÿë@ˆ)@·S, SQL state 00000 in SQLConnect in
> /srv/www/htdocs/odbc-test.php on line 3
> 
> Anyone have ANY idea what all that junk is about?
> 
> Thanks,
> 
> Rob
> 
> 
> 
> 
> The setup:
> 
> unixODBC 2.2.9 (same error with 2.2.3)
> mdbtools 0.6
> PHP 4.3.1
> 
> --------------
> /etc/odbc.ini:
> 
> [MatterData]
> Description = Lawbyte Matter tables
> Driver      = MDBToolsODBC
> Database    = /home/public/LawbyteData/matters.mdb
> Servername  = localhost
> UserName    =
> Password    =
> Port        = 5432
> --------------
> 
> 
> --------------
> /etc/odbcinsti.ini:
> 
> [MDBToolsODBC]
> Description = MDB Tools ODBC drivers
> Driver      = /usr/local/lib/libmdbodbc.so.0
> Setup       =
> FileUsage   = 1
> CPTimeout   =
> CPReuse     =
> --------------
> 
> --------------
> The script:
> 
> <?php
> 
> $db = odbc_connect("MatterData","","");
> 
> ?>
> --------------
> 
> --
> Rob Pomeroy: ro...@el...
> Solicitor specialising in charity law, wills, probate and trusts
> Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
> Telephone: 01244 319388; Fax: 01244 319333
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM. 
> Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 



		
__________________________________
Do you Yahoo!?
Take Yahoo! Mail with you! Get it on your mobile phone.
http://mobile.yahoo.com/maildemo 

Re: [mdb-dev] mdb-export producing bad results on one particular table

[Max B. <max...@gm...>]

On Tue, 21 Sep 2004 18:21:36 -0400, David Mansfield
<mdb...@dm...> wrote:
> What version of the s/w are you using?

0.6pre1, on a JET3 database.


> On Tue, 2004-09-21 at 16:13, Max Bowsher wrote:
> > I've been testing mdb-export on a database of ours - it's producing
> > rather odd dumps from one table - that is, some rows are missing, and
> > some columns dump as being entirely blank, or in the wrong order. One
> > thing possibly of note is that the columns in this table have been
> > reorganized quite a lot.
> >
> > Unfortunately, the db in question contains data I wouldn't be able to
> > get permission to release, and when I attempted to prune the data to a
> > small subset, I found that the problem 'solved' itself when I ran
> > "Compact Database".
> >
> > Is there any debugging that can I can do here, or does my inability to
> > provide a copy of the database make it infeasibly difficult?
> >
> > Whatever happens, "Compact Database" seems to be an effective workaround.
> >
> > Thanks,
> >
> > Max.

Re: [mdb-dev] mdb-export producing bad results on one particular table

[David M. <mdb...@dm...>]

What version of the s/w are you using?


David


On Tue, 2004-09-21 at 16:13, Max Bowsher wrote:
> I've been testing mdb-export on a database of ours - it's producing
> rather odd dumps from one table - that is, some rows are missing, and
> some columns dump as being entirely blank, or in the wrong order. One
> thing possibly of note is that the columns in this table have been
> reorganized quite a lot.
> 
> Unfortunately, the db in question contains data I wouldn't be able to
> get permission to release, and when I attempted to prune the data to a
> small subset, I found that the problem 'solved' itself when I ran
> "Compact Database".
> 
> Is there any debugging that can I can do here, or does my inability to
> provide a copy of the database make it infeasibly difficult?
> 
> Whatever happens, "Compact Database" seems to be an effective workaround.
> 
> Thanks,
> 
> Max.
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.
> Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
> 

[mdb-dev] mdb-export producing bad results on one particular table

[Max B. <max...@gm...>]

I've been testing mdb-export on a database of ours - it's producing
rather odd dumps from one table - that is, some rows are missing, and
some columns dump as being entirely blank, or in the wrong order. One
thing possibly of note is that the columns in this table have been
reorganized quite a lot.

Unfortunately, the db in question contains data I wouldn't be able to
get permission to release, and when I attempted to prune the data to a
small subset, I found that the problem 'solved' itself when I ran
"Compact Database".

Is there any debugging that can I can do here, or does my inability to
provide a copy of the database make it infeasibly difficult?

Whatever happens, "Compact Database" seems to be an effective workaround.

Thanks,

Max.

[mdb-dev] UNsubscribe

[Chandra <cha...@ta...>]

Please unsubscribe me from this list.  Thank you

-----Original Message-----
From: mdb...@li...
[mailto:mdb...@li...] On Behalf Of
mdb...@li...
Sent: 21 September 2004 04:43
To: mdb...@li...
Subject: mdbtools-dev digest, Vol 1 #441 - 1 msg

Send mdbtools-dev mailing list submissions to
	mdb...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
or, via email, send a message with subject or body 'help' to
	mdb...@li...

You can reach the person managing the list at
	mdb...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of mdbtools-dev digest..."


Today's Topics:

   1. Re: Very very weird connection error - unixODBC (Rob Pomeroy)

--__--__--

Message: 1
From: "Rob Pomeroy" <ro...@el...>
To: <mdb...@li...>
Date: Mon, 20 Sep 2004 14:41:42 +0100
Subject: [mdb-dev] Re: Very very weird connection error - unixODBC

> I am not sure, but I think this junk is a UCS-2 string...  The other
> problem is that mdbtools SQL parser still can not handle Unicode
> strings.

Okay, you're talking a LITTLE over my head there!  :-)  Is your =
suggestion
that my Linux locale settings may somehow be causing the conflict?  The
various mdbtools work okay (apart from one problem - see below), just =
not
the unixODBC connection.

> There is a patch in [1] for mdbtools which could temporally
> fix this error.
> [1] http://sourceforge.net/tracker/?group_id=3D3D2294&atid=3D3D302294

Unfortunately this link seems to send me to a page saying "Error -
ArtifactType: Invalid ArtifactTypeID".  I tried looking amongst the =
various
patches on the mdbtools site, but none of them seemed to relate to this
problem, and moreover, I couldn't see how to apply the patches.  (Yup, =
you
guessed right, not a C programmer!)

My other problem with mdbtool is one that I've mentioned on this list
before.  I was having it with version 0.5 and I still get it with the =
CVS
version.  Specifically, numbers are being truncated.  mdbexport will =
chop
off any part of the number over 99,999 (eg number going in is =
=A3310,000;
number coming out is =A310,000).  mdbschema suggests that the columns in
question are of type Currency (8).

Any ideas/solutions?  If this problem could be resolved, mdbtools would
become significantly more useful to me...

Thanks in advance; apart from these issues, the software is a great =
help!

Rob
--
Rob Pomeroy: ro...@el...
Solicitor specialising in charity law, wills, probate and trusts
Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
Telephone: 01244 319388; Fax: 01244 319333




--__--__--

_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev


End of mdbtools-dev Digest

[mdb-dev] RE: mdbtools-dev digest, Vol 1 #441 - 1 msg

[Chandra <cha...@ta...>]

-----Original Message-----
From: mdb...@li...
[mailto:mdb...@li...] On Behalf Of
mdb...@li...
Sent: 21 September 2004 04:43
To: mdb...@li...
Subject: mdbtools-dev digest, Vol 1 #441 - 1 msg

Send mdbtools-dev mailing list submissions to
	mdb...@li...

To subscribe or unsubscribe via the World Wide Web, visit
	https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
or, via email, send a message with subject or body 'help' to
	mdb...@li...

You can reach the person managing the list at
	mdb...@li...

When replying, please edit your Subject line so it is more specific
than "Re: Contents of mdbtools-dev digest..."


Today's Topics:

   1. Re: Very very weird connection error - unixODBC (Rob Pomeroy)

--__--__--

Message: 1
From: "Rob Pomeroy" <ro...@el...>
To: <mdb...@li...>
Date: Mon, 20 Sep 2004 14:41:42 +0100
Subject: [mdb-dev] Re: Very very weird connection error - unixODBC

> I am not sure, but I think this junk is a UCS-2 string...  The other
> problem is that mdbtools SQL parser still can not handle Unicode
> strings.

Okay, you're talking a LITTLE over my head there!  :-)  Is your =
suggestion
that my Linux locale settings may somehow be causing the conflict?  The
various mdbtools work okay (apart from one problem - see below), just =
not
the unixODBC connection.

> There is a patch in [1] for mdbtools which could temporally
> fix this error.
> [1] http://sourceforge.net/tracker/?group_id=3D3D2294&atid=3D3D302294

Unfortunately this link seems to send me to a page saying "Error -
ArtifactType: Invalid ArtifactTypeID".  I tried looking amongst the =
various
patches on the mdbtools site, but none of them seemed to relate to this
problem, and moreover, I couldn't see how to apply the patches.  (Yup, =
you
guessed right, not a C programmer!)

My other problem with mdbtool is one that I've mentioned on this list
before.  I was having it with version 0.5 and I still get it with the =
CVS
version.  Specifically, numbers are being truncated.  mdbexport will =
chop
off any part of the number over 99,999 (eg number going in is =
=A3310,000;
number coming out is =A310,000).  mdbschema suggests that the columns in
question are of type Currency (8).

Any ideas/solutions?  If this problem could be resolved, mdbtools would
become significantly more useful to me...

Thanks in advance; apart from these issues, the software is a great =
help!

Rob
--
Rob Pomeroy: ro...@el...
Solicitor specialising in charity law, wills, probate and trusts
Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
Telephone: 01244 319388; Fax: 01244 319333




--__--__--

_______________________________________________
mdbtools-dev mailing list
mdb...@li...
https://lists.sourceforge.net/lists/listinfo/mdbtools-dev


End of mdbtools-dev Digest

Re: [mdb-dev] Re: Very very weird connection error - unixODBC

[Michael W. <mw...@ic...>]

On Mon, Sep 20, 2004 at 02:41:42PM +0100, Rob Pomeroy wrote:
[snip]
> > There is a patch in [1] for mdbtools which could temporally
> > fix this error.
> > [1] http://sourceforge.net/tracker/?group_id=3D2294&atid=3D302294
> 
> Unfortunately this link seems to send me to a page saying
> "Error - ArtifactType: Invalid ArtifactTypeID".

The "=3D" parts of the above URL are there because of "quoted
printable" encoding.  "=3D" is an equal sign, so just replace
"=3D" with "=" whereever it appears in the URL.

That just gives the URL of the patches page, though.

> I tried looking amongst the various patches on the mdbtools
> site, but none of them seemed to relate to this problem, and
> moreover, I couldn't see how to apply the patches.  (Yup, you
> guessed right, not a C programmer!)
[snip]

I think the patch you're interested in is probably the "UTF-8
Fix" one or maybe the "UTF-8 and memo support"

Download the patch (e.g. to /tmp/utf8.diff) and then do the
following:

$ cd /path/to/mdbtools/src/libmdb
$ patch -p1 </tmp/utf8.diff

patch should say:
patching file data.c

or something similar.  If it complains about rejected hunks or
something your version of data.c is too different from the one
the patch was generated against.

If it worked without complaints, compile mdbtools as normal.

I'm afraid I can't help with the other problem.

-- 
Michael Wood <mw...@ic...>

[mdb-dev] no tuples available (unixodbc with mdbtools 0.6 pre1)

[fuchs j. <fu...@is...>]

hi,

i have compiled mdbtools 0.6 pre1 and tried to use it with unixodbc.
unixodbc seems to work because an odbc connection to mysql works great,
but when i try to use an odbc connection to a access.mdb file i always
get a "no tuples available error". i have tried to set the CURSOR at the
odbc_connect too, but with no positive results...
otherwise the database can be opened with gmdb2 so i think the problem
is within the "mdbtools odbc" library.

has anyone an idea or an solution for this, is it a bug?

all the best,
hannes

[mdb-dev] Re: Very very weird connection error - unixODBC

[Rob P. <ro...@el...>]

> I am not sure, but I think this junk is a UCS-2 string...  The other
> problem is that mdbtools SQL parser still can not handle Unicode
> strings.

Okay, you're talking a LITTLE over my head there!  :-)  Is your suggestion
that my Linux locale settings may somehow be causing the conflict?  The
various mdbtools work okay (apart from one problem - see below), just not
the unixODBC connection.

> There is a patch in [1] for mdbtools which could temporally
> fix this error.
> [1] http://sourceforge.net/tracker/?group_id=3D2294&atid=3D302294

Unfortunately this link seems to send me to a page saying "Error -
ArtifactType: Invalid ArtifactTypeID".  I tried looking amongst the various
patches on the mdbtools site, but none of them seemed to relate to this
problem, and moreover, I couldn't see how to apply the patches.  (Yup, you
guessed right, not a C programmer!)

My other problem with mdbtool is one that I've mentioned on this list
before.  I was having it with version 0.5 and I still get it with the CVS
version.  Specifically, numbers are being truncated.  mdbexport will chop
off any part of the number over 99,999 (eg number going in is £310,000;
number coming out is £10,000).  mdbschema suggests that the columns in
question are of type Currency (8).

Any ideas/solutions?  If this problem could be resolved, mdbtools would
become significantly more useful to me...

Thanks in advance; apart from these issues, the software is a great help!

Rob
--
Rob Pomeroy: ro...@el...
Solicitor specialising in charity law, wills, probate and trusts
Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
Telephone: 01244 319388; Fax: 01244 319333

[mdb-dev] output encodings

[Alex O. <ot...@je...>]

Hello all

I want to ask all about one feature, that i want to make - ability to set
output encoding for data in database.  This may very useful for many
peoples.  For example - in russia, windows use cp1251 encoding, but most of
unix'es use koi8-r encoding

-- 
With best wishes, Alex Ott
Jet Infosystems,       http://www.jetinfosoft.ru/
                       +7 (095) 411 76 01

[mdb-dev] compile fix for mdbtools

[Alex O. <ot...@je...>]

-- 
With best wishes, Alex Ott
Jet Infosystems,       http://www.jetinfosoft.ru/
                       +7 (095) 411 76 01

Re: [mdb-dev] Very very weird connection error - unixODBC

[Alexandre H. <ale...@fr...>]

Hi Rob,

I am not sure, but I think this junk is a UCS-2 string. I tried to
convert with iconv and I got=20
=E2=A5=B8=E9=83=82=E1=81=80=E7=9D=9B=EC=8C=88=EC=8E=98=EC=8E=88=EC=8A=BF=EC=
=8E=BF=EC=8E=BF=CE=AB=EC=89=80=E2=A6=88=E9=83=82=EC=89=80=E5=8E=B7. The oth=
er problem is that mdbtools SQL parser still
can not handle Unicode strings. There is a patch in [1] for mdbtools
which could temporally fix this error.

Regards,
Alexandre

[1] http://sourceforge.net/tracker/?group_id=3D2294&atid=3D302294


On Thu, 2004-09-09 at 13:15, Rob Pomeroy wrote:
> I'm getting this error (or slight variations of it):
>=20
> Warning: SQL error: x)=C2=90@=10[w=08=C3=98=C3=88=C3=BF=C2=BF=C3=BF=C3=AB=
=03@=C2=88)=C2=90@=C2=B7S, SQL state 00000 in SQLConnect in
> /srv/www/htdocs/odbc-test.php on line 3
>=20
> Anyone have ANY idea what all that junk is about?
>=20
> Thanks,
>=20
> Rob
>=20
>=20
>=20
>=20
> The setup:
>=20
> unixODBC 2.2.9 (same error with 2.2.3)
> mdbtools 0.6
> PHP 4.3.1
>=20
> --------------
> /etc/odbc.ini:
>=20
> [MatterData]
> Description =3D Lawbyte Matter tables
> Driver      =3D MDBToolsODBC
> Database    =3D /home/public/LawbyteData/matters.mdb
> Servername  =3D localhost
> UserName    =3D
> Password    =3D
> Port        =3D 5432
> --------------
>=20
>=20
> --------------
> /etc/odbcinsti.ini:
>=20
> [MDBToolsODBC]
> Description =3D MDB Tools ODBC drivers
> Driver      =3D /usr/local/lib/libmdbodbc.so.0
> Setup       =3D
> FileUsage   =3D 1
> CPTimeout   =3D
> CPReuse     =3D
> --------------
>=20
> --------------
> The script:
>=20
> <?php
>=20
> $db =3D odbc_connect("MatterData","","");
>=20
> ?>
> --------------
>=20
> --
> Rob Pomeroy: ro...@el...
> Solicitor specialising in charity law, wills, probate and trusts
> Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
> Telephone: 01244 319388; Fax: 01244 319333
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170
> Project Admins to receive an Apple iPod Mini FREE for your judgement on
> who ports your project to Linux PPC the best. Sponsored by IBM.=20
> Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>=20

[mdb-dev] Very very weird connection error - unixODBC

[Rob P. <ro...@el...>]

I'm getting this error (or slight variations of it):

Warning: SQL error: x)@[wØÈÿ¿ÿë@ˆ)@·S, SQL state 00000 in SQLConnect in
/srv/www/htdocs/odbc-test.php on line 3

Anyone have ANY idea what all that junk is about?

Thanks,

Rob




The setup:

unixODBC 2.2.9 (same error with 2.2.3)
mdbtools 0.6
PHP 4.3.1

--------------
/etc/odbc.ini:

[MatterData]
Description = Lawbyte Matter tables
Driver      = MDBToolsODBC
Database    = /home/public/LawbyteData/matters.mdb
Servername  = localhost
UserName    =
Password    =
Port        = 5432
--------------


--------------
/etc/odbcinsti.ini:

[MDBToolsODBC]
Description = MDB Tools ODBC drivers
Driver      = /usr/local/lib/libmdbodbc.so.0
Setup       =
FileUsage   = 1
CPTimeout   =
CPReuse     =
--------------

--------------
The script:

<?php

$db = odbc_connect("MatterData","","");

?>
--------------

--
Rob Pomeroy: ro...@el...
Solicitor specialising in charity law, wills, probate and trusts
Ellis & Co. Solicitors, 10 Castle Street, Chester, CH1 2DS
Telephone: 01244 319388; Fax: 01244 319333