This week's book giveaway is in the General Computing forum.
We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line!
See this thread for details.

The moose likes JDBC and the fly likes [ODBC] Connection not Open

A friendly place for programming greenhorns!

Big Moose Saloon

Search | Java FAQ | Recent Topics

Win a copy of Arduino in Action this week in the General Computing forum!

A special promo: Enter your blog post or vote on a blogger to be featured in an upcoming Journal

JavaRanch » Java Forums » Databases » JDBC

Author

[ODBC] Connection not Open

Rafael Afonso
Ranch Hand

Joined: Jul 16, 2002
Posts: 63

posted

0

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 26496

78

I like...

Eclipse IDE

Java

VI Editor

posted

0

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

I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.

subject: [ODBC] Connection not Open

Similar Threads
Connecting to DB Error
connecting to ms access database
Connection Problem
Connecting To Database
Need help