Re: ODBC and remote server

[Jorma Tuomimäki]

Thanks, but for me it is not easy to build an InConnectionString for SQLDriverConnec(). I got syntax error trying to use the needed sshHost/sshPassword/sshUsername found in Workbech connections.xml.

I don't know which Parameter in Table 5.1 Connector/ODBC DSN Configuration Options corresponds sshHost, etc.

Can you show an example using those lines found in my connections.xml:

<value type="string" key="sshHost">extime.fi</value>
<value type="string" key="sshKeyFile"></value>
<value type="string" key="sshPassword"></value>
<value type="string" key="sshUserName">extime</value>
<value type="string" key="sslCA"></value>
<value type="string" key="sslCert"></value>
<value type="string" key="sslCipher"></value>
<value type="string" key="sslKey"></value>
<value type="int" key="useSSL">1</value>