This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman 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 Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "configuring ODBC" Watch "configuring ODBC" New topic
Author

configuring ODBC

henry akoma
Greenhorn

Joined: May 17, 2005
Posts: 21
hi,
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
Rancher

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
Rancher

Joined: Mar 06, 2001
Posts: 13459

*Sigh*, I should have called it "jdbc:odbc:abcd", try saying that three times fast
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: configuring ODBC