Re: Access Database
Re: Access Database
- Subject: Re: Access Database
- From: Jim Mooney <email@hidden>
- Date: Tue, 25 Nov 2003 17:57:27 -0500
Your insight in the Access file based issue cracks my hopes of a nice
and easy...jdbc socket query....approach with EOM. It also explains
the very small amount of information on the topic. Migrating to
MYSQL....is going to be the approach.
I am at the initial point of looking at the best approach to getting
the data into a usable format that I can use with WO. If I could
easily connect with some adapter from WO.... I did not find anything
in literature hence the post to this board.
You did say that your Access database has "sample data". Why not
import your sample data from Access into MySQL? ....
I have both the full data set and a partial.... I am going to get a
little grubby before I can start working with WO.
Thanks for the info.
Jim
On Tuesday, November 25, 2003, at 05:01 PM, Kieran Kelleher wrote:
IMHO it is not feasible Jim, Microsoft Access is a "file based"
database system whereas MySQL, Microsoft SQL Server, Openbase, etc are
enterprise server based databases that are designed to offer services
over TCP/IP and usually the connection specification consists of an IP
address (or resolvable URL) and the port number that the database is
running on. I think you may have performance and reliability issues
even if you do succeed in making a connection from WO to Access. If
you are intent on doing it, try searching for a JDBC bridge, but I am
guessing that even if you do find a solution, it may be expensive.
Check out OpenLink database drivers ............
http://www.openlinksw.com/
You did say that your Access database has "sample data". Why not
import your sample data from Access into MySQL? ....
-K
____________________________________
OS X 10.3.1 / WO 5.2.2 / MySQL 4.0.16
On Nov 25, 2003, at 2:46 PM, Jim Mooney wrote:
Question,
Is it feasible to easily connect to an Access Database with
WebObjects. I can connect great to mysql and having a blast. I have
a windows machine sitting on my hub with an access database running
with some sample data from a much larger operational database for an
office.
I have the default install of WebObjects on my laptop with 10.2.8 and
the latest...un pantherized WO version.
Can someone point me to the instruction for connecting to this Access
database via ODBC or JDBC...or whatever voodoo magic WO does to work
with databases.. ie. what to put in the adaptor properties and
settings in the Access Database. I was succesfully able to run some
asp scripts and query the database so as far as the database
talking....it does speak.... Does WO come with the drivers or do I
need to find a 3rd party?
Jim
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.