Re: Unclosed quotation mark

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
>