Solved

Create DSN for server in same forest but different domain

Posted on 2008-10-10
2
306 Views
Last Modified: 2012-05-05
I have an Access front end to a SQL server database that I am distibuting to users in two domains within our forrest, along with a file DSN to enable the Access app to connect to the server. Users that are in the same domain as the server can use the application without any problem. Users in the other domain report ODBC errors. I have VPNed into their machines and tried to set up system DSNs 'manually'. When I do, I get to the dropdown box that shows the list of servers and they can only see the servers withing their domain. I get this on all the machines I have looked at so i assume it's not a probblem local to their individual machines.

How can I create a DSN that will  work accross domains?
is there another way of connecting the Access app to the server?
0
Comment
Question by:Blim2
[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 13

Accepted Solution

by:
adraughn earned 250 total points
ID: 22688590
when you create the dsn connection, use the server IP address instead of the server name. You will also need to change the connection string property on any pass thru queries you may have.
0
 

Author Comment

by:Blim2
ID: 22728930
In fact there were permissions issues as well, but using the IP address looks like a better oprion.
Thanks
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
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.
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

733 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