[ODBC] Connection not Open

[Rafael Afonso]

Hello:

Following this tutorial I tried access a Excel sheet using ODBC-JDBC. But when I try see my sheet using DbVisualizer it is showed a message about connection not open:

java.sql.SQLException: [Microsoft][ODBC Driver Manager] A conex�o n�o est� aberta  // In portuguese
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDisconnect(JdbcOdbc.java:3034)
at sun.jdbc.odbc.JdbcOdbcDriver.disconnect(JdbcOdbcDriver.java:981)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:145)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
at com.onseven.dbvis.wrapper.DriverManagerImpl.getConnection(DriverManagerImpl.java:40)
at com.onseven.dbvis.sql.Database.doConnect(Unknown Source)
at com.onseven.dbvis.sql.Database.access$000(Unknown Source)
at com.onseven.dbvis.sql.Database$ConnectionCommand.execute(Unknown Source)
at se.pureit.util.ThreadCommand.runExecute(ThreadCommand.java:163)
at se.pureit.util.ThreadCommand.run(ThreadCommand.java:143)
at java.lang.Thread.run(Thread.java:534) 

So my question is how open the connection. I a using Windows 2000.

Thanks,

[Jeanne Boyarsky]

Rafael,
Did you register the ODBC datasource in Windows? Did you get any error messages when doing so?