mdbtools-dev

Re[6]: [mdb-dev] libmdbodbc

[Zachary T. W. <zw...@um...>]

Ok, scratch that last e-mail...got it. It was a permissions problem. I
guess some better error messages could be added :)

Thanks again for all your help.

-Zach

Friday, July 29, 2005, 8:03:03 PM, you wrote:

JS> --- "Zachary T. Wilson" <zw...@um...> wrote:
>> Thanks for everything...you've been a tremendous help. Got everything
>> all squared away.  Turned out it was a combination of the iodbc path
>> and the autotools being outdated.

JS> I'm glad you got that sorted out.

>> Next step is to get php interfacing with all this stuff.  Should be
>> interesting...

JS> FWIW, I have got php -> unixODBC -> mdbodbc to work in the past, so I
JS> suspect you should be able to get the php -> iodbc -> mdbodbc chain to
JS> work.

JS>  -- Jeff Smith


		
JS> ____________________________________________________
JS> Start your day with Yahoo! - make it your home page 
JS> http://www.yahoo.com/r/hs 
 

Re: Re[4]: [mdb-dev] libmdbodbc

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

--- "Zachary T. Wilson" <zw...@um...> wrote:
> Thanks for everything...you've been a tremendous help. Got everything
> all squared away.  Turned out it was a combination of the iodbc path
> and the autotools being outdated.

I'm glad you got that sorted out.

> Next step is to get php interfacing with all this stuff.  Should be
> interesting...

FWIW, I have got php -> unixODBC -> mdbodbc to work in the past, so I
suspect you should be able to get the php -> iodbc -> mdbodbc chain to
work.

 -- Jeff Smith


		
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 

Re[4]: [mdb-dev] libmdbodbc

[Zachary T. W. <zw...@um...>]

Jeff,

Thanks for everything...you've been a tremendous help. Got everything
all squared away.  Turned out it was a combination of the iodbc path
and the autotools being outdated.

Next step is to get php interfacing with all this stuff.  Should be
interesting...

-Zach

Thursday, July 28, 2005, 10:48:50 PM, you wrote:

JS> --- "Zachary T. Wilson" <zw...@um...> wrote:
>> Running ./configure --with-iodbc=/usr/local/lib ...

JS> I think in your case, you should have --with-iodbc=/usr/local (assuming the
JS> library location is /usr/local/lib/libiodbc.so).

>> ./configure: line 1191: syntax error near unexpected token `mdbtools,0.6pre1'
>> ./configure: line 1191: `AM_INIT_AUTOMAKE(mdbtools,0.6pre1)'

JS> I am guessing either the autotools
JS> (automake/autoconf/libtool) aren't properly
JS> installed, or they don't like the old AM_INIT_AUTOMAKE syntax.  You might try
JS> replacing the lines at the beginning of configure.ac
JS>   AC_INIT(src/extras/mdb-dump.c)
JS>   AM_INIT_AUTOMAKE(mdbtools,0.6pre1)
JS> with
JS>   AC_INIT(mdbtools, 0.6pre1, [mdb...@li...])
JS>   AC_CONFIG_SRCDIR(src/extras/mdb-dump.c)
JS>   AM_INIT_AUTOMAKE
JS> and rerunning the autogen.sh

>> I am getting this for the iodbc manager:
>> 
>> littlebird# iodbctest
>> iODBC Demonstration program
>> This program shows an interactive SQL processor
>> Driver Manager: 03.52.0205.0204
>> 
>> Enter ODBC connect string (? shows list): DSN=mydb
>> 1: SQLDriverConnect = [iODBC][Driver
>> Manager]/usr/local/lib/libmdbodbc: undefined
>> symbol: log10 (0) SQLSTATE=00000
>> 2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0)
>> SQLSTATE=IM003

JS> The 'undefined symbol: log10' error has to with not linking against the math library,
JS> i.e. libm.  The fix for this would be to edit
JS> src/odbc/Makefile, adding ' -lm' to the
JS> end of the 'LIBS = ' line.  Note that mdbtools in cvs no longer calls any math library
JS> functions.

JS>  -- Jeff Smith

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


