2. ASPRunnerPro General questions
  3. Print Error
This topic is locked

Print Error

 		10/12/2007 11:25:48 AM
ASPRunnerPro General questions
D
 dlangham author

I am getting the following error when I try to use the Print button...any ideas?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The data types text and varchar are incompatible in the equal to operator.
/store2store/new/Store_2_Store_print.asp, line 204
Sergey Kornilov admin 10/12/2007

Dale,
it looks like you have a NTEXT field which is not used properly. Make sure NTEXT field do not participate in any lookups.
D
 		dlangham author 10/12/2007

Sergey,
Thats strange because all the columns are either Varchar or Datetime, I don't have any NTEXT fields at all, I have already looked into this via google and that came up with the same as you say, I will look into it more on Monday and if I cannot find anything I will upload it to the demo account and contact you.
Best Regards

Dale
D
 		dlangham author 10/15/2007

Sergey,
Just to let you know that I have found the issue, it was indeed a TEXT field in a table that I had forgotten about, sorry!!!
Regards

Dale