Re: Access Database
Re: Access Database
- Subject: Re: Access Database
- From: Chuck Hill <email@hidden>
- Date: Tue, 25 Nov 2003 19:56:03 -0800
You can certainly use Access with WO using a JDBC-ODBC bridge (or is it
ODBC-JDBC bridge...) and I'm pretty sure I've seen JDBC drivers for Access,
though not free. Having said that, we've done some of this and it is a bit
of a nightmare, or a rather bad dream at least. But if you have a lot of
data that you need to read or migrate out it can be worth the trouble.
Given an option, I'd get my data somewhere else. And I would never
recommend using it for anything in production. It is prone to corruption,
or was last time I used it.
WO comes with a mostly undocumented and actively user hostile application
called JavaEOUtil that you can use to pump data from one source to another.
I think there is also an app do to this on http://www.wocode.com. I've
not used it.
The Omni lists are likely to have more information on this, worth a few
minutes searching.
Chuck
At 05:57 PM 25/11/2003 -0500, Jim Mooney wrote:
>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.
>
--
Chuck Hill email@hidden
Global Village Consulting Inc. http://www.global-village.net
_______________________________________________
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.