need help connecting to Access DB

[Josh Forrest]

this is what i have...
Connection conn = null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc.odbc:josh");
System.out.println("connection = " + conn);
---------------------------
conn comes back null, i'm not sure if this part of my code is correct...
("jdbc.odbc:josh");
where josh is the name of my Access database.
thanks for any help!

[Thomas Paul]

You have to set up a DSN if you want to use the ODBC driver.
[ January 23, 2003: Message edited by: Thomas Paul ]

[Josh Forrest]

i have the DSN set up, i'm concerned that this part of my code is incorrect...
conn = DriverManager.getConnection("jdbc.odbc:josh");
i'm not sure if i should use the DB name(josh) here, or if i should insert something else there?

[Younes Essouabni]

Hello Josh,
the syntax is DriverManager.getConnection("jdbcdbcBName","user","password");
Where DBName is your database name, not the table name. If you didn't set a user and a password, try with empty quotes (just a guess). And check that your DSN is correctly set.
Hope it helps
[edited to remove the smilies]
[ January 23, 2003: Message edited by: Younes Essouabni ]

[Sam Moran]

Josh, I gave you the code in the other thread it is as follows:

 
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc    :-o	    dbc:Josh";    
Connection con = DriverManager.getConnection(url);

It is important that the DSN entry must have the same case as the url assignment. So, here it would be Josh. My suggestion would be to use all upper or all lower case. The DSN entry contains all of the information about you DB, where it is and its name. The connection that you create in your Java program is connecting to the DSN entry that has the location and name information. If you want to see if the connection was successful try this:

public class ODBtest {
    public static void main( String argv[] ) {
        try {
    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            String url = "jdbc    :-o	    dbc:SAMTEST";
            //SAMTEST is the DSN entry, and the DSN entry has the definition c:\temp\Samtest.mdb
            Connection con = DriverManager.getConnection(url);
                if (con != null)
                     System.out.println("Connection Successful!");
...
...
}
}
}
 

[ January 24, 2003: Message edited by: Sam Moran ]
[ January 24, 2003: Message edited by: Sam Moran ]
[ January 24, 2003: Message edited by: Sam Moran ]
[ January 24, 2003: Message edited by: Sam Moran ]