It is strange that the same site works fine with a different hosting provider, suggesting that there is nothing wrong with the code - per se.
I am a bit rusty with asp, but essentially, the response.write instruction was posted so you could view the sql on the page after it was created.
(i can't test for this, so i hope its ok), below line 82, try, for example... response.Write(rsCatSearchGW_cmd.CommandText)
on your page, any time after DataAssist has created the sql the code, you can write the code to the page using this method
as a debugging method, i occasionally do this, then take the sql statement and pass it into my database manually to check for any errors.
Perhaps someone from Webassist can help a bit more ?
Hope you don't mind me suggesting, on another subject, i notice your site is frame based.
I would urge you to move away from this if you want the site to be found by search engines