>>>>>Hi,
>>>>>
>>>>>I am going to be at a customer site to test a VFP application with SQL Server database. I need to make sure that they have SQL Server 2000 ODBC driver installed or install it. I know how to check if it is installed. But if they don't have it installed, I Googled for this driver and found a link that gives me a download of SQL Server 2000 SP 3a. Do you know if this SP is actually the driver or the driver has to be installed first? This is the link to the SP:
>>>>>
>>>>>http://www.microsoft.com/downloads/en/details.aspx?familyid=90dcd52c-0488-4e46-afbf-acace5369fa3&displaylang=en&pf=true
>>>>>
>>>>>TIA.
>>>>
>>>>See this link to Download Link to MDAC components
>>>>
>>>>from this discussion Suggestion by Erland Sommarskog (SQL Server MVP)
>>>
>>>Thank you. So even though it says MDAC it will install ODBC driver.
>>
>>Yes. What is OS of the customer? Most likely it's already installed.
>
>They have XP SP3. You think there is a good chance they already have it installed?

Yes, 99% chance.

BTW, make sure to install the latest SP for SQL Server 2000 and it seems to be SP4.