Bonnie,
>Hey Kris ... how the heck are ya?
Still kicking... and screaming. :-)
>I'm just taking a stab in the dark here, but do you have the most current version of the OLEDB driver on that particular server? I thought I remember there being some problems with older versions (but I could be hallucinating I suppose <g>).
You're probably not hallucinating; I remember something about that too. The DLLs on the server that works and the one that does not are identical. Both are one year old and are dated 9/25/2003. I don't see a newer version posted. MDAC is version 2.8 on both machines.