File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Struts and the fly likes MS SQL Server socket problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Frameworks » Struts
Bookmark "MS SQL Server socket problem" Watch "MS SQL Server socket problem" New topic

MS SQL Server socket problem

Gigi Kent
Ranch Hand

Joined: Nov 30, 2004
Posts: 40
I'm working on a struts based aplication and a have a problem:
on my computer everithing is working juts fine, but I'm trying to deploy the application to another computer.
I've installed everithing but the big problem is that the application cannont conenct to te MS Sql server. I've installet SP3 but it' not working. The error is "Error establishing socket".
I know that this error is because sql server does not accept tcp connection, but I've installer SQL Server SP3, but the same.
In datasource in struts-config.xml it is a query validator. If I change the name of a table from my validation, the error is that the table name is wrong. So, theoreticaly the connection between my app and server is working, but if I change back with the correct name, it give me the same error .
I have Win 2000.
Please, maybe someone knows the answer to my problem.
For about 2 weeks I have this problem and I'm running out of time.
Don't get me started about those stupid light bulbs.
subject: MS SQL Server socket problem
It's not a secret anymore!