mdbtools-dev

[mdb-dev] source to java port

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

While I await cvs write access I have uploaded the current code as a bug 
titleled Java Port:
https://sourceforge.net/tracker/index.php?func=detail&aid=960527&group_id=2294&atid=102294

_________________________________________________________________
Best Restaurant Giveaway Ever! Vote for your favorites for a chance to win 
$1 million! http://local.msn.com/special/giveaway.asp

[mdb-dev] java port & cvs access

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

I ported mdbtools to java so that java programs can easily use it without 
the hassel of setting up mdbtools, unix odbc, mdb-tools odbc driver, 
jdbc-odbc.  instead a pure java jdbc driver may be used that does not 
require setting up.

For more info visit: 
http://sourceforge.net/forum/forum.php?thread_id=1068644&forum_id=6688

I'd like to contribute this code back to the project. Could someone set me 
up with a module in cvs with write access?  or is there someone willing to 
let me send changes to for them to check in?

Also could someone add a section to the front page announcing the java port 
and how to obtain it?

Calvin

_________________________________________________________________
Best Restaurant Giveaway Ever! Vote for your favorites for a chance to win 
$1 million! http://local.msn.com/special/giveaway.asp

[mdb-dev] MS Project mdb files revisited.

[Frank G. <fdg...@ya...>]

Hi all,

   I finally attached a MS Project mdb files to the
bug (896696) that I posted a while ago.  It seems
sourceforge requires a file be less than 256K and this
one was about 260K.  I've gzipped the file, and it
worked this time.  Anyway, could somebody test out
this file on their system and see if they get the same
error.  Running mdb-export to extract the MSP_TASKS
table would be great.  I would appreciate any help on
this matter.

-Frank Guarino

=====
Frank D. Guarino
fdg...@ya...


	
		
__________________________________
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861 

Re: [mdb-dev] mdb-tables returns nothing

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

Do you have a smaller example that exhibits this problem?  Something you can
give a link to so others can help analyze this.

 -- Jeff Smith


--- in...@al... wrote:
> Hi there, I've just grabbed the latest CVS sources for mdb-tools and tried again to 
> access a rather large (150 meg) .mdb file. This time though, instead of coming up with 
> errors, I simply get nothing. mdb-tables returns a blank, (I know the names of the
> tables 
> in the database) but when I try to execute mdb-export I also get nothing. It simply
> prints 
> a newline and returns me to the prompt. The database is a JET3 (mdb-ver finds this ok) 
> but I cannot get ANY information out of it. At least in the previous version I tried I
> got an 
> error. ;) 
> 
> Anyone else seen this? Any ideas?
> 
> John Finlay
> Albertarooms Webmaster
> www.albertarooms.com
> Phone: (403) 272-7858
> Cell: (403) 333-1184
> Fax: (403) 272-4597 attn: albertarooms
> Email: web...@al...


	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

[mdb-dev] mdb-tables returns nothing

[<in...@al...>]

Hi there, I've just grabbed the latest CVS sources for mdb-tools and tried again to 
access a rather large (150 meg) .mdb file. This time though, instead of coming up with 
errors, I simply get nothing. mdb-tables returns a blank, (I know the names of the tables 
in the database) but when I try to execute mdb-export I also get nothing. It simply prints 
a newline and returns me to the prompt. The database is a JET3 (mdb-ver finds this ok) 
but I cannot get ANY information out of it. At least in the previous version I tried I got an 
error. ;) 

Anyone else seen this? Any ideas?

John Finlay
Albertarooms Webmaster
www.albertarooms.com
Phone: (403) 272-7858
Cell: (403) 333-1184
Fax: (403) 272-4597 attn: albertarooms
Email: web...@al...

[mdb-dev] mdb-export to csv file from Access

[LABAT F. <lab...@ma...>]

Hi,

I m trying to export Ms Access (Jet3) data to .csv file (that s work) but (as one) i not able to read time to the good format.

sample : in Access a row contains time like 06:52:49 but when i read the csv file i see 12/13/01 20:45:52 
                and for 06:40:49 i read in the csv file the same thing 12/13/01 20:45:52 i dont understand.

