failed to connect to DB

[danghieu]

I'm trying to connect to Access. but it's always send me a problem that :"failed to connect to DB". i don't know how to solve, someone told me that it's a problem about default password and account . ... i don't know :( help me please . thanks

[Eranga]

Can you show that what you've done so far?

[danghieu]

here is all i have done

package project_java;
import java.sql.*;
public class thuxem {
public static void main(String args[] ){
Connection con=null;
try{
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc: odbc:db1odbc";
Class.forName(driver);
con = DriverManager.getConnection(url,"root","");
}
catch (ClassNotFoundException e)
{
System.out.println("khong tim thay driver");
}
catch (SQLException e)
{
System.out.println("Khong ket noi duoc voi co so du lieu");
}

}

}

[JosAH]

here is all i have done

In that last catch-block could you insert an e.printStackTrace() call and show us its output?

kind regards,

Jos

[danghieu]

hereeeeeeeeeeeeee :|

java.sql.SQLException: No suitable driver found for jdbc: odbc:db1odbc
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at project_java.thuxem.main(thuxem.java:10)

[Eranga]

That's all about, your connection is not a valid one.

[JosAH]

hereeeeeeeeeeeeee :|

Your driver is stored in a .jar file somewhere; put that .jar file in your classpath. Or else check that URL; does it really have spaces in it?

kind regards,

Jos

[danghieu]

Your driver is stored in a .jar file somewhere; put that .jar file in your classpath. Or else check that URL; does it really have spaces in it?

kind regards,

Jos

i used searching in window to find out the classpath but .... :-??

[JosAH]

Forget about my previous reply: I just noticed that you're using the jdbc-odbc bridge and that one comes with your Java distribution; I googled a bit and saw that you have to install it as:

Class.forName( ... ).newInstance(), i.e. you have to instantiate a driver object, not just load the class.

kind regards,

Jos

[Tolls]

You alos appear to have a space in the middle of your connection string:
"jdbc: odbc:db1odbc"

That would get you an no valid driver exception even with the jar file in the classpath.

[JosAH]

You alos appear to have a space in the middle of your connection string:
"jdbc: odbc:db1odbc"

That would get you an no valid driver exception even with the jar file in the classpath.

Yep, I also noticed that (see reply #7) but this bloody forum software also inserts spaces spontaneously; I think it's the lack of the newInstance() method call; that seems to be the way that bridge wants to be installed. Oh well, we'll wait for the net stack trace ;-)

kind regards,

Jos

edit: forget about that newInstance() too; the fault is that space in your URL.

[Tolls]

I've seen it in the stacktraces before, but it's also in the code...so I suspect it's real.

[danghieu]

Forget about my previous reply: I just noticed that you're using the jdbc-odbc bridge and that one comes with your Java distribution; I googled a bit and saw that you have to install it as:

Class.forName( ... ).newInstance(), i.e. you have to instantiate a driver object, not just load the class.

kind regards,

Jos

like this :

package project_java;
import java.sql.*;
public class thuxem {
public static void main(String args[] ){
Connection con=null;
try{
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:db1odbc";
Class.forName(driver).newInstance();// unhandled exceptiontype
con = DriverManager.getConnection(url,"root","");
}
catch (ClassNotFoundException e)
{
System.out.println("khong tim thay driver");
}
catch (SQLException e)
{
System.out.println("Khong ket noi duoc voi co so du lieu");
e.printStackTrace();
}

}

}

but it show the error that" unhandled exceptiontype"

[JosAH]

like this :



but it show the error that" unhandled exceptiontype"

I updated my previous reply, but: forget about that newInstance() method call. If you have removed that space character from your URL, try again.

kind regards,

Jos

[danghieu]

no no, i make space there because when i type ":"+"o" = :o it's a fun image. so it's not problem :|

[Tolls]

That's why you should use CODE tags, and not QUOTE tags.

[danghieu]

thanks to all of you. i solved my problem.
i had to create a connection with access through Data Source in windows. and my url is "jdbc:odbc:db1" ("db1" is name of connection i created in data source)
:)