Dial Up Connections

[elmo29]

is it possible to access sql server on a remote machine from a dial up connection (using vb6) without sql server being installed on the local computer? - and how do you go about this - is RAS, RDO, TCP/IP etc the way to go?

Thanks in advance :O)

 

[foxdev]

We've touched on this briefly in thread183-63538. Basically, if you can establish a connection where you can use TCP/IP (which you normally would using an ISP), then you should be able to connect to an SQL Server. You'll need the server's IP address, and you'll need the SQL Server driver on your machine and set it to use the TCP/IP protocol (not Named Pipes).

Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[elmo29]

I have been having a look on the internet and there is an MS Remote option for ADO do you know if that has the desired result??