Re: Access Database
Re: Access Database
- Subject: Re: Access Database
- From: email@hidden
- Date: Wed, 26 Nov 2003 12:22:55 CDT
- Priority: 3 (Normal)
[demime could not interpret encoding binary - treating as plain text]
There has been discussion on the list about using WO with MS Access. I do
recall someone making it work, but I can't remember if that was pre 5.0
or not. You could check the list archives. However, what I recall, is
that some people sort of kind of made it work, but there were still lots
of problems.
Even if you made it work perfectly, you are not going to get good enough
performance out of Access for significant traffic to your site.
So my conclusion is that it might be possible to get Access to work with
a lot of trouble, but you don't want to, it's not worth it.
On Tue, 25 Nov 2003 17:57:27 -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.
_______________________________________________
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.