KB Issue

This will happen if you are trying to check to much data against a Query.

Issue Details

When running Queries against your database, if you try to throw too much data at the table, you will receive one of the following errors.

Microsoft OLE DB Provider for SQL Server error '80040e14'
The data types varchar and text are incompatible in the equal to operator.
/Inserts.asp, line 41

Microsoft OLE DB Provider for SQL Server error '80040e14'
The data types varchar(MAX) and text are incompatible in the equal to operator.
/Inserts.asp, line 41

Recreate Issue

When you run a Query against a Column in your database, and your Query has a lot of data, for example, over 500 Characters, this would be considered an overload on your server. And this will cause an error.

At this time, we are unsure how much data can be sent to a Query before this happens. However, we are open to testing and to the results being reported.

Resolve Issue

Minimize the amount of data being sent to your database Query. If you reduce the amount of data, you will prevent the Query from throwing this error, and it will then be able to continue the process without much strain on the server.