Lasso Soft Inc. > Home

RhinoTrac

LassoSoft Ticket Tracking System

NOTE: If you are using Lasso Server 9.3 please Log your ticket directly via the LUX admin as this will give us more information about your issue.

Lasso 9 Issues



Ticket #7264: SQL Server -sql fails with escape chars

Reported by:
Paul Higgins
Date:
28 Oct, 2009
Priority:
minor
Component:
Lasso 9
Version:
Keywords:
Platform:
Using FreeTDS ODBC.

Query fails when using -sql and a characters is escaped. The resulting error indicates that the characters was not, in fact, escaped.

Comments

28 Oct, 2009 by Paul Higgins
SQLAPIDS: DBMS error 8180: 42000 [FreeTDS][SQL Server]Statement(s) could not be prepared.
42000 [FreeTDS][SQL Server]Unclosed quotation mark after the character string ' )'.
42000 [FreeTDS][SQL Server]Incorrect syntax near 'peux'.
04 Nov, 2009 by Paul Higgins
I think this has to do with SQL Server escaping ' with ''.
Please log in to your LassoSoft account to comment

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft