MyODBC 3.51.11 problem

[Justin Kent]

Hi all -

Have had this problem before on new releases of the 3.51 driver.

Am running ADO & ASP on IIS and am using the 2.5 ODBC driver which works perfectly ok with all pages of my application. As soon as the latest driver is installed, the pages crash.

After investigation, it seems that any code assigning a variable or querying a NULL field in the DB table causes the problem with the new driver.

eg - I have recordset and one of the fields is a text field called 'Subject' and is NULL.

This:
Subject = rs.fields("Subject") ***
Or this:
if len(rs.fields("Subject")) > 0 THEN ***
response.write(rs.fields("Subject"))
end if

will crash on the asterixed line under the new driver, but works fine under the 2.5 driver.

If I bung 'on error resume next' at the top of the page that crashes, the script then seems to work, but this is not ideal as I have other error trappings on the pages.

Can anyone please explain why this problem occurs on any other driver other than the 2.5?

Thanks.