File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 REST with Spring (video course) this week in the Spring 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!