Brief problem was just calling a JSP page using JBoss, and JDBC driver, to retrieve some information about SQL Server 2000. and all are about this connectivity, first running i was getting the error 'The TCP/IP connection to the host localhost, port 1433 has failed' then Mr. Peter Johnson issued using TCPView find it very helpful trying correct port with sql server, but the other problem emerged like the following ...
well, using TCPView, it's a bit relief that because of not gettin' any error with using 'jtds-0.9.jar' driver an' that threepiece too, but the error is still the same with using sqljdbc.jar, and now matter is with those first, mean, when calling the page through JBoss, page chilling and no error , you see bar it's tellin you that 'Web site found. Waiting for reply ...' and bar don't go any higher than half, this time i used different versions of JBoss like jboss-4.0.5.GA, ... the result is same 'no error, no progress', this time i see what port sql server using then the problem is solved and no matter to find out this 1433, also this Administrative Tool > Data Source is working and stood firm with me,
i might add that when in this chilling situation you just turning SQL Server off (SQL Server Service Manager; ►║ ■) page is down, i mean, is a clear reason of this hard time in connecting relation through web page, Jboss, driver, SQL Server
this time, tried in a different way, i mean, with Monitoring it's okay an' in the state of localhost:3333 (SQL-TCPView-Port) and it's Connecting bla bla bla at localhost:3333 ...' is 'handshaking ...' this assure relation. (3333 the last TCPView port of sqlserver)
Well, found this one o that moot point for SQL 2000, after lots of checking, tos an' fros most parts of windows,
this last verse installed SQL 2005, it worked , and i'm thankful Peter Johnson and Paul Sturrock for everything ..., but i still got that chilling!!!
He's my best friend. Not yours. Mine. You can have this tiny ad:
Free, earth friendly heat - from the CodeRanch trailboss