Create Remote ODBC over Internet???

[byrne1]

I am looking into ways that I can get data to my internet provider. One possibility that I was considering (I really don't even know if it's possible) was to create a remote ODBC connection from their internet server to my database. Both of our networks are behind firewalls so I would imagine that we would have to open up a port or two.

Is this advisable or should I look for another way to get this done? I thought about building an XML file and then porting that to their server every night but we're talking about a lot of data and multiple files/tables.

 

[k5tm]

If your internet provider provides secure shell (SSH) access, then you should be able to create a tunnel from your secure shell client to your host. I do this fairly often using SSH Secure Shell, MyODBC and MySQL. This ends up looking like an ODBC datasource on the client, but the MySQL database is on the remote server, tunneling through SSH.

This would be a much better approach than opening up ports without a high begree of security in place.

Tom Morrison

http://www.liant.com