Connecting Tech Pros Worldwide Forums | Help | Site Map

Problem Setting up ODBC Connection on Windows 2000 Workstation

Member
 
Join Date: May 2007
Location: Idaho
Posts: 88
#1: Jul 24 '08
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

Member
 
Join Date: May 2007
Location: Idaho
Posts: 88
#2: Jul 31 '08

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 Microsoft Windows / Vista / XP / ME / 95 & 98 bytes