I feel your pain! Time for a stupid question: What db is the 3rd-party running? Reason I ask is what I read here:
http://technet.microsoft.com/en-us/library/dd239343.aspx
Support for features such as parameters and credentials are dependent on the data provider that you select.