I am developing a web site application that I had hoped to host on an external site. So, I thought I would write a little test application to see if I could create the tables and access them. I could access the sql server hosted on the external site.
My question is: When I run the site from the hosted site, should I be able to also connect to my local sql server? I was thinking I would be able to have a connection to both and transfer data.