Sounds like an issue with the proper access rights. Do you specify an account and a password when you connect to the database. If the answer is yes, please make sure that it's the same for your local and the server system.
If you are using integrated security you'll have to administer the database with the proper right for the account your webpage is running under. It is really strange though that you are not receiving any error messages.
I think you should add logging liberally in the parts that are doing the SQL stuff. You can use any kind of logging API, but I suggest you look into
log4Net[
^] an offspring of
log4J[
^].
[Edit]
You said you are using the same database. So you are connecting to the same DBMS server from your local project and the server side?
[/Edit]
I hope this helps some.
Cheers!
-MRB