[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 669
  • Last Modified:

ODBC on DSN (Windows Server 2003)

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
mmoore500
Asked:
mmoore500
  • 3
  • 3
1 Solution
 
prachwalCommented:
network drive
access database is file only

Progress Database should have access to network drive with mdb file
0
 
mmoore500Author Commented:
I'm sorry, but I don't follow exactly. Can you elaborate?
0
 
prachwalCommented:
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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
mmoore500Author Commented:
Sorry, I actually want to use Access to retrieve data from the remote Progress database.
0
 
prachwalCommented:
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
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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
 
mmoore500Author Commented:
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now