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.

[Posterboy]

What data access technology are you using?

I am using the MFC ODBC classes CDatabase and CRecordset.

[isac]

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