Hi. We are using Microsoft SQL Server 2000 for our webMethods databases/tables.
When I setup my connection pools I used the driver:
DataDirect Connect JDBC SQL Server Driver
(com.wm.dd.jdbc.sqlserver.SQLServerDriver)
Here’s the pool alias I setup:
Alias Name: Dev_Audit_ConnPool
Associated Driver Alias: DataDirect Connect JDBC SQL Server Driver
Database URL: jdbc:sqlserver://AUG-SQL70\AUGSSQL12:1433;databaseName=wmaudit;SelectMethod=cursor
Minimum Connections 5
Maximum Connections 40
Idle Timeout 60000 milliseconds
I then associated this pool alias with the functions names: ISCoreAudit and ProcessAudit. When I press the Test button I get the message “Test successful”.
So far so good right ?
Well for some reason when I try and view my server error logs (view the web admin client) I get an exception, and the rows in the WMERROR table do not appear. I know there are rows in this table since I ran my own SQL query.
I decided to give the native Microsoft SQL Server 2000 Driver a try, so I setup a new Driver alias and used the class com.microsoft.jdbcx.sqlserver.SQLServerDataSource
and then setup a new pool alias using this driver alias. Here’s the new pool alias I setup:
Alias Name: WaynesTestAlias
Associated Driver Alias: Microsoft SQL Server 2000 Driver
Database URL jdbc:microsoft:sqlserver://AUG-SQL70\AUGSSQL12:1433;databaseName=wmaudit;SelectMethod=cursor
Minimum Connections 1
Maximum Connections 40
Idle Timeout 60000 milliseconds
I associated the new pool alias to the ISCoreAudit and ProcessAudit Function Names.
I then restarted the Integration Server.
I can now view the information in my Audit, Error, Server and Session logs via the web admin…HOWEVER if I try to Test the function alias definitions using the new pool alias I get the error:
Test of <function> Failed
No suitable driver
Any ideas ? Note: the ms*.jar files are in my Integration Server \lib\jars folder.
Is it “better” (recommended) to use the Microsoft drivers for SQL Server or the DataDirect drivers ?
Regards,
Wayne