?
Solved

SQl Server access

Posted on 2013-01-30
2
Medium Priority
?
374 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
chaau earned 1500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

764 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