Connecting Tech Pros Worldwide Help | Site Map

Problem Setting up ODBC Connection on Windows 2000 Workstation

  #1  
Old July 24th, 2008, 06:07 PM
Member
 
Join Date: May 2007
Location: Idaho
Posts: 88
Hi,

I am trying to set up an ODBC Connection on all of my workstations to an SQL Server (Developer Edition) database so that it can be used in Microsoft Access.

I have had no problems with setting up the ODBC Connection on my Windows XP workstations. When I try to set up the ODBC Conncection on the Windows 2000 computers - specifically the step where you select the server you want to connect to - it only shows me local machine or the name of our network server (not the SQL Server) - So I tried the network server and I get the response "Specified SQL Server not found"

Does anyone have any ideas what I might be doing wrong or if there is something that I can do to get this to work? Is Windows 2000 just not able to pick up the SQL Server - or is there some other setup I must do first?

Thank you in advance.

~ Franccesca
  #2  
Old July 31st, 2008, 06:20 PM
Member
 
Join Date: May 2007
Location: Idaho
Posts: 88

re: Problem Setting up ODBC Connection on Windows 2000 Workstation


Nevermind. I found a driver that I need to install on the Windows 2000 machines.

~ Franccesca
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
DSN-less connection RLN answers 1 July 19th, 2007 04:55 PM