Re: Access Database
Re: Access Database
- Subject: Re: Access Database
- From: Kieran Kelleher <email@hidden>
- Date: Tue, 25 Nov 2003 17:01:21 -0500
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.