Invalid JDBC Driver for MS-SQL Server 2000

[sergi.monroy.20431]

Hi!!
I’ve downloaded JDBC driver for MS-SQL Server 2000 from Microsoft, but I have an error:

com.wm.app.b2b.server.DBConnectionException: No suitable driver

I’ve tried to stablish a communication through a Java class and it runs properly.

Any idea about?

Thanks a lot.
Regards, Sergi.

[alexis.ramirez.38825]

What is the webMethods version?

You must to include a parameter

embeddge = true in TN

[rob.crawford.39200]

webMethods cannot read the jar file created by the install so you have to unzip the jar file. The install creates several jar files in the server/lib/classes/lib directory. Unzip the mssqlserver.jar file which will create a folder server/lib/classes/com/microsoft.

[eduardo_souza.39205]

I’ve tried all those but not work at all and there isn’t such server/lib/classes/lib directory…only server/lib

[carl_caldwell.39210]

You can download the Microsoft SQL Server 2000 JDBC driver from http://msdn.microsoft.com. After you install, make sure to set the classpath variable properly. It comes with a couple of pdf files that give you the appropriate format for the url ad connection string.