Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ODBC on DSN (Windows Server 2003)

Posted on 2009-05-04
8
Medium Priority
?
667 Views
Last Modified: 2012-05-06
I am trying to create an ODBC connection from a remote location. I have a MS Access table that I want to connect to a Progress Database (for Epicor's Vantage Manufacturing Software). I have created ODBC before but not remotely. I have the IP address, username and password to gain remote access to the server, what do I need to do to create the link to the Access table?

Let me know if I need to provide more info.
0
Comment
Question by:mmoore500
[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
  • 3
  • 3
8 Comments
 
LVL 3

Expert Comment

by:prachwal
ID: 24299475
network drive
access database is file only

Progress Database should have access to network drive with mdb file
0
 
LVL 2

Author Comment

by:mmoore500
ID: 24299618
I'm sorry, but I don't follow exactly. Can you elaborate?
0
 
LVL 3

Expert Comment

by:prachwal
ID: 24299825
I understood that you want to retrieve data from Access file under Progress Database

a way to access the database from a remote computer to a network drive - Shared Folder

0
Industry Leaders: 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!

 
LVL 2

Author Comment

by:mmoore500
ID: 24299946
Sorry, I actually want to use Access to retrieve data from the remote Progress database.
0
 
LVL 3

Expert Comment

by:prachwal
ID: 24300091
install ODBC client on each computer with database
unblock port on firewall (on server)
use ODBC and file DSN - you don't need create SYSTEM DSN or USER DSN on each machine
0
 
LVL 58
ID: 24304362
<<I am trying to create an ODBC connection from a remote location. I have a MS Access table that I want to connect to a Progress Database (for Epicor's Vantage Manufacturing Software). I have created ODBC before but not remotely. I have the IP address, username and password to gain remote access to the server, what do I need to do to create the link to the Access table?>>
  A good place to go for connection strings is:
http://www.connectionstrings.com
  With ODBC, if you supply all the required connection information in the connection string, then you won't need any type of DSN as was said.  The connection string you need varies based on what tool your using to connect (ie. DAO, ADO, or ADO.NET) and which way your going, which wasn't clear to me from reading your questions.
JimD.
0
 
LVL 2

Accepted Solution

by:
mmoore500 earned 0 total points
ID: 24488052
The connection to the database I was trying to connect to needed a specific driver. I made the connection, but not from a remote location. I just have to log onto the server via remote connection and then use the connection created on the locahost.
0

Featured Post

Industry Leaders: 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

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
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

609 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