Hi,

I have setup the MS SQL 2000 database and setup one form for insert query to insert some personal details. But the when the detail contains special character like #,?,=,/ etc.,, database throws the error message. Like:

Some details withspecial character # sp. #

How can I resolve this problem?

Recommended Answers

All 2 Replies

Are you using parameterized SQL? Post the code where you are inserting the data and post the sample data that is causing the issue.

Also paste the _full exception_ thrown.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.