Solved

SQl Server access

Posted on 2013-01-30
2
369 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 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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

696 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