Re: Unclosed quotation mark

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*