Solved

ODBC on DSN (Windows Server 2003)

Posted on 2009-05-04
8
651 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
  • 3
  • 3
8 Comments
 
LVL 3

Expert Comment

by:prachwal
Comment Utility
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
Comment Utility
I'm sorry, but I don't follow exactly. Can you elaborate?
0
 
LVL 3

Expert Comment

by:prachwal
Comment Utility
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
Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 2

Author Comment

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

Expert Comment

by:prachwal
Comment Utility
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 57

Expert Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Comment Utility
<<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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article explains all about SQL Server Piecemeal Restore with examples in step by step manner.
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now