Solved

ODBC on DSN (Windows Server 2003)

Posted on 2009-05-04
8
663 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
What Is Transaction Monitoring and who needs it?

Synthetic Transaction Monitoring that you need for the day to day, which ensures your business website keeps running optimally, and that there is no downtime to impact your customer experience.

 
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
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…

726 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