Database Connection Character Limitations

Home Forum Integrating PerfectForms Database Connection Character Limitations

This topic contains 1 reply, has 0 voices, and was last updated by  MABrown 7 years, 8 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #731

    MABrown
    Participant

    I have an issue with a form that updates a database. I have found that, when sending text with certain characters to the database, the update behavior fails and the error “An error has occurred. Invalid request parameters” is displayed.

    Characters that can cause this problem include quotation marks that are not straight (such as MS Word’s Smart Quotes), the ellipsis character, Em dashes, etc.

    I believe this is a PerfectForms issue, as the Database is able to handle the characters. In fact, PerfectForms is able to retrieve the characters from the database and display them without any problems; the error only occurs when trying to update the database. Are there any ideas as to why this might be? Is there any documentation regarding what characters the Connection Agent can and cannot handle?

    #5659

    You are seeing error code 231: Invalid request parameters. Our troubleshooting documentation at: http://www.perfectforms.com/Documentation/manual/html/?admin_connection_agent_troubleshooti.htm. says the following:

    Database ID and/or Datasource ID are not in the request. This means the connection is not correctly configured in the connection details screen (if this occurs in ConnectionEditor when using

    “Check” button) or the connection is not correctly saved (if this occurs in Player or MainEditor).

    We have tested inserting the following text (‘“Smart quotes” “plain quotes” en dash (–) em dash (—) ellipsis (…)’ ) into SQL server using ConnectionAgent.

    The result: success. All characters have been inserted into the database.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.