>>>>>>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.
They actually have SQL Server 2005 Express. But I prefer to use the SQL 2000 ODBC driver.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
