This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes [ODBC] Connection not Open Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "[ODBC] Connection not Open" Watch "[ODBC] Connection not Open" New topic
Author

[ODBC] Connection not Open

Rafael Afonso
Ranch Hand

Joined: Jul 16, 2002
Posts: 63
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:

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

Thanks,


=================================<br /> Rafael U. C. Afonso<br /> <a href="http://www.javafree.com.br" target="_blank" rel="nofollow">www.javafree.com.br</a><br />=================================<br /><i>Where is debug?<br />debug is on the table</i>
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30789
    
157

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: [ODBC] Connection not Open