Anyone know the problem

Thanks

Sisco

Re: [mdb-dev] Re: mdbtools pkgconfig file(s) ...

[<br...@br...>]

Ack, I always forget to "cvs add"....argh.  I'll take care of it when
I get home this afternoon.

A difficult piece of the API pie is that I am also working on adding
support for MSDE files, and my thought is to have a two layer API.  At
the top layer is everything most people need such as open, close,
fetch, sargs.  Anything one of the util program would normally do.  
This will be the same API for MDB and MSDE.

Then there are additonal functions that may be MDB specific.  I'm not
sure how I want to deal with this yet, it'll probably become more
obvious as I do more work on MSDE.

On Tue, 4 May 2004 05:04:53 -0700 (PDT), Jeff Smith wrote:

> 
> Brian,
>   With regards to Michael's patch, it appears that the changes to
> existing
> files were applied, but the new files were never added: libmdb.pc.in
> and
> libmdbsql.pc.in.  I would do it, but I already deleted the patch from
> my
> queue when you said it was applied.
>   As for the API stabilizing: The first step is figuring out what the
> current API is, i.e. declaring what is public/private.  Of course,
you
> have
> already begun this process with your block comments in the code.  As
> someone
> who has waded through my fair share of undocument source code, I
> applaud
> this effort.
> 
> Michael,
>   Thanks for the patch.  It is greatly appreciated.
> 
>  -- Jeff Smith
> 
> 
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Win a $20,000 Career Makeover at Yahoo! HotJobs  
> http://hotjobs.sweepstakes.yahoo.com/careermakeover 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle
> 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE. 
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] Re: mdbtools pkgconfig file(s) ...

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

Brian,
  With regards to Michael's patch, it appears that the changes to existing
files were applied, but the new files were never added: libmdb.pc.in and
libmdbsql.pc.in.  I would do it, but I already deleted the patch from my
queue when you said it was applied.
  As for the API stabilizing: The first step is figuring out what the
current API is, i.e. declaring what is public/private.  Of course, you have
already begun this process with your block comments in the code.  As someone
who has waded through my fair share of undocument source code, I applaud
this effort.

Michael,
  Thanks for the patch.  It is greatly appreciated.

 -- Jeff Smith


	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

Re: [mdb-dev] mdbtools and forms

[Lee L. <le...@ri...>]

>I'm not working on it currently, but here is what I have found out
>about it.  The form data is stored as an OLE object using the Lv (i
>think) column in MSysObjects.  The LvProp column has some useful data
>in it too (form name and some other stuff).  I was hoping to use
>libgsf to extract the data from Lv, but I haven't been able to
>corollate the data to anything that libgsf will handle.  It may yet
>yield to further exploring.
>
>I would recommend using the "prole" program, but it seems hopelessly
>broken at the moment.  I hope to fix it this week. The mdb-prop
>program will dump some of the LvProp stuff.  You'll need a current CVS
>copy though to pull the forms data.

I grabbed the CVS copy last week, but was unable to get it to compile, seemed to me like autogen.sh was not generating the Makefiles properly.

The 0.5 release however I have re-compiled to allow the gmdb2 gui to list the MSysObjects table.  However, when I click 'Data' button to list the data in the table, it segfaults in a memory allocation attempt while adding items to the clist array.

Let me know when you fix it, so I can try again.

Lee

Re: [mdb-dev] Warning: SQL error: <«ò@lŒò@¸, SQL state 00000 in SQLConnect

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

If you know how, please try the version out of cvs.
If you don't want to mess with that, what has helped in some cases
is to move that block from /etc/odbc.ini into $HOME/.odbc.ini
Sometime in the near future, Brian will likely release a new version.

 -- Jeff Smith


