Re: tomcat on linux, MS Access database on Win XP over network

[Paul Bemowski <bemowski@yahoo.com>]

There are times when you're screwed into an Access database.  

That's why I wrote the JETProxy. It is a free JDBC tool that
will proxy calls from one machine to the other.  So you will run
the JETProxy server on the XP box (a java VM), and expose a
local ODBC DSN.  Then, from your linux box, you connect with a
pure java driver.  The pluming between the two is RMI.  This is
a standard Type 3 driver.  

It does not support CallableStatements and stream data types
(blobs).  

Get it at http://www.jetools.com/products/jetproxy

If you download it and use it, I'd love to hear what you think.

Paul Bemowski

--- James Picklesimer <ilogicdot@yahoo.com> wrote:
> hmmmmmm......
> Curious choice(s). There are 2 products that use JNI
> to access DCOM objects which can be used to access
> anything on MS however they cost money. Neva Objects
> and jintegra.
> +James P.
> 
> --- Ed Elud <edelud@yahoo.com> wrote:
> > Response predicated on your reason for using access.
> > :)
> > 
> > If you're using Access due to ease of use, you could
> > reverse the process by using another small footprint
> > database such as MySQL (also more reliable) - I'm
> > sure
> > you've thought of this already.  
> > 
> > To retain that ease of use, you could link the
> > access
> > db to mysql tables using odbc to linux/mysql.  It
> > would appear to you that the db is on access and you
> > could work with it in access.
> > 
> > Also, take a look at sqlLink.
> > 
> > Hope this helps some.
> > 
> > --- Poorav Chaudhari <pooravc@yahoo.com> wrote:
> > > at home i have a linux box and Windows XP box. I
> > > want to create a DSN (not sure
> > > about the equivalent of windows DSN in linux) so
> > > that my web application, which
> > > will reside on the linux box, can access the
> > > database on my windows XP box.
> > > From what i know, there is no driver/bridge
> > > available to host a MS access
> > > database on a linux box. So, I am hoping i can
> > > atleast access the database
> > > using some sort of bridge to connect to the
> > database
> > > on a remote machine. Can
> > > some one help me with this or atleast direct me to
> > > some place where i may find
> > > information on how to set this up.
> > > 
> > > Thank you.
> > > 
> > > =====
> > > Poorav Chaudhari
> > > 
> > > __________________________________________________
> > > Do you Yahoo!?
> > > Yahoo! Tax Center - forms, calculators, tips, more
> > > http://taxes.yahoo.com/
> > > 
> > 
> > 
> > __________________________________________________
> > Do you Yahoo!?
> > Yahoo! Tax Center - forms, calculators, tips, more
> > http://taxes.yahoo.com/
> > 
> 
> 
> __________________________________________________
> Do you Yahoo!?
> Yahoo! Tax Center - forms, calculators, tips, more
> http://taxes.yahoo.com/
> 


__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/