JS> -------------------------------------------------------
JS> SF.Net email is Sponsored by the Better Software Conference & EXPO September
JS> 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices
JS> Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA
JS> Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf
JS> _______________________________________________
JS> mdbtools-dev mailing list
JS> mdb...@li...
JS> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: Re[2]: [mdb-dev] libmdbodbc

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

--- "Zachary T. Wilson" <zw...@um...> wrote:
> Running ./configure --with-iodbc=/usr/local/lib ...

I think in your case, you should have --with-iodbc=/usr/local (assuming the
library location is /usr/local/lib/libiodbc.so).

> ./configure: line 1191: syntax error near unexpected token `mdbtools,0.6pre1'
> ./configure: line 1191: `AM_INIT_AUTOMAKE(mdbtools,0.6pre1)'

I am guessing either the autotools (automake/autoconf/libtool) aren't properly
installed, or they don't like the old AM_INIT_AUTOMAKE syntax.  You might try
replacing the lines at the beginning of configure.ac
  AC_INIT(src/extras/mdb-dump.c)
  AM_INIT_AUTOMAKE(mdbtools,0.6pre1)
with
  AC_INIT(mdbtools, 0.6pre1, [mdb...@li...])
  AC_CONFIG_SRCDIR(src/extras/mdb-dump.c)
  AM_INIT_AUTOMAKE
and rerunning the autogen.sh

> I am getting this for the iodbc manager:
> 
> littlebird# iodbctest
> iODBC Demonstration program
> This program shows an interactive SQL processor
> Driver Manager: 03.52.0205.0204
> 
> Enter ODBC connect string (? shows list): DSN=mydb
> 1: SQLDriverConnect = [iODBC][Driver Manager]/usr/local/lib/libmdbodbc: undefined
> symbol: log10 (0) SQLSTATE=00000
> 2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0)
> SQLSTATE=IM003

The 'undefined symbol: log10' error has to with not linking against the math library,
i.e. libm.  The fix for this would be to edit src/odbc/Makefile, adding ' -lm' to the
end of the 'LIBS = ' line.  Note that mdbtools in cvs no longer calls any math library
functions.

 -- Jeff Smith

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

Re[2]: [mdb-dev] libmdbodbc

[Zachary T. W. <zw...@um...>]

Thanks Jeff...much appreciated.

Has anyone had any success using the libmdbodbc with iodbc? Is this
even possible to do?  This is being used from mdbtools-0.6pre1 because
even after trying to build the cvs version with autogen.sh i get
errors:

Running autoconf ...
Running ./configure --with-iodbc=/usr/local/lib ...
./configure: line 1191: syntax error near unexpected token `mdbtools,0.6pre1'
./configure: line 1191: `AM_INIT_AUTOMAKE(mdbtools,0.6pre1)'


I am getting this for the iodbc manager:

littlebird# iodbctest
iODBC Demonstration program
This program shows an interactive SQL processor
Driver Manager: 03.52.0205.0204

Enter ODBC connect string (? shows list): DSN=mydb
1: SQLDriverConnect = [iODBC][Driver Manager]/usr/local/lib/libmdbodbc: undefined symbol: log10 (0) SQLSTATE=00000
2: SQLDriverConnect = [iODBC][Driver Manager]Specified driver could not be loaded (0) SQLSTATE=IM003


Thanks again,

Zach

Thursday, July 28, 2005, 12:18:02 AM, you wrote:

JS> --- "Zachary T. Wilson" <zw...@um...> wrote:
>> Can anyone think of a reason that this lib would not be being built? I
>> am passing the --with-iodbc to the config script.

JS> --with-iodbc does not check any default locations, so you must specify
JS> the location.  For example, on my machine iodbc is located in /usr/local/iodbc,
JS> so I would specify --with-iodbc=/usr/local/iodbc .  I would also suggest, if
JS> you not already, to use mdbtools from CVS.  If you continue to have problems,
JS> then please provide more info on how it fails to build.

JS>  -- Jeff Smith

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

Re: Re[2]: [mdb-dev] libmdbodbc

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

--- "Zachary T. Wilson" <zw...@um...> wrote:
> Regarding the CVS files...is there no configure in the repository? How
> does one go about configuring and making the tool set in CVS?

