I don't use windows or access so this is mostly just bits of information...
What you have to do is setup a system (or user I guess) odbc data source (using control panel) - which should be basic for a windows savy sort... then for the jdbc driver you use the jdbc odbc bridge. The driver name is: sun.jdbc.odbc.JdbcOdbcDriver Then the url you connect to is: jdbc:odbc:Fred Where Fred is generally your data source name or database system. That should work with quantam (I assume) or with BBEdit. Here is a quick read from a java point of view, but still a bit helpful http://java.sun.com/docs/books/tutorial/jdbc/basics/connecting.html Good luck On Tue, 30 Nov 2004 06:31:57 -0500, Dwayne Cole <[EMAIL PROTECTED]> wrote: > Just start using cfeclipse and I'm loving it. Most of our Databases are MS > Access Database and I am looking for a good Eclipse plugin that would allow > me to view and work with MS Access. I've tried dbViewer and it only seems to > accept jdbc connection and from my understanding MS Access requires odbc or > some sort of jdbc - odbc bridge. This is where it begins to get a little > over my head. But if some one is using eclipse to work with MS Accesss > Databases I would greatly appreciate your help. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185667 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
