JDBC help

[Jack Bolton]

Hi,
i am using SQL Server 2000 Personal Edition.
and i'm accesing "the Northwind" database like this:
this is some part of the code:

  
try {
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 conn = DriverManager.getConnection("jdbc:odbc:Northwind","p","p");
}
catch (Exception e){
e.printStackTrace();
}
 
  

but it always prints the error in the console. So the program it's not accesing the database.
What do i have to correct here?
[ July 02, 2006: Message edited by: Jack Bolton ]

[Stan James]

Here's some code that I'm pretty sure works. The Class.forName() technique should be just as good (or better) than the registerDriver() technique.

DriverManager.registerDriver( new sun.jdbc.odbc.JdbcOdbcDriver() );
conn = DriverManager.getConnection( "jdbc :-o	 dbc:" + dbName );

This looks pretty similar to your own. Can you show us the full stack trace?

[marc weber]

Moving to the JDBC forum.

[Jack Bolton]

the getconnection should be like this?

  
conn = DriverManager.getConnection("jdbc:odbc:" + "Northwind");
  

because the result is the same as before.

here is the stack trace(what it prints on the console):

java.sql.SQLException: [Microsoft][Driver Manager ODBC]
The name of the data source cannot be found, and the default driver was not specified.

at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6958)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7115)
at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(JdbcOdbc.java:3074)
at sun.jdbc.odbc.JdbcOdbcConnection.initialize(JdbcOdbcConnection.java:3
23)
at sun.jdbc.odbc.JdbcOdbcDriver.connect(JdbcOdbcDriver.java:174)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at DBTest.<init>(DBTest.java:15)
at DBTest.main(DBTest.java:35)
[ July 03, 2006: Message edited by: Jack Bolton ]

[Naseem Khan]

have you made Northwind user dsn?

use following code or one which Stan posted.

try {
  Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
  // p, p must be your SQL server login credentials
  Connection conn=DriverManager.getConnection("jdbc:odbc:Northwind", "p", "p"); 
  System.out.println(conn);  [B]// What conn is printing here?[/B]
}
catch(Exception e){
  e.printStackTrace();
}

Naseem

[ July 03, 2006: Message edited by: Naseem Khan ]
[ July 03, 2006: Message edited by: Naseem Khan ]