SQL statement works in ISAPI in IIS 3.0 but not in IIS 4.0

Hi - I have written an ISAPI dll which queries a SQL Server database when it receives a POST request with the necessary parameters. However I get a DBException : Invalid column name "OCHOP" when the SQL statement is

SELECT * from table WHERE ib_stock_loc_no = "OCHOP"

Here the column name is supposed to be ib_stock_loc_no but it complains about an invalid column OCHOP !!

However this happens only on IIS 4.0 and not on IIS 3.0 !! I have SQL Server 6.5 on both the web servers running 4.0 and 3.0. And the ISAPI has been developed under Visual Studio 6.0.

Any help will be appreciated
Arun.

What data access technology are you using?

I am using the MFC ODBC classes CDatabase and CRecordset.

I have no idea if this helps but I use single quotes for the SELECT statement when I work with strings.
For. ex. SELECT * from table WHERE ib_stock_loc_no = 'OCHOP'.



Isac