Problem Setting up ODBC Connection on Windows 2000 Workstation

Question posted by: fperri (Member) on July 24th, 2008 05:07 PM

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

Not the answer you were looking for? Post your question . . .
190,078 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).