By running the script 'autogen.sh'.  You pass it the same command-line
options you would pass to configure.  It creates the configure script
and some other needed files, then executes configure with the options
you specified.  You will need autoconf, automake, and libtool packages
installed on your machine.

 -- Jeff Smith

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

Re[2]: [mdb-dev] libmdbodbc

[Zachary T. W. <zw...@um...>]

Regarding the CVS files...is there no configure in the repository? How
does one go about configuring and making the tool set in CVS?

Thanks,

Zach

Thursday, July 28, 2005, 12:18:02 AM, you wrote:

JS> --- "Zachary T. Wilson" <zw...@um...> wrote:
>> Can anyone think of a reason that this lib would not be being built? I
>> am passing the --with-iodbc to the config script.

JS> --with-iodbc does not check any default locations, so you must specify
JS> the location.  For example, on my machine iodbc is located in /usr/local/iodbc,
JS> so I would specify --with-iodbc=/usr/local/iodbc .  I would also suggest, if
JS> you not already, to use mdbtools from CVS.  If you continue to have problems,
JS> then please provide more info on how it fails to build.

JS>  -- Jeff Smith

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

Re: [mdb-dev] libmdbodbc

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

--- "Zachary T. Wilson" <zw...@um...> wrote:
> Can anyone think of a reason that this lib would not be being built? I
> am passing the --with-iodbc to the config script.

--with-iodbc does not check any default locations, so you must specify 
the location.  For example, on my machine iodbc is located in /usr/local/iodbc,
so I would specify --with-iodbc=/usr/local/iodbc .  I would also suggest, if
you not already, to use mdbtools from CVS.  If you continue to have problems,
then please provide more info on how it fails to build.

 -- Jeff Smith

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

[mdb-dev] libmdbodbc

[Zachary T. W. <zw...@um...>]

Can anyone think of a reason that this lib would not be being built? I
am passing the --with-iodbc to the config script.

This is the only lib i need out of this whole package and I can't get
it to build it.

Also, if anyone has another suggestion for a free iodbc driver for ms
access i would be very interested.

Thank you.

-Zach

[mdb-dev] link mdbtools and GDA for OLE DB access

[Gaudet Michael-M. <MG...@fr...>]

Hello.
I am trying to migrate a .NET application from .Net framework to mono.
Accessing an "MS access" database from mono with OleDB technology implicitly uses GDA (which has an "MS access" support using MDB Tools)
(quoting http://www.mono-project.com/OLE_DB <http://www.mono-project.com/OLE_DB> )
Before to make mdbtools running with mono, I want to test mdbtools working with GDA. only.
All I want to know is the way of installing the two modules (GDA and MDBTOOLS) to make it work.
I install both from RPM's.
 
Thanks for any help.

[mdb-dev] Hacking.txt file has been copied

[Tony T. <to...@gr...>]

Folks

I see the following web sites have copies of the HACKING.txt file.  With no 
attribution.

http://www.fdrlab.com/files/accessfileformat.txt
http://www.e-tech.ca/001-AccessFileFormat.asp

Tony
-----
Tony Toews, Microsoft Access MVP
Microsoft Access Links, Hints, Tips & Accounting Systems at
    http://www.granite.ab.ca/accsmstr.htm

[mdb-dev] crash in mdb-export (64bit Linux)

[Markus N. <ne...@it...>]

Hi,

I have compiled the today's CVS version of the mdbtools
on a 64bit Linux machine. Unfortunately the following
command crashes:

mdb-export -I StazioniAutomatiche.mdb Misure =20
Segmentation fault

while it works well on a 32bit Linux machine. Both distros
are Redhat Enterprise 4 (RHEL4).

A bit of debugging (I cannot sent the file since it is 1.4GB):

strace mdb-export -I StazioniAutomatiche.mdb Misure
...
read(3, "\1\1\326\16\0\0\0\0\0\0\0\0\4\0\273\17v\0171\17\354\16"..., 4096=
) =3D 4096
mmap(NULL, 200704, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0=
) =3D 0x2a95699000
mmap(NULL, 200704, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0=
) =3D 0x2a956ca000
mmap(NULL, 200704, PROT_READ|PROT_WRITE, MAP_PRIVATE|MAP_ANONYMOUS, -1, 0=
) =3D 0x2a956fb000
fstat(3, {st_mode=3DS_IFREG|0644, st_size=3D1479475200, ...}) =3D 0
lseek(3, 73728, SEEK_SET)               =3D 73728
read(3, "\1\1V\6\20\0\0\0\0\0\0\0,\0\313\17\241\17e\0175\17\376"..., 4096=
) =3D 4096
--- SIGSEGV (Segmentation fault) @ 0 (0) ---
+++ killed by SIGSEGV +++


gdb `which mdb-export`
r -I StazioniAutomatiche.mdb Misure
Program received signal SIGSEGV, Segmentation fault.
0x000000345dc227cc in __gconv_transform_ucs2_internal () from /lib64/tls/=
libc.so.6
bt
#0  0x000000345dc227cc in __gconv_transform_ucs2_internal () from /lib64/=
tls/libc.so.6
#1  0x000000345dc1d538 in __gconv () from /lib64/tls/libc.so.6
#2  0x000000345dc1cb9b in iconv () from /lib64/tls/libc.so.6
#3  0x0000002a955663dc in mdb_unicode2ascii (mdb=3D0x502600, src=3D0x5036=
07 "=B0", slen=3D0,
    dest=3D0x5199d0 "Temperatura aria Istantanea 60 min", dlen=3D16384) a=
