This almost worked. It seems to referring to the "named" datasource, which in my case is a ms accesss file, as a database server and all the registered ODBC datasources are showing up as database on the server. The schema information was correctly queryed but details about the columns etc. did not work.
---------- Original Message ---------------------------------- From: Rob <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 30 Nov 2004 08:10:26 -0800 >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:185703 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
