[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 385
  • Last Modified:

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.
0
Cdwalter
Asked:
Cdwalter
1 Solution
 
chaauCommented:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now