Connecting SQL Server 2000 through JDBC Adapater

, ,
1

:confused:
Hi everybody…
i facing the problem while enabling the JDBC Adapater :which has
the following connection properties
i am using windows 2003 server OS
Transaction type :Local
Datasource Class:com.microsoft.jdbcx.sqlserver.SQLServerDataSource
ServerName:192.168.0.51 (i tried with Name also “Webfmis2”)
User :Sa
password:sa
password:sa
databaseName:WMDB
portNumber :1433
networkProtocal:
Other Properties:SelectMethod=cursor

management properties
True
1
10
1000
1000

and i have copied Threee Jar files in ishome\lib\jars & F:\Program Files\webMethods6\IntegrationServer\packages\WmJDBCAdapter\code\jars folder also still i am facing a Error while enabling it .

Error Name is :Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource FlowServices:MsSQLConncection.[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.iaik.asn1.structures.NameCan anybody give the solutions for this problem…I tried a lot of combinations…but its not working…Thanks a lot…Plz let me know the solution for thisRegards

2

Hi there!

everything is perfect. I feel the server name what you have entered was the system URL. You should enter database server name there. Hope it will resolve the issue.

regards,
zakir