Use this syntax to open your Crystal.Application
Set m_objCrystalApp = New CRPEAuto.Application
m_objCrystalApp.LogOnServer "P2SODBC.DLL", DSN Name, , "UserName", "Password"
This should fix the problem. Crystal also expects you to open the crystal app when you open your VB app.
When your clients open your report they will have to have the DSN setup on their computer.
P2SODBC.DLL is used for ODBC compliant databases. There is another DLL for non-compliant databases