Re: Unclosed quotation mark

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*