This week's book giveaway is in the JavaFX forum.
We're giving away four copies of Introducing JavaFX 8 Programming and have Herbert Schildt on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes configuring ODBC Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Introducing JavaFX 8 Programming this week in the JavaFX forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "configuring ODBC" Watch "configuring ODBC" New topic

configuring ODBC

henry akoma

Joined: May 17, 2005
Posts: 21
please can anyone assist me with the configuration of ODBC.
i wrote a program and the console is giving me an error which reads "Data source not found and no default driver".

i used

but i am not sure what my url should be:-
please can someone help me
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

You can configure them on the (Windows) control panel, "Data Sources (ODBC)", it may be in the administrative tools.

You give your datasource a name like "mydb" , then refer to to it as "jdbc:odbc:mydb"
David O'Meara

Joined: Mar 06, 2001
Posts: 13459

*Sigh*, I should have called it "jdbc:odbc:abcd", try saying that three times fast
I agree. Here's the link:
subject: configuring ODBC
It's not a secret anymore!