SecureBridge, Unidac, remote server

[toneskok]

Hi.
I'm using Unidac 4.6.11 and SecureBridge 7.3.4. I'm trying to access MSSQL database over SSH tunnel. I followed instructions and installed CRSSHIOhandler and connected it to UniConnection.
I have SSH server already on remote network, SSH connection from SSHClient to SSHServer is working.
But when I try to connect to database (remote server IP,....) I get error that SQL server does not exists.
I also tried demo provided with Unidac and it also cannot connect to DB.
I think that UniConnection does not make request over CRSSHIOHandler and that is reason that DB server does not exists.
Or perhaps Unidac and SecureBridge versions are not compatible.

Any help appreciated.

Regards, Tone

[ViktorV]

Currently SecureBridge supports integration with UniDAC only when using MySQL and PostgreSQL providers. Therefore, unfortunately, you will not be able to connect to SQL Server through SSH using UniDAC and SecureBridge components.

[toneskok]

Ok, that is not good for me since I purchased components just for that reason (and did not read support specifications through). Are there any plans to support other providers? I'm mostly using MSSQL in Firebird providers for my clients.

Btw, I solved problem using SSHChannel and local port forwarding capabilities of channel to connect to remote database. UniConnection connect to localhost on port xy and channel reroutes all traffic from that port to remote sshserver and remote IP. My solution works, can I expect some problems with that configuration?

[ViktorV]

MSSQL before connecting through TCP/IP can use UDP protocol. In this case, it is impossible to organise the work using local port forwarding. If a connection to the server is direct - everything should work correctly.
We will consider adding compatibility of SecureBridge and UniDAC when using SQL Server in Direct mode. Adding this support when working with InterBase provider won't work out, because UniDAC interacts with InterBase/Firebird using the client library.

[toneskok]

Ok, I understand that connecting to remote DB over SSH only with SSHClient, UniConnection and SSHIOHandler connected is limited because of using external library. In case of Direct mode I see that it can bo done.
But somehow I don't agree with you that I could not manage to connect to remote FB over SSH. If SSHClient component is working like putty works then I could solve it same was as I did with SSHChannel.
This can be done with putty with no problem when using port forwarding capabilities of client.

I will try same config but DB is going to be FB on remote server. I'll post here results.

Thanks for help.

[ViktorV]

Perhaps you misunderstood us. We meant that using local port forwarding will work correctly when connecting to Firebird. And it is not possible to connect to Firebird using CRSSHIOHandler.