Text/Byte host variable error.
Posted in 1999
Topics: Error Codes & Troubleshooting, Connectivity: ODBC / JDBC / .NET
Good Monday Morining! I have a form that faculty fills out to populate a searchable database called the Experts Directory. Here's my problem. When members input their information, they sometimes put carriage returns (hard returns) in the text area boxes. The info inputs into the database just fine. When they want to edit the info, a form just like the original one they filled out comes back with their current info inserted into the boxes for editing. For some reason, even if they don't change anything in the textarea box, if there are carriage returns (which were put in before or if they add any) the process pukes. I get the following error: ODBC Error Code = S1000 (General error) [INTERSOLV][ODBC Informix driver][Informix]Illegal attempt to use Text/Byte host variable. Does anybody know if this is an Informix error or an ODBC error? We're using Cold Fusion 4.0 on NT, connecting through InterSolve ODBC to Informix on Unix. Up till now it's worked great, except for this quirk. Any clues? I have all the textarea boxes set to wrap="virtual" but that does not help. TIA Dave Hannum Web Analyst/Programmer Ohio University hannum@ohio.edu