xMII 12.0 SQL connections
I've searched the forms and I've looked at the questions regarding setting up SQL 2005 connections. I haven't been able to find a solution. Here's the information on my connection:
InternalDateFormat yyyy-MM-dd HH:mm:ss
ValidationQuery SELECT GETDATE()
When I click on status it tells me that the status is "Running" and I have no available connections. I attempted to execute a SQL transaction and I get a "Cannot create a connection to the database" error in the Netweaver log. I uploaded and deployed the sqlodbc.jar file from the Microsoft site.
Any help would be appreciated.