Re: Unclosed quotation mark

Please read the User Guide section on logging:

<http://www.freetds.org/userguide/logging.htm>


On Jul 24, 2014, at 1:15 PM, venkata krishna Thaluru <[email protected]> wrote:

> Hi Frediano,
> Can you please check and reply .
> 
> Thanks
> Venkata krishna
> 
> 
> On Wed, Jul 16, 2014 at 11:22 PM, venkata krishna Thaluru <
> [email protected]> wrote:
> 
>> Hi Frediano,
>> I am passing sql query to free TDS and we are using free tds driver only
>> .Could you please let know any steps ?
>> After changing data type varchar to long varchar ,it is working fine .
>> whether do we have any  bugs in free TDs and addressed in later version
>> .Could you please share it.
>> 
>> thanks
>> Venkata Krishna
>> 
>> 
>> 
>> On Tue, Jul 15, 2014 at 3:01 AM, Frediano Ziglio <[email protected]>
>> wrote:
>> 
>>> How are you passing this string to the server?
>>> 256 characters? I bet you are using the wrong protocol.
>>> 
>>> Frediano
>>> 
>>> 
>>> 2014-07-13 19:01 GMT+01:00 venkata krishna Thaluru <
>>> [email protected]>:
>>> 
>>>> Thanks for reply Frediano,
>>>> 
>>>> Syntax is correct only but one of the String having '(single quotes)
>>>> ,that's reason it is failing .
>>>> I have another issue  with varchar(500) ,if we get the data more than
>>> 256
>>>> characters for the that coulmn ,then it is failing with invvalid string
>>>> buffer length .
>>>> Could you please share the commands for ODBC trace and TDS DUMP..
>>>> 
>>>> Thanks
>>>> Venkata Krishna
>>>> 
>>>> 
>>>> 
>>>> 
>>>> On Sun, Jul 13, 2014 at 6:05 PM, Frediano Ziglio <[email protected]>
>>>> wrote:
>>>> 
>>>>> Looks like you sent a query with a wrong syntax.
>>>>> 
>>>>> Can you enable ODBC tracing or TDSDUMP ?
>>>>> 
>>>>> Frediano
>>>>> 
>>>>> 
>>>>> 2014-07-13 6:52 GMT+01:00 venkata krishna Thaluru <
>>>>> [email protected]>:
>>>>> 
>>>>>> Hi All,
>>>>>> I am exporting data to MSSQL server and getting below error.
>>>>>> 
>>>>>> ODBC error (42000). [FreeTDS][SQL Server]Unclosed quotation mark
>>> after
>>>>> the
>>>>>> character string ' test
>>>>>> 
>>>>>> Could you please share your thoughts and ideas to resolve it or any
>>>> know
>>>>>> issue in freeTDS ,please share it.
>>>>>> 
>>>>>> 
>>>>>> Thanks
>>>>>> Venkata Krishna
>>>>>> 9600185503
>>>>>> _______________________________________________
>>>>>> FreeTDS mailing list
>>>>>> [email protected]
>>>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>>> 
>>>>> _______________________________________________
>>>>> FreeTDS mailing list
>>>>> [email protected]
>>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>> 
>>>> 
>>>> 
>>>> 
>>>> --
>>>> 
>>>> *Thanks&RegardsVenkatakrishna.T*
>>>> 
>>>> *HCL TECHNOLOGIES Ltd.09600185503/09908611807*
>>>> _______________________________________________
>>>> FreeTDS mailing list
>>>> [email protected]
>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>> 
>>> _______________________________________________
>>> FreeTDS mailing list
>>> [email protected]
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>> 
>> 
>> 
>> 
>> 
>> 
> 
> 
> -- 
> 
> *Thanks&RegardsVenkatakrishna.T*
> 
> *HCL TECHNOLOGIES Ltd.09600185503/09908611807*
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds

________________________________________
Craig A. Berry
mailto:[email protected]

"... getting out of a sonnet is much more
 difficult than getting in."
                 Brad Leithauser