t iconv.c:73
#4  0x0000002a9555ff47 in mdb_col_to_string (mdb=3D0x502600, buf=3D0x5026=
14, start=3D4047, datatype=3D10,
    size=3D36) at data.c:848
#5  0x0000002a9555e83b in mdb_xfer_bound_data (mdb=3D0x502600, start=3D40=
47, col=3D0x515690, len=3D36)
    at data.c:222
#6  0x0000002a9555eadd in _mdb_attempt_bind (mdb=3D0x502600, col=3D0x5156=
90, isnull=3D0 '\0',
    offset=3D4047, len=3D36) at data.c:306
#7  0x0000002a9555ea2f in mdb_read_row (table=3D0x515210, row=3D0) at dat=
a.c:284
#8  0x0000002a9555ee6e in mdb_fetch_row (table=3D0x515210) at data.c:402
#9  0x000000000040121f in main (argc=3D4, argv=3D0x7fbffff808) at mdb-exp=
ort.c:157

(gdb) bt full
...
    is_fixed =3D 53 '5', colnum =3D 0, offset =3D 4196064}, {value =3D 0x=
515610, siz =3D 1569807600,
    start =3D 52, is_null =3D 48 '0', is_fixed =3D 246 '=F6', colnum =3D =
127, offset =3D -1073744400}, {
    value =3D 0x93635d7, siz =3D 4196064, start =3D 0, is_null =3D 0 '\0'=
, is_fixed =3D 0 '\0', colnum =3D 0,
    offset =3D 1568700462}, {value =3D 0x0, siz =3D 1, start =3D 0, is_nu=
ll =3D 0 '\0', is_fixed =3D 0 '\0',
    colnum =3D 0, offset =3D -1789540033}, {value =3D 0x1000, siz =3D 737=
28, start =3D 0,
    is_null =3D 2 '\002', is_fixed =3D 9 '\t', colnum =3D 0, offset =3D 1=
3795360}, {value =3D 0x1,
    siz =3D 33188, start =3D 1338, is_null =3D 204 '=CC', is_fixed =3D 0 =
'\0', colnum =3D 0, offset =3D 0}, {
    value =3D 0x582f0000, siz =3D 4096, start =3D 0, is_null =3D 144 '\22=
0', is_fixed =3D 34 '"',
    colnum =3D 0, offset =3D 1121438862}, {value =3D 0x325bbbe9, siz =3D =
1111569942, start =3D 0,
    is_null =3D 0 '\0', is_fixed =3D 0 '\0', colnum =3D 0, offset =3D 112=
1152771}, {value =3D 0x0, siz =3D 0,
    start =3D 0, is_null =3D 0 '\0', is_fixed =3D 0 '\0', colnum =3D 0, o=
ffset =3D 0}, {value =3D 0x1000,
    siz =3D 18, start =3D 0, is_null =3D 20 '\024', is_fixed =3D 38 '&', =
colnum =3D 0, offset =3D 5252608}, {
    value =3D 0x7fbffff630, siz =3D -1789540359, start =3D 42, is_null =3D=
 0 '\0', is_fixed =3D 16 '\020',
    colnum =3D 0, offset =3D 4096}}
        num_fields =3D 3
