When you setup your ODBC connection, it allows you to change the ANSI settings, try changing those around.
______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Trusz, Andrew [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:20 AM To: CF-Talk Subject: porting cf We're trying to port from NT4, CF4.0 to Sun Solaris 2.8 running CF 4.5. Case has been checked, the datasource is verified. The query referred to in the error is: (about as basic as it can be) <CFQUERY name="sort" datasource="dsel" dbtype="ODBC"> select * from dsel </CFQUERY> The error message is: Error Diagnostic Information ODBC Error Code = S1000 (General error) [MERANT][ODBC SQL Server Driver]Unicode conversion failed The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (13:1) to (13:53). Date/Time: Wed Feb 06 11:00:42 2002 Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461) Can this be done or is the Unicode simply easier to deal with by rewriting on the Solaris? ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
