Solved

ODBC on DSN (Windows Server 2003)

Posted on 2009-05-04
8
652 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
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
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
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 57
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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Auto Filter in Combo Box 7 31
Error when loading the database 16 54
Open CSV, modify and save as xls from Access 12 19
Exchange 2010 Database wont mount 3 15
Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

919 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

21 Experts available now in Live!

Get 1:1 Help Now