Problem with Special Charecters in ASP and SQL Server

[priyam1309]

I am currently using ASP and SQL Server 2000. The problem is when i try to insert data with special characters like - / , into DB through textboxes of ASP webpage, the data does not get inserted. whereas, when I insert the same data directly in DB through SQL queries, it gets successfully appended in the table.
Please advice what is going wrong?

[jhardman]

sorry for the long delay. How are you inserting the data? When I insert data, I like to use a recordset object, add a new record to the recordset, and assign the different fields independently, then update the table from the recordset. This method should have no problems.

Jared