database inconsistencies

creating an asp page that deals with an sql database. the page should list all records in table x, but does not. if i deal with the database directly, then all records can be displayed. that is, "select * from x" does not work inside the asp, but works fine otherwise.

also, when i deal with the database directly, i have to "commit;" after each sql statement or the table reverts back to its original state after i log off.