We have a program (Hindsite) that we're using on our LAN. It uses ODBC to access data on the server from client PC. Hindsite directory on the server is mapped drive on each client in the office.
We would really like to be able to access the same program database on the server from the remote PC over the internet.
Can SQL Native Client do that?
What would be the best way to accomplish it?
How to make this application to be able to access it's directory on the server over the Internet like it was a mapped drive on the remote PC?
Thank you very much in advance.
SQL native can do that.
You need to make sure your server is accessible from remote site, either via direct internet connection or via "middlebox", such as NAT. As long as you can ping and telnet to your server machine from the remote site, you can use SQL native client to connect to your sql server.
|||thank you very much for your advice.
I'll try that, hopefully it works.
one thing I don't understand - when the program asks for a directory on server what do I need to direct it to when I install it on the remote computer?
thank you again.
|||Can you be more specific.
No comments:
Post a Comment