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.