Member Avatar for btreksql

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.
Please advise how to resolve this. Thanks

  • 2 Contributors
  • 4 Replies
  • 298 Views
  • 6 Days Discussion Span
  • Latest Post Latest Post by btreksql
Member Avatar for chirag.jain18

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!!

Member Avatar for 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!!

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

Member Avatar for chirag.jain18

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

Member Avatar for btreksql

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?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.