So, I have setup a System DSN within the Server ODBC system and I have created a DSN with the same name in the Database subsystem on CRS to let my script access the DB server.
The problem is when I add the DB Read step and select properties there is no DB in the drop-down box. Clicking on Refresh DB schema yields the following GetDataSource Error: java.lang.Exception: Remote Error: java.rmi.NotBoundExeption: com.cisco.wf.subsystems.edbs.RemoteSubsystemEDBS
I must be missing something. The SQL database resides on another server but the ODBC DSN test completes sucessfully.
Any ideas?