Hi,

I need help,
I am trying to connect from remote windows xp computer B to ms sqlserver2005 express edition in another windows xp computer A and got this error:

java.lang.classnotfoundexception com.microsoft.sqlserver.jdbc.sqlserverdriver

My software can connect locally to the sqlserver 2005 though in the local computer A, however when i tried to connect remotely, i just got that error.

In the remote computer B, i have sqljdbc.jar in lib but there is no ms sqlserver 2005 installed. i try to set the classpath c:\program files\smcpl\btrek\lib\sqljdbc.jar but still get the same error.

2
Contributors
4
Replies
9
Views
7 Years
Discussion Span
Last Post by btreksql

In which computer you have the java files which use the classes form this jar file? Try to set the classpath in that computer or set in both!!

In which computer you have the java files which use the classes form this jar file? Try to set the classpath in that computer or set in both!!

I have tried setting the classpath for both computers still doesnt work still getting the same error. pls help I have been stuck for weeks trying to connect to sqlserver2005 express remotely. Thanks alot

put sqljdbc.jar in Computer A and set the classpath of this file in Computer A.

put sqljdbc.jar in Computer A and set the classpath of this file in Computer A.

yes i have done that classpath c:\program files\smcpl\Btrek\lib\sqljdbc.jar

but still in vain ? how?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.