Solved

Create DSN for server in same forest but different domain

Posted on 2008-10-10
2
309 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

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

728 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