Thanks everyone for your input. I have learned that the default installation of SQLserver doesn't install the DBLIB. It has to be installed separately by,

1)Selecting SQL Server 2000 Components

2)Selecting Install...