Re: Unclosed quotation mark

Bulk insert ??

From the log seems a RPC call ! Could be I miss some log.

Frediano

Frediano


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

> Thank you reply  Frediano,
>
> We are using TDs 8.0.
> We are sql query to bulk insert .
>
> Could you please let me know ,if you required any details.
>
> Thanks
> Venkata Krishna
>
>
>
> On Thu, Jul 31, 2014 at 12:33 AM, Frediano Ziglio <[email protected]>
> wrote:
>
> > 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
> > >
> > _______________________________________________
> > 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
>