Is there a way to speed up getConnection() ?

Hi all,

I don't know much about the java.sql package, and I just have a generic connection to an Excel workbook:

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection connection = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};" +

"DBQ="+address+";DriverID=22;READONLY=false","","");

// This is actually in a method, the connection is actually declared outside of it.

For some reason, the connection to the worksheet is very slow. Just a general question on this, is there anything I can do to make it faster? I've done some research and it doesn't look like I did anything wrong, so I'm kind of stumped. It takes something like 30 seconds just to connect, and I think that's making my Statements and PreparedStatements slow down too. Any help on this would be great.

Thanks!

Jezzica85

Message was edited by:

jezzica85

Message was edited by:

jezzica85

[1155 byte] By [jezzica85a] at [2007-11-27 4:56:33]