A VFP COM dll is 32-bit. A 64-bit SQL Server cannot access 32-bit COM dlls.
>
>I have an app server and DB server as follows
>
>1. App Server on Windows 2008 32 bit
>
>2. DB Server on Windows 2008 64 bit
>
>I have stored proc that calls VFP COM on the DB Server
>
>I am not able to get the VFP COM to work on the DB Server running Windows Server 2008 64 bit
>
>Your urgent advice very much appreciated.
--sb--