HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||I have done the same step to connect to SQL through ODBC on windows XP pro. But I have 4 other PC which is run under windows 2000 that unable to connect the SQL server. It just counldn't find the server at all.|||
Hi GAN2006,
Like Jens asked, you'll need to post the exact error message that you're receiving. Also, providing your connection string and indicating which driver you're using (SQL Native client, MDAC) would be helpful. Please take a look at this guideline for insight on the type of information that'll make problem determination easier: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1
Thanks,
Il-Sung.
I think I have faced the same problem.
All you need to do is to install MDAC 2.8. This is because SQL 2000 connector in windows 2000 is not there or not working properly. Install MDAC 2.8 and it shall work. For windows xp, you dont have to because by nature it already have mdac 2.8 components.
