Connection Failed

[dburnham]

I have been asked to install a program where I work based on parameters provided by our Payroll Department. The program is called PAYBASE and works through the Microsoft SQL Server. I am working on a PC running Windows 2000 Professional.

I have gone into the ODBC Data Source Administrator/System DNS tab. From there I configured the Name, Description and SQL Server as described by our Administrator.
On the next screen I have selected "SQL Server Authenticationusing a login ID and password enter by the user." I have checked the "Connect to SQL erver to obtaindefault settingsfor the additionalconfiguration options." I have also set the user ID and Password. When I click Next I get the following message:

Connection Failed:
SQLState: '080001'
SQL Server Error: 1
[Microsoft][ODBC SQL Server Driver]Client unable to
establish connection

Connection Failed:
SQLState: 'HY000'
SQL Server Error: 126
[Microsoft][ODBC SQL Server Driver]Unable to load
communication module. Driver has not
been correctly installed



I appreciate any assistance that you can provide,
David

 

[tlbroadbent]

You'll probably need to reintall MDAC on the PC. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[dburnham]

I have tried to reinstall MDAC. I have another post in the Windows 2000 forum asking for help on that. When I try the installation I receive a message that starting with windows 2000 the MDAC must be installed/upgraded as part of a Service Pack. I down loaded MDAC2.1 Service pack 2. I received the same message trying to install that.??

Thanks,
David

 

[pmanivas]

yes, for win2k you can't install mdac separately. but u can install it as a part of service pack(SP).
check the SP version the machine and reinstall the sp. this would reinstall mdac
let me know if it helps

 

[dburnham]

How do I check and then reinstall the SP. I downloaded the Component Checker from MS. I was able to use this to verify my MDAC version only.

 

[pmanivas]

just go to Windows explorer. Under Help menu click on about. It would show u the version

 

[pmanivas]

or you can run winver at the command prompt