--- LABAT Francois <lab...@ma...> wrote:
> Hi,
> 
> I have this error (Warning: SQL error: <«ò@lŒò@¸
, SQL state 00000 in SQLConnect)
> when i try to access my database (Jet3) under linux.
> 
> My odbc.ini in (/etc/)
> 
> [basegc]
> Description = Microsoft Access Database of Dogs
> Driver = MDBToolsODBC
> Database = /home/sisco/basegc.mdb
> Servername = 127.0.0.1
> UserName =
> Password =
> port = 5432
> 
> I ve installed mdbtools (0.5 version) from
> http://bryanmills.net:8086/archives/000099.html. I don't understand what's matter.
> 
> Thanks for Help
> 
> Sisco
> 



	
		
__________________________________
Do you Yahoo!?
Win a $20,000 Career Makeover at Yahoo! HotJobs  
http://hotjobs.sweepstakes.yahoo.com/careermakeover 

[mdb-dev] =?iso-8859-1?B?V2FybmluZzogU1FMIGVycm9yOiA8q/JAbIzyQLgBGQgsIFNRTCBzdGF0ZSAwMDAwMCBpbiBTUUxDb25uZWN0?=

[LABAT F. <lab...@ma...>]

SGksDQoNCkkgaGF2ZSB0aGlzIGVycm9yIChXYXJuaW5nOiBTUUwgZXJyb3I6IDyr8kBsjPJAuAEZ
CCwgU1FMIHN0YXRlIDAwMDAwIGluIFNRTENvbm5lY3QpIHdoZW4gaSB0cnkgdG8gYWNjZXNzIG15
IGRhdGFiYXNlIChKZXQzKSB1bmRlciBsaW51eC4NCg0KTXkgb2RiYy5pbmkgaW4gKC9ldGMvKQ0K
DQpbYmFzZWdjXQ0KRGVzY3JpcHRpb24gPSBNaWNyb3NvZnQgQWNjZXNzIERhdGFiYXNlIG9mIERv
Z3MNCkRyaXZlciA9IE1EQlRvb2xzT0RCQw0KRGF0YWJhc2UgPSAvaG9tZS9zaXNjby9iYXNlZ2Mu
bWRiDQpTZXJ2ZXJuYW1lID0gMTI3LjAuMC4xDQpVc2VyTmFtZSA9DQpQYXNzd29yZCA9DQpwb3J0
ID0gNTQzMg0KDQpJIHZlIGluc3RhbGxlZCBtZGJ0b29scyAoMC41IHZlcnNpb24pIGZyb20gaHR0
cDovL2JyeWFubWlsbHMubmV0OjgwODYvYXJjaGl2ZXMvMDAwMDk5Lmh0bWwuIEkgZG9uJ3QgdW5k
ZXJzdGFuZCB3aGF0J3MgbWF0dGVyLg0KDQpUaGFua3MgZm9yIEhlbHANCg0KU2lzY28NCg==

Re: [mdb-dev] mdb_alloc_handle / mdb_free_handle

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

Just FYI, these changes are now in CVS.

Note to anyone that still has a reference to mdb_free_handle: it needs to be removed or
(more likely) replaced with mdb_close.

 -- Jeff S

--- br...@br... wrote:
> I have no problem with this I guess. 
> 
> On Sun, 25 Apr 2004 13:00:01 -0700 (PDT), Jeff Smith wrote:
> 
> > 
> > At this point, I believe I can easily integrate the functionality of
> > mdb_alloc_handle and
> > mdb_free_handle into mdb_open, mdb_clone_handle, and mdb_close.  I
> > feel that
> > consolidating the functionality of these two layers into one would be
> > a very good thing.
> > I wanted to clear this change through the list though.  Sound good?
> > 
> >  -- Jeff Smith


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

[mdb-dev] Some progress on deleted records

[Michael B. <mi...@aa...>]

