>When I distribute the compiled application an OLE error is display "OLE IDispatch exception code 0 from Microsoft OLE DB Provider for SQL Server: Unable to load communication module. Driver has not been correctly installed." I'm using the SQLOLEDB.1 provider.

Hiya -
check your ole db drivers on your development machine, and check your ole db providers on your clients' workstations. Make em match. Get a good mdac distribution and deploy it.

Are you using a system DSN ? or a connection string ?

hth - mondo regards [Bill]