Re: Where is the driver and how to connect?
fasisi wrote:
I am new to JDBC. Can you help me on how can I know that I have the
driver I need to connect to some kind of database... say MS Access or
SQL Server or Firebird or Paradox?
Arne VajhQj wrote:
For MS Access or Paradox I believe you will have to use the ODBC
driver for those and the JDBC-ODBC bridge that comes with Java.
Is there even an ODBC connector for Paradox? It's not an SQL-based database
system.
For SQLServer you can either use the JDBC driver from MS or the
FreeTDS JDBC driver.
And how to connect to the database?
See docs for the driver.
Individual drivers come from a variety of sources. For example, Oracle, IBM
and PostgreSQL all provide JDBC drivers for their respective RDBMS products.
For massive amounts of information from Sun about JDBC and related tech, start
here:
<http://java.sun.com/javase/technologies/database/index.jsp>
Really, it is a very good idea for matters Java to begin with a search
java.sun.com. It's simply amazing how much Sun and others have published on
line for free about all this.
IBM developerWorks is another excellent launching point for Java studies.
<http://www.ibm.com/developerworks/java>
Usenet is not efficient for gaining comprehensive knowledge of a subject.
It's best used to fill specific gaps in understanding and to expand one's
awareness of various issues.
--
Lew