Entry

Why do I get 'Unspecified Error' when I select a varchar column with all blanks using MyODBC and ASP?

Jan 26th, 2000 00:13
Nathan Wallace, Opec Kemp

This is the problem with Microsoft ADO design (it does not seem to occur
when using Mdac 2.1sp2 with the 3.7 driver for SQL Server and Microsoft
Visual Interdev 6.0 sp3). 

Basically it won't let you display the field that is a BLOB data type ie
VARCHAR, TEXT before on-BLOB data such as CHAR, INT etc. To get around
this you can:

1) Rearrange the way you display the result (ie make sure that you
display the non BLOB fields before BLOB fields)

2) Save the results into variables (in the above order ie fix->var size
data), then I *think* you can display the result in any order.

For more information here's the link from MS Knowledge base:

    http://support.microsoft.com/support/kb/articles/Q175/2/39.ASP
    PRB: 80020009 Error When Retrieving Data from SQL

Also you might want to check out these one as well, 

    http://support.microsoft.com/support/kb/articles/q228/9/33.asp
    FIX: 'Unspecified Error' Message Returned Placing a NULL in a 
         Non-NULL Column