#8  0x0000002a9555ee6e in mdb_fetch_row (table=3D0x515210) at data.c:402
        mdb =3D (MdbHandle *) 0x502600
        fmt =3D (MdbFormatConstants *) 0x2a9566a780
        rows =3D 44
        rc =3D 5329424
        pg =3D 0
#9  0x000000000040121f in main (argc=3D4, argv=3D0x7fbffff808) at mdb-exp=
ort.c:157
        j =3D 3
        mdb =3D (MdbHandle *) 0x502600
        table =3D (MdbTableDef *) 0x515210
        col =3D (MdbColumn *) 0x0
        bound_values =3D (char **) 0x517290
        bound_lens =3D (int *) 0x5159b0
        delimiter =3D 0x502010 ","
        row_delimiter =3D 0x502030 "\n"
        header_row =3D 0 '\0'
        quote_text =3D 1 '\001'
        insert_statements =3D 1 '\001'
        sanitize =3D 0 '\0'
        opt =3D -1


Using 'ddd' it dies in
mdb-export.c:157
 while(mdb_fetch_row(table)) {

Do you have any ideas? I'm not sure how to continue
debugging... The bug seems to be in=20
mdbtools/src/libmdb/data.c
Maybe related to guint32? (sorry, just guessing).

Thanks anyway for maintaining the mdbtools!

Markus

--=20
Markus Neteler     <neteler itc it>       http://mpa.itc.it
ITC-irst -  Centro per la Ricerca Scientifica e Tecnologica
MPBA - Predictive Models for Biol. & Environ. Data Analysis
Via Sommarive, 18        -       38050 Povo (Trento), Italy

[mdb-dev] case-insensitive search

[Dmitry V. <dm...@rs...>]

Hello!

If someone interesting in case-insensitive search with mdb-tools, you can apply the patch attached.
After this mdb-tools will rely on environment's MDBNCASESEARCH variable, and if it is set, then
search will become case-insesitive according to current locale.

For mdb's with russian letters folowing command will be OK:

$ export MDBNCASESEARCH=1 LC_ALL=ru_RU.CP1251 MDB_ICONV=CP1251

(or LC_ALL=ru_RU.KOI8R MDB_ICONV=KOI8R if you need to output data in KOI8 codepage)

-- 
 Dmitry                          mailto:dm...@rs...

Re: [mdb-dev] mdb-sql problem

[Dmitry V. <dm...@rs...>]

--- Dmitry Vereschaka <dm...@rs...> wrote:

DV> There is a problem with mdb-sql and my mdb file - mdb-sql refers to wrong column while
DV> executing sql "select PP_Info from PlatPor where PP_Info like '%q%'".
DV> If you look to output below or if you open this mdb file with ms access, you will find
DV> that mdb-sql
DV> actually compares 'Rec_INN' field, not 'PP_Info' with '%q%'.
DV>
DV> It is very strange, because mdb-export produces correct column name bindings with this
DV> file (output
DV> also shown below)
DV>
DV> If someone interested in solving this problem, please contact me via email and I'll
DV> send you this
DV> broken mdb file (400K zipped).

I've resolved this problem (see patch1 attached).

Also I've added support for datetime type in SQL's WHERE (see patch2 attached), unfortunately, it is
really slow (every row's datetime field is converted to string and comparing with search parameter
as string instead of converting search parameter to double once and comparing it with row's datetime
field as double. So, the search parameter should be in 'YYYY-MM-DD HH:MM:SS' format.

-- 
 Dmitry                          mailto:dm...@rs...

[mdb-dev] pyodb, mdbtools, unixodbc and alternatives?

[J L. <jl...@dr...>]

I have compiled mbdtools from CVS on 07.11.2005 and have it functioning 
with unixODBC on Gentoo. I say functioning as isql provided by unixODBC 
functions correctly with my database. I found pyodb for python and 
installed it and have it functioning in part. The problem is when I try 
to fetch a query result, python hangs with no error and 99% CPU 
utilization. I do not know if this is a problem with pyodb, mdbtools or 
unixODBC. I was wondering if anyone is using a similar configuration to 
access a Jet4 database from python. Does anyone know of a better way to 
do this? I know mxODBC but I am trying to stay away from commercial.

Re: [mdb-dev] problems with JET4 and nonASCI characters

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

--- Tomek Kozinski <ko...@sl...> wrote:
> I have problems with mdbtools 0.5 and 0.6.pre1. Selects made by mdb-sql and 
> dumps by mdb-exports  or mdb-array have same imperfection. All strings 
> containing polish specific characters are trimmed. First appearance of 
> nonASCII character terminates string. My mdb database is produced by MSAccess 
> 2000 and mdb-ver identify it as JET4.

I expect you would have much better luck using mdbtools from CVS.  Several
improvements were made in this area around Nov/Dec of last year.

 -- Jeff Smith


		
____________________________________________________
Sell on Yahoo! Auctions – no fees. Bid on great items.  
http://auctions.yahoo.com/

[mdb-dev] problems with JET4 and nonASCI characters

[Tomek K. <ko...@sl...>]

EHLO.
I am new on the list. At first i want to thank all developers for their wor=
k.

I have problems with mdbtools 0.5 and 0.6.pre1. Selects made by mdb-sql and=
=20
dumps by mdb-exports  or mdb-array have same imperfection. All strings=20
containing polish specific characters are trimmed. First appearance of=20
nonASCII character terminates string. My mdb database is produced by MSAcce=
ss=20
2000 and mdb-ver identify it as JET4.

I expect:	123, =E2=80=9CEl=C5=BCbieta=E2=80=9D	, =E2=80=9CKwa=C5=9Bna=E2=80=
=9D
I get:	123, =E2=80=9CEl=E2=80=9D,		, =E2=80=9CKwa=E2=80=9D =20

In mdb-hexdump there is something in the places where I expect polis-specyf=
ic=20
characters
I expect:  =20
=E2=80=9Cdolegliwo=C5=9Bci=E2=80=9D
hexdump:
034270  64 6f 6c 65 67 6c 69 77 6f 00 5b 01 00 63 69 20   |dolegliwo.[..ci |


=2D-=20
 )/    pozdrowienia
 Y\_/
  /~\

Re: [mdb-dev] driver Access under Linux

[<md...@kn...>]

Am Freitag, 8. Juli 2005 17:54 schrieb Elena Palanca:
> I have seen that I could use mdbtools but to use this I need also UnixOdbc
> provided by Easysoft. UnixOdbc are not free. I would like to know if there
> is a free way to solve this problem without paying anything.
UnixODBC is under GPL/LGPL. See http://www.unixodbc.org

Horst

Re: [mdb-dev] driver Access under Linux

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

I could have sworn that the last time i was using a unix odbc layer, i
didn't pay anything for it. technically a PITA to use, but it sort of
worked. For you to access a remote ODBC source could be the cost part
I'm guessing. If its just an access database, put it on a network
share I'd say is the only other option if unixodbc is unable to do it
freely.

On 7/9/05, Elena Palanca <pa...@di...> wrote:
> =20
> Hi,=20
> I have the following problem, I hope someone can help me.=20
> I have a web application under tomcat 4.1.27 on a server Linux and=20
> this application must use an Access Database that is on a  Windows machin=
e
> (in the LAN).=20
> I have seen that I could use mdbtools but to use this I need also UnixOdb=
c
> provided=20
> by Easysoft. UnixOdbc are not free. I would like to know if there is a fr=
ee
> way to solve this problem without paying anything.=20
>  =20
> Thanks,=20
> Elena

[mdb-dev] driver Access under Linux

[Elena P. <pa...@di...>]

Hi,
I have the following problem, I hope someone can help me.
I have a web application under tomcat 4.1.27 on a server Linux and=20
this application must use an Access Database that is on a  Windows =
machine (in the LAN).
I have seen that I could use mdbtools but to use this I need also =
UnixOdbc provided=20
by Easysoft. UnixOdbc are not free. I would like to know if there is a =
free way to solve this problem without paying anything.

Thanks,
Elena

Re: [mdb-dev] 0.6pre1 gmdb2 doesn't compile

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

--- Servio Tulio Pires Amarante <ser...@si...> wrote:
> In Mandriva 2005LEI can't compile 0.6pre1. The error: 
> 
>  -c -o table_export.o `test -f 'table_export.c' || echo './'`table_export.c; \
> then mv -f ".deps/table_export.Tpo" ".deps/table_export.Po"; \
> else rm -f ".deps/table_export.Tpo"; exit 1; \
> fi
> table_export.c:237: error: conflicting types for 
> 'gmdb_table_export_populate_dialog'
> table_export.c:233: error: previous implicit declaration of 
> 'gmdb_table_export_populate_dialog' was here
> make[3]: ** [table_export.o] Erro 1
> make[3]: Leaving directory `/usr/local/mdbtools-0.6pre1/src/gmdb2'
> make[2]: ** [all-recursive] Erro 1
> make[2]: Leaving directory `/usr/local/mdbtools-0.6pre1/src/gmdb2'
> make[1]: ** [all-recursive] Erro 1
> make[1]: Leaving directory `/usr/local/mdbtools-0.6pre1/src'
> make: ** [all-recursive] Erro 1

This was fixed in CVS back in November.

 -- Thanks
 -- Jeff Smith

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

[mdb-dev] 0.6pre1 gmdb2 doesn't compile

[Servio T. P. A. <ser...@si...>]

In Mandriva 2005LEI can't compile 0.6pre1. The error: 

 -c -o table_export.o `test -f 'table_export.c' || echo './'`table_export.c; \
then mv -f ".deps/table_export.Tpo" ".deps/table_export.Po"; \
else rm -f ".deps/table_export.Tpo"; exit 1; \
fi
table_export.c:237: error: conflicting types for 
'gmdb_table_export_populate_dialog'
table_export.c:233: error: previous implicit declaration of 
'gmdb_table_export_populate_dialog' was here
make[3]: ** [table_export.o] Erro 1
make[3]: Leaving directory `/usr/local/mdbtools-0.6pre1/src/gmdb2'
make[2]: ** [all-recursive] Erro 1
make[2]: Leaving directory `/usr/local/mdbtools-0.6pre1/src/gmdb2'
make[1]: ** [all-recursive] Erro 1
make[1]: Leaving directory `/usr/local/mdbtools-0.6pre1/src'
make: ** [all-recursive] Erro 1

Re: [mdb-dev] mdbtools doesn't compile with gcc4

[Dmitry V. <dm...@rs...>]

Hi, neoclust.

n> /bin/sh ../../libtool --mode=link gcc  -g -O2 -DSQL -DUNIXODBC   -o
n> libmdbodbc.la -rpath /usr/local/lib  odbc.lo 
n> connectparams.lo  ../sql/mdbsql.lo  ../sql/parser.lo  ../sql/lexer.lo  ../libmdb/backend.lo 
n> ../libmdb/index.lo  ../libmdb/money.lo  ../libmdb/catalog.lo  ../libmdb/kkd.lo 
n> ../libmdb/sargs.lo  ../libmdb/data.lo  ../libmdb/like.lo  ../libmdb/table.lo  ../libmdb/dump.lo 
n> ../libmdb/file.lo  ../libmdb/mem.lo  ../libmdb/map.lo  ../libmdb/props.lo  ../libmdb/worktable.lo
n> ../libmdb/options.lo  ../libmdb/write.lo  ../libmdb/stats.lo  ../libmdb/iconv.lo 
n> -lfl -lglib-2.0   -Lyes/lib -lodbcinst
n> ../../libtool: line 1578: cd: yes/lib: No such file or directory
n> libtool: link: cannot determine absolute directory name of `yes/lib'
n> make[2]: *** [libmdbodbc.la] Error 1
n> make[2]: Leaving directory `/home/neoclust/test/mdbtools-0.6pre1/src/odbc'
n> make[1]: *** [all-recursive] Error 1
n> make[1]: Leaving directory `/home/neoclust/test/mdbtools-0.6pre1/src'
n> make: *** [all-recursive] Error 1


n> can someone help me ? 

this is not gcc4 error, you should re-run configure with --with-unixodbc=path instead --with-unixodbc

-- 
 Dmitry                          mailto:dm...@rs...

[mdb-dev] mdbtools doesn't compile with gcc4

[neoclust <neo...@ma...>]

Hi,

I pass this error with this:

--- src/libmdb/backend.c--         2004-06-11 15:56:41.000000000 +0200
+++ src/libmdb/backend.c        2005-07-05 20:59:51.000000000 +0200
@@ -28,7 +28,7 @@
 #endif

 static int is_init;
-static GHashTable *mdb_backends;
+GHashTable *mdb_backends;

    /*    Access data types */
 static MdbBackendType mdb_access_types[] = {


and now i have:


/bin/sh ../../libtool --mode=link gcc  -g -O2 -DSQL -DUNIXODBC   -o 
libmdbodbc.la -rpath /usr/local/lib  odbc.lo 
connectparams.lo  ../sql/mdbsql.lo  ../sql/parser.lo  ../sql/lexer.lo  ../libmdb/backend.lo  ../libmdb/index.lo  ../libmdb/money.lo  ../libmdb/catalog.lo  ../libmdb/kkd.lo  ../libmdb/sargs.lo  ../libmdb/data.lo  ../libmdb/like.lo  ../libmdb/table.lo  ../libmdb/dump.lo  ../libmdb/file.lo  ../libmdb/mem.lo  ../libmdb/map.lo  ../libmdb/props.lo  ../libmdb/worktable.lo  ../libmdb/options.lo  ../libmdb/write.lo  ../libmdb/stats.lo  ../libmdb/iconv.lo 
-lfl -lglib-2.0   -Lyes/lib -lodbcinst
../../libtool: line 1578: cd: yes/lib: No such file or directory
libtool: link: cannot determine absolute directory name of `yes/lib'
make[2]: *** [libmdbodbc.la] Error 1
make[2]: Leaving directory `/home/neoclust/test/mdbtools-0.6pre1/src/odbc'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/home/neoclust/test/mdbtools-0.6pre1/src'
make: *** [all-recursive] Error 1


can someone help me ? 

thanks in advance
-- 
N'envoyez que des documents avec des formats ouverts, comme 
http://fr.openoffice.org, http://koffice.kde.org/

[mdb-dev] mdb-sql problem

[Dmitry V. <dm...@rs...>]

Hi!

There is a problem with mdb-sql and my mdb file - mdb-sql refers to wrong column while
executing sql "select PP_Info from PlatPor where PP_Info like '%q%'".
If you look to output below or if you open this mdb file with ms access, you will find that mdb-sql
actually compares 'Rec_INN' field, not 'PP_Info' with '%q%'.

It is very strange, because mdb-export produces correct column name bindings with this file (output
also shown below)

If someone interested in solving this problem, please contact me via email and I'll send you this
broken mdb file (400K zipped).

[dmitry@proxy paylist]$ export MDBOPTS=debug_like
[dmitry@proxy paylist]$ mdb-sql pp.mdb
1 => select PP_Info from PlatPor where PP_Info like '%q%'
2 => go

+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|PP_Info                                                                                                                                                                                                                                                                                                                                                                                                         |
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
comparing dfg and %q%
comparing dfg and q%
comparing fg and q%
comparing g and q%
comparing  and q%
comparing dfg and %q%
comparing dfg and q%
comparing fg and q%
comparing g and q%
comparing  and q%
comparing dfg and %q%
comparing dfg and q%
comparing fg and q%
comparing g and q%
comparing  and q%
+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+


[dmitry@proxy paylist]$ mdb-export pp.mdb PlatPor
ID,Vyp_Date,Sum,PP_Info,IDRec,IDRecCat,Rec_Name,Rec_INN,WWW,PP_Date,DocIdFrom1C,PP_No
5956,"12/30/99 00:00:00",33,"eee","001973","000001","nnn","dfg",1,"06/30/05 00:00:00",19071,"00001275"
5957,"12/30/99 00:00:00",22,"www","001974","000023","bbb","dfg",0,"07/01/05 00:00:00",19072,"00001276"
5958,"12/30/99 00:00:00",11,"qqq","001803","000012","vvv","dfg",0,"07/02/05 00:00:00",19075,"00001277"

-- 
With Best Regards,
 Dmitry                          mailto:dm...@rs...