Hi, I have setup JDBC and I am able to connect to a MySQL database just fine. But I can't connect to MSSQL SQLExpress 2005.
I got the sqljdbc.jar file placed it under the LiveCycle8\jboss\server\all\lib folder and setup the Datasource file as:
MSSQLDS jdbc:sqlserver://LIVECYCLE\SQLEXPRESS:1433;databaseName=MyDBName
com.microsoft.sqlserver.jdbc.SQLServerDriver
username
password
MS SQLSERVER2005
---------
Then I modified the login-config.xml and added the application-policy as:
username
password
jboss.jca:service=LocalTxCM,name=MSSQLDS
------------------
Then in LC connection, setup the string to java:/MSSQLDS
When running the test query b I get NO Response At All. And I mean, even if I intentionally change the datasource file to hold incorrect information, I'll get no response. However, I can connect to MySQL without any problems.
b Any ideas?
Thanks for any help!