Skip to Content.
Sympa Menu

freetds - Re: [freetds] Unclosed quotation mark

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Craig A. Berry" <craigberry AT mac.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Unclosed quotation mark
  • Date: Fri, 25 Jul 2014 09:46:32 -0500

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
<venkatakrishnat1 AT gmail.com> wrote:

> Hi Frediano,
> Can you please check and reply .
>
> Thanks
> Venkata krishna
>
>
> On Wed, Jul 16, 2014 at 11:22 PM, venkata krishna Thaluru <
> venkatakrishnat1 AT gmail.com> 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 <freddy77 AT gmail.com>
>> 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 <
>>> venkatakrishnat1 AT gmail.com>:
>>>
>>>> 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 <freddy77 AT gmail.com>
>>>> 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 <
>>>>> venkatakrishnat1 AT gmail.com>:
>>>>>
>>>>>> 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
>>>>>> FreeTDS AT lists.ibiblio.org
>>>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>>>
>>>>> _______________________________________________
>>>>> FreeTDS mailing list
>>>>> FreeTDS AT lists.ibiblio.org
>>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>>
>>>> *Thanks&RegardsVenkatakrishna.T*
>>>>
>>>> *HCL TECHNOLOGIES Ltd.09600185503/09908611807*
>>>> _______________________________________________
>>>> FreeTDS mailing list
>>>> FreeTDS AT lists.ibiblio.org
>>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>>
>>> _______________________________________________
>>> FreeTDS mailing list
>>> FreeTDS AT lists.ibiblio.org
>>> http://lists.ibiblio.org/mailman/listinfo/freetds
>>>
>>
>>
>>
>>
>>
>
>
> --
>
> *Thanks&RegardsVenkatakrishna.T*
>
> *HCL TECHNOLOGIES Ltd.09600185503/09908611807*
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds

________________________________________
Craig A. Berry
mailto:craigberry AT mac.com

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





Archive powered by MHonArc 2.6.24.

Top of Page