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: Frediano Ziglio <freddy77 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Unclosed quotation mark
  • Date: Mon, 14 Jul 2014 22:31:56 +0100

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
>




Archive powered by MHonArc 2.6.24.

Top of Page