I have not tried this out but you can get an enumeration of drivers through the DriverManager class. There is a static method named "getDrivers()" that will handle this.
Joined: Oct 13, 2000
DriverManager.getDrivers() only returns the drivers that are loaded earlier using class.forname(xx). I want the list of all drivers and DSNs in the system(server). In VB one uses SQLDrivers API to do this. I want a similar JDBC API in Java. [This message has been edited by Subramanian Parlikkad (edited October 27, 2000).]
Since drivers are simply classes, aren't registered with anything, and don't even have to directly be on the classpath, how would Java know which drivers even exist on the server? [This message has been edited by Thomas Paul (edited October 30, 2000).]
say again... unless you are using the jdbc-odbc driver that comes with the standard jdk. you have to put a vendors __.zip or __.jar file within you CLASSPATH. Otherwise you will an exception... this post has show to me that ... we all need to review some tutorials and/or read a good book... this a basic stuff here ... it is not rocket science...
[This message has been edited by Monty Ireland (edited November 03, 2000).]
Joined: May 05, 2000
Well, Monty, I see that maturity is not your strong point. If you can not post according to the guidelines, you will be banned. Just to correct you, many vendors (Sybase for example) supply their classes as classes in addition to supplying them as a jar or zip file. This is what I meant when I said that the classes don't have to be "DIRECTLY" on the classpath. They could be many directories off the classpath. But this does not change the answer to the question which is that Java does not know what JBDC drivers are available on the server. It can only tell you what drivers are registered. [This message has been edited by Thomas Paul (edited October 31, 2000).]
Joined: Oct 03, 2000
We learn more from our mistake's than from our success's. ... Do NOT get bend out of shape one this one... I did not mean to offend anyone. ... 6 months ago I would not have recieved a reply like this one... ... I will try to be more P.C. next time. ... I'm here to learn and help others... SeeYa Later Partner
I’ve looked at a lot of different solutions, and in my humble opinion Aspose is the way to go. Here’s the link: http://aspose.com