Accessing MS-Access from Solaris and AIX

Thread view:

Vasanth - 12 Jul 2004 07:18 GMT

Hi:
I am using Sun JdbcOdbcDriver to access MS-Access from Java client on
Windows platform. We are in the process of migrating from Win to
Solaris and AIX platform. MS-Access will continue to reside on Win
platform. How can I access MS-Access from Java client on Solaris and
AIX? Can I still use Sun JdbcOdbcDriver?. What drivers or files do I
need on Solaris and AIX platforms? If Sun JdbcOdbcDriver for MS-Access
is not possible on these platforms, please let me know alternatives.
(I can't change database product)

Thanks,
Vasanth

Reply to this Message

Shanmuhanathan T - 12 Jul 2004 09:36 GMT

on 7/12/2004 11:48 AM Vasanth Wrote:

> Hi:
> I am using Sun JdbcOdbcDriver to access MS-Access from Java client on
[quoted text clipped - 8 lines]
> Thanks,
> Vasanth

Vasanth,
You would need odbc drivers on Solaris/AIX.
Googling for odbc unix gives a good hit:
http://www.easysoft.com/solutions/accessnw.phtml
Its a good place to start your investigations from...

Signature

Shanmu.

Reply to this Message

Luke Webber - 12 Jul 2004 09:55 GMT

> Hi:
> I am using Sun JdbcOdbcDriver to access MS-Access from Java client on
[quoted text clipped - 5 lines]
> is not possible on these platforms, please let me know alternatives.
> (I can't change database product)

My advice would be to ditch Access and use a true server DBMS. Take your
pick from the free MySQL or PostGreSQL to the more commercial options.

Luke

Reply to this Message

Tod Landis - 22 Jul 2004 21:25 GMT

>> Hi:
>> I am using Sun JdbcOdbcDriver to access MS-Access from Java client on
>> Windows platform. We are in the process of migrating from Win to
>> Solaris and AIX platform. MS-Access will continue to reside on Win

[clip]

If you run MySQL on the Windows machines where you now
run Access you can access it using ODBC--eg. for the M$
Office applications. Googling for "mysql odbc" displays a
ton of info on this option. Then you can use the MySQL
JDBC driver to get access for java applications on all
platforms.

For what its worth, if you have RPM on your Solaris systems
you might find this HOWTO about installing MySQL useful:
http://todlandis.com/entrance/mysql_howto.html
Its written for JDS, but actually applies to any system
with rpm support.

What are the barriers to ditching Access? Can you say a
little more about this?
- Tod Landis

Reply to this Message

Accessing MS-Access from Solaris and AIX

Free Magazines