>I'm not sure I understand the <*wince*> in your reply.

Oh, it was just one of my least-favorite things to explain to customers when I was in PSS.

>I really don't mean to cause you pain :-)

Hey, why should you be different from anyone else? <*gd&r*>

>But do you know if there is any workaround other than just making sure that the
>DSN is not set to fetch data in background? Can I programatically set Fetch data
>in background OFF before executing SPT queries in case the DSN is not properly set
>up?

Yes, I think so: I don't remember offhand how to set this for a DSN, but you can always use SQLSTRINGCONNECT() instead, and pass the "BackgroundFetch=No" clause in as part of the connection string.