SQl Server access

I have developed an access database that uses SQL Server. I have a need for the users to access the database on the same laptop from both inside and outside the network. I can make the ODBC connection from inside by using internal IP address of the server 192.168.x.x\sbs2011 and I can access from outside the network by entering public IP 24.24.X.X\sbs2011. I need to be able to setup one ODBC connection that works both inside and out.

remote.domainname.com \sbs2011 does not work even though it resolves to the correct IP address.
LVL 1
CdwalterAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
chaauConnect With a Mentor Commented:
you can add an entry to the Windows hosts file, like this:

192.168.x.x ServerName

Open in new window


And then you can setup the ODBC DSN to use ServerName instead of the I address.

Then you need to use a simple hosts file switcher program (there are many out there) that will switch the hosts file to use

24.24.x.x ServerName

Open in new window


the user will have to then use the program to switch hosts file according to their location
0
 
CdwalterAuthor Commented:
I found another solution but this one would have worked also
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.