It's MS SQL 7. While I was testing the setup process, there was no connection to the SQL server though. Could it be the cause?

>What version of SQL Server are you using? SQL 2000 requires MDAC 2.6
>
>>I try to distribute an application (EXE) along with the Sql ODBC driver. I wonder what runtimes and merge modules are required. I read through the help files but still got an error.
>>
>>My application (VFP7) is developed in client/server, with the MS sql.
>>
>>I use the Installshield Express - VFP limited edition. What I include are
>>- VFP7 runtime libraries (VFP7runtime.msm)
>>- MS visual C++7 runtime library (MSVCR70.msm)
>>- DCOM95 merge modules
>>- MDAC25 merge modules
>>- ODBC resources (Driver for SQL server, I also checked the box of DSN I am using)
>>
>>The error occurs at the end of setup process saying that it cannot load ODBC because the DSN I specify is not existing (wordings are not exact).
>>
>>Help is appreciated.