?
Solved

Create DSN for server in same forest but different domain

Posted on 2008-10-10
2
Medium Priority
?
311 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 750 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

Get MongoDB database support online, now!

At Percona’s web store you can order your MongoDB database support needs in minutes. No hassles, no fuss, just pick and click. Pay online with a credit card. Handle your MongoDB database support now!

Question has a verified solution.

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

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.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

762 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