aspose file tools*
The moose likes JDBC and the fly likes Connecting MS SQL Server 2008 from java code in  Windows7 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Connecting MS SQL Server 2008 from java code in  Windows7" Watch "Connecting MS SQL Server 2008 from java code in  Windows7" New topic
Author

Connecting MS SQL Server 2008 from java code in Windows7

Ponnusamy Gov
Greenhorn

Joined: Feb 01, 2011
Posts: 17
In Windows 7, I have tried from java to connect MS SQL 2008 server using jtds jar. I am having 2005 also in my machine. Here I was not able to connect 2008 server since 1433 port was assigned to 2005. So I have changed the port in my application to the port which is mentioned in SQL Server Configuration Manager ->SQL Server Network Configuration ->Protocols-> TCP/IP properties -> IP Addresses -> IP All(53033). It is connected!!!

Pons
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19670
    
  18

Are you asking us how to specify the port in the connection string? If so, just add :53033 just after the host name.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
How To Ask Questions How To Answer Questions
Rob Spoor
Sheriff

Joined: Oct 27, 2005
Posts: 19670
    
  18

dantaro hyedima,
Your post was moved to a new topic.
Ponnusamy Gov
Greenhorn

Joined: Feb 01, 2011
Posts: 17
I have posted as a Info only. Anyway Thanks...
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connecting MS SQL Server 2008 from java code in Windows7