Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

JDBC connection with SQL Server 2008 R2

 
George Nieuwoudt
Greenhorn
Posts: 8
Eclipse IDE Firefox Browser Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:


Any light on this will be apreciated...

Thank You
 
Roberto Perillo
Bartender
Posts: 2271
3
Eclipse IDE Java Spring
  • Likes 2
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Since this is more related to JDBC, let's move it to the JDBC forum.
 
George Nieuwoudt
Greenhorn
Posts: 8
Eclipse IDE Firefox Browser Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you, new to here, so will check more carefully next time.
 
Howard Watson
Ranch Hand
Posts: 60
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi George. Based on my own experience with the Microsoft JDBC driver I recommend trying this driver.

http://jtds.sourceforge.net/
 
Paul Clapham
Sheriff
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 8
Eclipse IDE Firefox Browser Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thank you guys, i really apreciate the help jtds is working 100%.
 
Paul Clapham
Sheriff
Posts: 21107
32
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Elena Irkovskaya,
Your post was moved to a new topic.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic