Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[aaronline]

I work for a small business and I am trying to add a product to the website but I am getting this error.

HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services

Technical Information (for support personnel)

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement.
/ecommerce/includes/databaseFunctio ns.asp, line 83

Browser Type:
Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:70.0) Gecko/20100101 Firefox/70.0

Page:
POST 835 bytes to /ecommerce/backoffice/comersus_backof fice_addProduct Exec.asp

POST Data:
sku=NLMAGSET01& description=MAN ET%2C+SPRING%2C +WOMAN+W%2F+CAT-+2+PIECE+MAGNET +SET&details=%3 Cp%3EBeautiful+ set+of+2+Manet+ hard+magets+on+ cream-colored+backer+ card.%3C%2Fp%3E %3Cp%3EMagnets+ measure+2.5+x . . .

I worked here for two years and have never seen this before...I'm not a developer or anything, but I do know how to edit a few files in the FTP. Anyone know why this is happening?

[Rabbit]

It's not anything you did (mostly), the error lies on the people that coded the web page.

They have an error on line 83 of the page databaseFunctio ns.asp. Whatever code they wrote to insert data into the database broke. Most likely because they didn't anticipate the length or type of data the user was going to try to insert into the table.

There's (mostly) nothing you can do to fix it on your end. You'll have to get in touch with the web page developer and tell them to fix it on their end.

** When I say mostly, I mean that there may or may not be a way for you to work around the bug in their programming. But rather than work around it, the web page should be fixed to accept your input.

For example, if they didn't anticipate that you would insert text with single or double quotes, that could cause an error on their end. In which case, you can work around it by not using those characters.

Another example is if they didn't anticipate such a long string of text being inserted. Then you can work around it by shortening what you're trying to insert.