JDBC connection with SQL Server 2008 R2

[George Nieuwoudt]

Hi,

I have a problem connecting to a database on a sql server 2008 r2 machine, and was wondering if anyone could shed some light on it...

I am currently using eclipse(64 bit), jdk 1.6 update 27(64 bit) and microsoft sql server jdbc 3.0(sqljdbc4) driver to connect to the database but it seems i cannot make a connection or the connection "hangs" because the code does not get executed past trying to make a connection and does not return any errors(even after waiting an hour)...

We have multiple databases on the above mentioned sql server. Which is where i want to connect to a specific one.

code sample ammended:

private void dcConnect() {
    try {
        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String connectionURL = "jdbc:sqlserver://*IP of the sql server*:1433;databaseName:*databaseName on the sql server*;"
            + "user=*userName*;password=*userPassword*;MultipleActiveResultSets=true;";
        connect = DriverManager.getConnection(connectionURL);
    } catch (ClassNotFoundException cnfe) {
        //Code to handle the exception
    } catch (SQLException sqle) {
        //Code to handle the exception
    }
}

Any light on this will be apreciated...

Thank You

[Roberto Perillo]

Since this is more related to JDBC, let's move it to the JDBC forum.

[George Nieuwoudt]

Thank you, new to here, so will check more carefully next time.

[Howard Watson]

Hi George. Based on my own experience with the Microsoft JDBC driver I recommend trying this driver.

http://jtds.sourceforge.net/

[Paul Clapham]

JTDS? Yes, I agree. The Microsoft driver used an SSL connection, which for some reason failed in my environment, but when I switched to JTDS that problem went away.

[George Nieuwoudt]

Thank you guys, i really apreciate the help jtds is working 100%.

[Paul Clapham]

Elena Irkovskaya,
Your post was moved to a new topic.