I'm trying to fetch informations from a Sybase database to show it in a SDP text field. Any ideas how this be achieved?
I have an ODBC connection from the server running the SDP to the Sybase Server.
You are going to have to use the dap probe and setup your connection in there once you have it setup there it will show up in sdp.
Thanks for the tip, I'm going to try this out.
I must however investigate in how to fill in the parameters "Driver" and "URL". I have installed the JConnect 6.0 from Sybase, but I'm still a bit confused how to specify the driver.
BTW: The variable_server may be used as well, as long as you know how to specify the Connection string
After some testing I finally managed to solve this! After installing the Sybase Connectivity 6.0 software on the computer running the DAP probe i copied the two files jonn3.jar and jTDS3.jar from <Sybase install directory>\jConnect-6_0\classes to <NimSoft install>\probes\service\dap\jar.
When configuring the DAP create a new data source with the following parameters:
URL=jdbc:sybase:Tds:<Sybase server>:<connection port>?ServiceName=<Sybase DB>
Retrieving data ...