• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Access Database
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

References: 
 >Re: Access Database (From: Kieran Kelleher <email@hidden>)
 >Re: Access Database (From: Jim Mooney <email@hidden>)

  • Prev by Date: Re: Array, dictionary and set in EOF
  • Next by Date: Re: Resources for porting WO applicaitons from 5.1 to 5.2 and Xcode?
  • Previous by thread: Re: Access Database
  • Next by thread: Re: Access Database
  • Index(es):
    • Date
    • Thread