| Rose Girl 2005-07-11, 7:23 am |
| Hi,
I desperately need some help on this. I have an application that runs
on Tomcat. All this while i had windows xp service pack 1, but now i
have upgraded to windows xp service pack 2. Since then Tomcat gives an
error trying to connect to Sql server using JDBC connection.
My conf file in Tomcat is:
theDbLoginName=sa
theDbPassword=sa
theDbDriver=com.inet.tds.TdsDriver
theDbServer=jdbc:ine
tdae7:eccolwxpsde:14
33?database=hms_sys
minConns=20
maxConns=200
poolLogFileName=D:\T
omcat\logs\servlet.txt
maxConnTime=1
During my search, i have found that this is a known problem because of
the service pack 2.
I found several solutions in the net. But none of them are qorking in
my case.
1) Disabling firewall
2) Adding an exception in firewall for port 1433
3) Adding an exception in firewall for sqlserv.exe
The only way it works is if I uninstall service pack 2. But this
shouldnt be an option.
Can someone give other alternatives to this problem.
Appreciate any help you can give me.
Thanks
Rose.
|