Re: Unclosed quotation mark

1) I think the format is usually yyyy-mm-dd HH:MM:ss.ddddddd

2) check protocol version, see previous mails on how to turn on the dump,
protocol version is at the top

3) how are you exporting these data ? data copy ? freebcp ?

Frediano


2014-07-30 19:04 GMT+01:00 venkata krishna Thaluru <
[email protected]>:

> Thanks for reply Berry,
> I am looking  below clarifications .
> 1)If we have date format like '2014-07-28 01:14:00:928563' ,whether freetds
> allow to insert into MSSQL Server .
> 2)I have see varchar  max size is allowing 256 character ,if we define more
> than it is failing .. whether is it limitation?
> 3)One of the coulmn data having junk characters ,while exporting to mssql
> ,it is unclosed quotation string ' ,failing on that record .
>
>
> Could you please share on your comments above ?
> If we go for latest version ,whether it is addressed all issues or not ?
>
> Thanks
> Venkata krishna
>
>
>
>
> On Fri, Jul 25, 2014 at 8:16 PM, Craig A. Berry <[email protected]>
> wrote:
>
> > Please read the User Guide section on logging:
> >
> > <http://www.freetds.org/userguide/logging.htm>
> >
> >
> > On Jul 24, 2014, at 1:15 PM, venkata krishna Thaluru <
> > [email protected]> wrote:
> >
> > > 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*
> > > _______________________________________________
> > > FreeTDS mailing list
> > > [email protected]
> > > http://lists.ibiblio.org/mailman/listinfo/freetds
> >
> > ________________________________________
> > Craig A. Berry
> > mailto:[email protected]
> >
> > "... getting out of a sonnet is much more
> >  difficult than getting in."
> >                  Brad Leithauser
> >
> > _______________________________________________
> > 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
>