Improve company productivity with a Business Account.Sign Up

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

ODBC Connection to Access using Windows Server 2008

Is there a driver download or work around to connect ODBC to Access on windows server 2008?
0
InvisibleTerror
Asked:
InvisibleTerror
  • 3
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
Since your did not state any specific  details on exactly what you are trying to accomplish (the type of data you are trying to connect to, the verson of Access,...ect), I will give you a generic answer.

If you want Access to connect to an ODBC data source, the program that you are trying to access must provide the ODBC drivers.
Then you will use the ODBC Admin tools in Windoows Server to make a machine DSN or a System DSN.

Then you will open Access and "Link" to the odbc data.

The program you are trying to access should have the documentation on how to do this for your specific installation.

JeffCoachman
0
 
InvisibleTerrorAuthor Commented:
Ok we are using access runtime on the windows 2008 box that is being setup to be web terminal server to connect to an access 2003 database on a windows 2003 server.  Installing the run time did not provide any drivers to make an odbc connection.  The only thing it has an option to connect to when setting up a system odbc is sql server.
0
 
InvisibleTerrorAuthor Commented:
Is there a way to get odbc drivers for server 2008 to make a connection to another server while only using the runtime of access 2003?
0
 
InvisibleTerrorAuthor Commented:
Since this was a 64 bit server there are no drivers available.  I ran the odbcad32.exe in syswow64 folder to run 32 bit applications.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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