Hi list, got the tools compiled (finally) with the help of a lexer fix I 
found in the list archives (Jeff's I think?) and the file can be read.
Unfortunately, I have discovered that a couple of the fields are large 
objects (Images I think, judging by the program). The mdb-export seems 
to just output these as large numbers, but not large enough to be the 
whole image. Do binary objects get included in an export or is that just 
silly because of it being a text file. Is there a way to get the data 
into some other format? I seem to remember reading that you could export 
into other database formats. Probably any of them would do as long as 
the binary data is all there.
Also, I am getting a segfault after only a few dozen rows. I include the 
output below in case it helps anyone. the problem is:

Unhandled ole field flags = ffff
Segmentation fault


mdb-schema outputs the following for the table in question:

DROP TABLE Exam;
CREATE TABLE Exam
 (
        ID                      Long Integer (4),
        Patient_ID                      Text (40),
        TestType                        Text (100),
        TemplateName                    DateTime (Short) (8),
        Date                    Text (2),
        Duration                        Single (4),
        Eye                     Single (4),
        LensSphere                      Single (4),
        LensCylinder                    Memo/Hyperlink,
        LensAxis                        OLE,
        Comments                        Long Integer (4),
        Data                    OLE,
        AnnotationData                  Long Integer (4)

);


mdb-export outputs:

ID,Patient_ID,TestType,TemplateName,Date,Duration,Eye,LensSphere,LensCylinder,LensAxis,Comments,Data,AnnotationData
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
<snip: many more the same>
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
,"","","","",,,,"",,,,-805253120
Unhandled ole field flags = ffff
,"","","","",,,,"",,,,
Reading LVAL page 0002eb
row num 0 row start 10 row stop 4095
row num 10 row start 256 row stop 256
Segmentation fault

Any ideas? I realise that since I have modified that skip-deleted flag, that I may be reading invalid data and really pushing sh*t uphill, but I  thought there might be a way to get it to just skip the busted rows because there are another 3000-4000 rows to come that may have good data in them. (That's if I can get the binary data out too!)

Thank you for your patience and time, I'll donate some of the money I get from this to the project if I'm successful. 
-- 
Have a Nice Day!
Mike

Re: [mdb-dev] Re: mdbtools-dev digest, Vol 1 #370 - 2 msgs

[Mike <mi...@aa...>]

br...@br... wrote:

>Hi,
>
>There is indeed a "deletion flag" for rows in an MDB database. 
>However, we've always approached it from the opposite end of trying
>not to read them.  I'd be curious to see how this works out, I don't
>quite fully understand the process by which Jet deletes rows, I just
>know how to deal with them once they are there.
>
>You may try this:
>
>bring down the source code for mdbtools.
>in the file src/libmdb/mem.c find the function mdb_alloc_tabledef()
>after the memset add:
>
>table->noskip_del = 1;
>
>now, you'll also need to turn on the old brute force reads, define the
>variable SLOW_READ
>
>export CFLAGS="-D SLOW_READ"
>./configure
>make
>
>now you should have a copy of mdbtools that will read any page that
>appears to be owned by the table and will read deleted rows on those
>pages.
>
>Good Luck,
>
>Brian
>
>  
>
Going great untill part way through the make, I got...

/bin/sh ../../libtool --mode=link gcc  -g -O2 -DSQL   -o mdb-sql  
mdb-sql.o ../libmdb/libmdb.la ../sql/libmdbsql.la -lglib-2.0    -lfl
gcc -g -O2 -DSQL -o .libs/mdb-sql mdb-sql.o  ../libmdb/.libs/libmdb.so 
../sql/.libs/libmdbsql.so /usr/lib/libglib-2.0.so -lfl -Wl,--rpath 
-Wl,/usr/local/lib
../sql/.libs/libmdbsql.so: undefined reference to `yylex'
../sql/.libs/libmdbsql.so: undefined reference to `yyerror'
collect2: ld returned 1 exit status
make[2]: *** [mdb-sql] Error 1
make[2]: Leaving directory `/tmp/mdbtools-0.5/src/util'
make[1]: *** [all-recursive] Error 1
make[1]: Leaving directory `/tmp/mdbtools-0.5/src'
make: *** [all-recursive] Error 1

Looking on the web, people seemed to think it was a bison or flex 
problem. Have installed the latest of both, but no change.
Way outside my sphere of knowledge, can anyone suggest a fix?
--
Have a Nice Day!
Mike

Re: [mdb-dev] Re: mdbtools-dev digest, Vol 1 #370 - 2 msgs

[<br...@br...>]

Hi,

There is indeed a "deletion flag" for rows in an MDB database. 
However, we've always approached it from the opposite end of trying
not to read them.  I'd be curious to see how this works out, I don't
quite fully understand the process by which Jet deletes rows, I just
know how to deal with them once they are there.

You may try this:

bring down the source code for mdbtools.
in the file src/libmdb/mem.c find the function mdb_alloc_tabledef()
after the memset add:

table->noskip_del = 1;

now, you'll also need to turn on the old brute force reads, define the
variable SLOW_READ

export CFLAGS="-D SLOW_READ"
./configure
make

now you should have a copy of mdbtools that will read any page that
appears to be owned by the table and will read deleted rows on those
pages.

Good Luck,

Brian

On Thu, 29 Apr 2004 16:38:20 +1000, Michael Bryce wrote:

> 
> Hi people! I am a little off topic here so apologies in advance, but 
> this list seems to be the only place I can find people who
understand 
> the inside of an mdb file.
> My problem:
> I have a client who is running an application with data in a couple
of 
> mdb files. A great many patient result records have inadvertently
been 
> deleted (due to a cascade delete setting in the relationship between 
> tables I think). Is there a way for me to use mdb tools (or anything 
> else you know of) to undelete records?
> I think I remember someone here saying that records are not actually 
> deleted, but only marked as such. If that is so, is this reversible?
> Can 
> I just somehow unmark them or are there other complications? I am 
> willing to export them all to text and find some other way to import 
> them back in again if there are index issues or other such side
effect 
> from a delete. Perhaps I could export all deleted records in a given 
> table to a text file and fix them there?
> Any help greatly appreciated because they don't have a backup! 
> (Complicated and sad, sad story.)
> -- 
> 
> Have a Nice Day!
> Mike
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email is sponsored by: Oracle 10g
> Get certified on the hottest thing ever to hit the market... Oracle
> 10g. 
> Take an Oracle 10g class now, and we'll give you the exam FREE. 
> http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

Re: [mdb-dev] mdb_alloc_handle / mdb_free_handle

[<br...@br...>]

I have no problem with this I guess. 

On Sun, 25 Apr 2004 13:00:01 -0700 (PDT), Jeff Smith wrote:

> 
> At this point, I believe I can easily integrate the functionality of
> mdb_alloc_handle and
> mdb_free_handle into mdb_open, mdb_clone_handle, and mdb_close.  I
> feel that
> consolidating the functionality of these two layers into one would be
> a very good thing.
> I wanted to clear this change through the list though.  Sound good?
> 
>  -- Jeff Smith
> 
> 
> 	
> 		
> __________________________________
> Do you Yahoo!?
> Yahoo! Photos: High-quality 4x6 digital prints for 25�
> http://photos.yahoo.com/ph/print_splash
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek
> For a limited time only, get FREE Ground shipping on all orders of
$35
> or more. Hurry up and shop folks, this offer expires April 30th!
> http://www.thinkgeek.com/freeshipping/?cpg=12297
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev

[mdb-dev] mdbtools and forms

[Lee L. <le...@ri...>]

Hello List,

Just want to find out if anyone is currently working on code to export/view the forms inside the databases.

I am currently working on a large project to migrate from access to apache and am a fairly skilled C programer. 

I want to find out where the code stands, and what needs to be done still.

Thanks.
Lee Leahu
le...@ri...

[mdb-dev] Re: mdbtools-dev digest, Vol 1 #370 - 2 msgs

[Michael B. <mi...@aa...>]

Hi people! I am a little off topic here so apologies in advance, but 
this list seems to be the only place I can find people who understand 
the inside of an mdb file.
My problem:
I have a client who is running an application with data in a couple of 
mdb files. A great many patient result records have inadvertently been 
deleted (due to a cascade delete setting in the relationship between 
tables I think). Is there a way for me to use mdb tools (or anything 
else you know of) to undelete records?
I think I remember someone here saying that records are not actually 
deleted, but only marked as such. If that is so, is this reversible? Can 
I just somehow unmark them or are there other complications? I am 
willing to export them all to text and find some other way to import 
them back in again if there are index issues or other such side effect 
from a delete. Perhaps I could export all deleted records in a given 
table to a text file and fix them there?
Any help greatly appreciated because they don't have a backup! 
(Complicated and sad, sad story.)
-- 

Have a Nice Day!
Mike

[mdb-dev] mdb_alloc_handle / mdb_free_handle

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

At this point, I believe I can easily integrate the functionality of mdb_alloc_handle and
mdb_free_handle into mdb_open, mdb_clone_handle, and mdb_close.  I feel that
consolidating the functionality of these two layers into one would be a very good thing.
I wanted to clear this change through the list though.  Sound good?

 -- Jeff Smith


	
		
__________________________________
Do you Yahoo!?
Yahoo! Photos: High-quality 4x6 digital prints for 25¢
http://photos.yahoo.com/ph/print_splash

Re: [mdb-dev] connect Linux to DB Access

[Luca C. <lu...@pc...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hello,

on 04/21/04 12:45, Elena Palanca wrote:
> Can I use MDBTools to connect linux with Access even if they aren't on
> the same machine?
sure, as explained in the @ attached (it seems that the SourceForge mailing-list
archive isn't updated, I can't provide the correct link to the relevant post).

Just to be sure you've understood:
1) mount your Windows share (where there's your Access db)
2) configure /etc/odbc.ini to point to your Access db, as an example
	[test]
	Description = Access db on Windows box
	Driver = MDBToolsODBC
	Database = [path where you've mounted Windows share]/[Access db].mdb
	Servername = 127.0.0.1
	UserName =
	Password =
	port = 5432
3) enjoy your Access db with your application :-)

Thx, bye,
Gismo / Luca

- -------- Original Message --------
Subject: Re: [mdb-dev] Using mdbtools odbc to connect to an mdb on a windows box?
Date: Thu, 15 Apr 2004 10:10:12 -0700 (PDT)
From: br...@br...
To: nv...@pa...
CC: mdb...@li...

Hi,

In order to access a database file on another server you must have a
drive mapping to that server, either over SMB (windows file sharing)
or NFS or someother mechanism.  Access does not listen on a server
port like, say, SQL Server or Oracle do.

Brian

On Thu, 15 Apr 2004 07:58:02 +0000, nv...@pa... wrote:

>
> Hi. I'm using a PHP script to pull data out of an access database
> which is located on a remote windows 98SE machine. The file is on
> D:\shared\share\test.mdb.
>
> My configuration on Linux (Redhat 9.0)
> odbc.ini
>
> This is my odbc.ini
>
> [test]
> Description = Microsoft Access Database
> Driver = MDBToolsODBC
> Database = /home/nvs/test.mdb
> Servername = 127.0.0.1
> UserName =
> Password =
> port = 5432
> [test2]
> Description = Microsoft Access Database
> Driver = MDBToolsODBC
> Database =D:\shared\share\test.mdb
> Servername = (ip of win machine)
> UserName =
> Password =
> port = 5432
>
>
> The first database works, the PHP script returns the data. However,
> the second one produces the following error:
> Warning: SQL error: UODB4²ó@¸Îÿ¿›Êñ@ € , SQL state 00000 in SQLConnect
> in /var/www/html/mdb.php on line 3
>
>
> Looking for this problem on the net has found me a few people with the
> same issue, but no sollution. I am rather confused on how to set the
> database option for the second database. Do I use the entire path,
> like above, or do start from the shared directory? Do I need to
> escape backslashes? Any help would be appreciated.
>
> Greetings,
> Niki Van Strydonck
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
Comment: Using GnuPG with Debian - http://enigmail.mozdev.org

iD8DBQFAhlY9VAp7Xm10JmkRAgQuAJ9olKBSHPNc+P1DQABTAS7bd6b59wCeJlB5
Oi9OiqofLkwcANnu4eFECkw=
=z9MO
-----END PGP SIGNATURE-----

[mdb-dev] connect Linux to DB Access

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

Hy,
I submit you following problem:
I have a Linux platform with tomcat server, I have a web application =
(written with servlet and JSP pages on it) runs on it.
The application has to do queries from a Access DB that is located on a =
Windows PC.
Can I use MDBTools to connect linux with Access even if they aren't on =
the same machine?

Thanks in advance

Elena

Re: [mdb-dev] New mdb_crack_row() implementations

[Will N. <wi...@gb...>]

On Fri, Apr 16, 2004 at 08:57:54AM -0700, br...@br... wrote:

> I've just checked in new implementations for the mdb_crack_row[34]()
> routines.  These should get all the details right regarding deleted
> and added columns in all permutations for both Jet 3 and 4 databases.

I'm still getting a segfault here with a large Jet 3 database.

mdb-schema segfaults thus:

-------------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2004 Brian Bruns
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-------------------------------------------------------------



-- CREATE ANY Relationships ...


Program received signal SIGSEGV, Segmentation fault.
0x4001bded in mdb_get_relationships (mdb=0x804ac88) at backend.c:270
270	  if (table->cur_row < table->num_rows) {
(gdb) print table
$1 = (MdbTableDef *) 0x0
(gdb) 

[mdb-dev] Report in MDB ?

[dang m. l. <min...@ya...>]

Do you know the structure of report page? I want to access and extract static texts in mdb file,so then I can handle them. But I don't know how to do that. Do you know how the reports in mdb organize ?

		
---------------------------------
Do you Yahoo!?
Yahoo! Tax Center - File online by April 15th

[mdb-dev] New mdb_crack_row() implementations

[<br...@br...>]

Hi all,

I've just checked in new implementations for the mdb_crack_row[34]()
routines.  These should get all the details right regarding deleted
and added columns in all permutations for both Jet 3 and 4 databases.

As these routines are rather central to the functioning of MDB Tools,
I'd like to get some feedback on any crashes or regressions as well as
if this fixes problems some have experienced with mdb-export having
nonsensical data.

If I don't hear any bad news on this, I have a memo field bug to
straighten out and then I'll be releasing 0.6pre1 and moving on to
(finally) get mdb-import working.

Cheers,

Brian

Re: [mdb-dev] Using mdbtools odbc to connect to an mdb on a windows box?

[<br...@br...>]

Hi,

In order to access a database file on another server you must have a
drive mapping to that server, either over SMB (windows file sharing)
or NFS or someother mechanism.  Access does not listen on a server
port like, say, SQL Server or Oracle do.

Brian

On Thu, 15 Apr 2004 07:58:02 +0000, nv...@pa... wrote:

>=20
> Hi. I'm using a PHP script to pull data out of an access database
> which is located on a remote windows 98SE machine. The file is on
> D:\shared\share\test.mdb.
>=20
> My configuration on Linux (Redhat 9.0)
> odbc.ini
>=20
> This is my odbc.ini
>=20
> [test]
> Description =3D Microsoft Access Database
> Driver =3D MDBToolsODBC
> Database =3D /home/nvs/test.mdb
> Servername =3D 127.0.0.1
> UserName =3D
> Password =3D
> port =3D 5432
> [test2]
> Description =3D Microsoft Access Database
> Driver =3D MDBToolsODBC
> Database =3DD:\shared\share\test.mdb
> Servername =3D (ip of win machine)
> UserName =3D
> Password =3D
> port =3D 5432
>=20
>=20
> The first database works, the PHP script returns the data. However,
> the second one produces the following error:
> Warning: SQL error: UODB4=B2=F3@=B8=CE=FF=BF=9B=CA=F1@ =80 , SQL state 00=
000 in
SQLConnect
> in /var/www/html/mdb.php on line 3
>=20
>=20
> Looking for this problem on the net has found me a few people with
the
> same issue, but no sollution. I am rather confused on how to set the
> database option for the second database. Do I use the entire path,
> like above, or do start from the shared directory? Do I need to
escape
> backslashes? Any help would be appreciated.
>=20
> Greetings,
> Niki Van Strydonck
>=20
>=20
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by: IBM Linux Tutorials
> Free Linux tutorial presented by Daniel Robbins, President and CEO of
> GenToo technologies. Learn everything from fundamentals to system
> administration.http://ads.osdn.com/?ad_id=1470&alloc_id638&op=3Dclick
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev