Hi,

This is in relation to one of the mods for snitz. Snitz Personalization. We moved to windows 2008 and are presented with a lot of problems. Most are taken care of fortunately or being taken care of. However, this one I can't figure it out.
Basically the database table is not being updated after the code is ran. The site is reading the tables just fine and is writing to all other tables just fine, just this one is giving me grief. Here is a text version of the asp page that is not updating the database:

http://www.coastercrazy.com/forum/my_edit_config.txt

If I manually add to the table, the site will read the table and display things correctly. However, if you log into the website and click any of the theme switching icons on the home page right below the menu on the right, it will tell you that it was updated successfully, however, it does not because you are still left with the default theme. Below is info to login and test it out for yourself:

Demo Account: SnitzTest
password: testtest

This code was working just fine on windows 2003 and sql server 2000. We moved to windows 2008 and sql server 2008 and this problem presented itself. I have deleted that specific table and recreated it manually and it did not fix the problem. I also deleted that table again and ran the dbs file for it and stil did not solve the problem. I am thinking maybe there is some code incompatability? Can someone please view the code linked above and see if there is anything that should be changed so it is windows 2008 and sql server 2008 compatible?
We thought maybe a trigger of the db was missing so I reexported the stored procs from the original db and imported them back into this db we have live now and still no fix. I appreciate any help you can provide on this situation.
Thank you,
Oscar