Solved

SQl Server access

Posted on 2013-01-30
2
348 Views
Last Modified: 2013-01-31
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
Comment
Question by:Cdwalter
2 Comments
 
LVL 24

Accepted Solution

by:
chaau earned 500 total points
ID: 38838015
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
 
LVL 1

Author Closing Comment

by:Cdwalter
ID: 38840328
I found another solution but this one would have worked also
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now