This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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 Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
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
Similar Threads
database connection through simple ejb on weblogic5.1
How can i connect to MS SQL Server in JDK 1.3
connecting to Webtrends reporting DB using JDBC-ODBC
JDBC Connection
Problem with MYSql