We recently purchased the 2 new MS integration products, SpreadSheet Client and SQL Adapter. Whilst installation and set up of the Spreadsheet Client was a simple plug and play exercise the SQL Adapter was not so pleasant. It has taken nearly two months to finally get it working so I thought I should pass on some tips to saves others some headaches.
To get the product installed refer to the IBM install document ...
http://www-03.ibm.com/systems/resources/DB2_Web_Query_Install.pdf
Ensure that you have the very latest PTFs installed.
For setup refer to the IBM Using SQL Adapter document ...
http://www-03.ibm.com/systems/resources/db2_webquery_sqlserver.pdf
There are two key pieces of information the above document does not provide. That is the jdbc driver name and the syntax to use when setting up the connections. For those I would refer to the document provided on this forum ...
http://www.ibm.com/developerworks/forums/thread.jspa?threadID=279290&tstart=0
Adding to the document above, if you have multiple (named) instances of MS SQL on the one server then you will need to change the port no. to something other than the standard 1433. There are various Microsoft documents on this subject.
If after all of the above it is still not working then perhaps you have the same problem that we had. I expect this will particularly apply if you are not using WebSphere.
There is a file that needs to exist in the IFS. It is called SystemDefault.properties
It needs to exist in either ...
/QIBM/USERDATA/JAVA400/
or
/home/QWEBQRYADM
That file must contain the following line and it must be all in lowercase ... java.version=1.5
