Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsWhite Papers
Discussion GroupsFirst AidDatabasesJavaBeansGUIJava 3DVirtual MachineCORBASecurityToolsGeneral
Java DirectoryOpen Source ProjectsSample Book ChaptersUser GroupsWeb Resources
Related Topics
Databases.NETMore Topics ...

Java Forum / Databases / July 2004

Tip: Looking for answers? Try searching our database.

configuring jdbc

Thread view: 
Ike - 06 Jul 2004 21:07 GMT
I'm using j2se 1.4.x

I'm trying to obtain (whatever jar file) I need to connect via jdbc. Can
someone tell me how to do this so that U can acces MS-ODBC? My code - and
thrown exceptions, are distilled below. Thanks, -Ike

try{
           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
           Connection con = DriverManager.getConnection(
"jdbc:odbc:exceltest" );
          ...
           con.close();

       } catch(Exception ex) {
           System.err.print("Exception: ");       ////PUTTING UP:
"Exception: [Microsoft][ODBC Driver Manager] Data source name not found and
no default driver specified"
           System.err.println(ex.getMessage());
       }
Lee Fesperman - 07 Jul 2004 00:06 GMT
> I'm using j2se 1.4.x
>
[quoted text clipped - 15 lines]
>             System.err.println(ex.getMessage());
>         }

Undoubtedly, the problem is what the message says: "Data source name not found". Have
you created a DSN (Data Source Name) of "exceltest" and pointed it to your RDBMS?

Signature

Lee Fesperman, FirstSQL, Inc. (http://www.firstsql.com)
==============================================================
* The Ultimate DBMS is here!
* FirstSQL/J Object/Relational DBMS  (http://www.firstsql.com)



Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.