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: venkata krishna Thaluru <venkatakrishnat1 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Unclosed quotation mark
  • Date: Thu, 24 Jul 2014 23:45:21 +0530

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*




Archive powered by MHonArc 2.6.24.

Top of Page