Make sure you read them in the order you add them to the SELECT statement, and access them after all the other columns.

See this KB for more information: http://support.microsoft.com/kb/q175239/ (maybe a driver update fixes the problem).

Otherwise, execute a separate query for the BLOB columns....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hello Imar,

GREAT HELP!!!!
It works perfectly now. I just changed the order in select query to match the order in which the fields are accessed and it works fine. You have been a great help Imar. This is the best help I have ever recieved in any forums till date. This is superb. :)

Thanks a lot again,
Palvin

You're welcome. Glad it's working now.

This is an obscure bug / by design issue that I ran into a couple of times in the past. If you don't know the problem exists, it's very difficult to find out what's causing it. Once you know it however, the fix is easy...... ;)

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Sorry by Madonna (Track 3 from the album: Confessions On A Dance Floor) What's This?

Well I am glad that I ended up asking it here. I owe you one my friend. Thanks again.

Palvin