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, 4 Aug 2014 19:51:32 +0100

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 <
venkatakrishnat1 AT gmail.com>:

> 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 <freddy77 AT gmail.com>
> 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 <
> > venkatakrishnat1 AT gmail.com>:
> >
> > > 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 <craigberry AT mac.com>
> > > 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 <
> > > > venkatakrishnat1 AT gmail.com> wrote:
> > > >
> > > > > Hi Frediano,
> > > > > Can you please check and reply .
> > > > >
> > > > > Thanks
> > > > > Venkata krishna
> > > > >
> > > > >
> > > > > On Wed, Jul 16, 2014 at 11:22 PM, venkata krishna Thaluru <
> > > > > venkatakrishnat1 AT gmail.com> 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 <
> > freddy77 AT gmail.com>
> > > > >> 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 <
> > > > >>> 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
> > > > >>>>
> > > > >>> _______________________________________________
> > > > >>> 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
> > > >
> > > > ________________________________________
> > > > Craig A. Berry
> > > > mailto:craigberry AT mac.com
> > > >
> > > > "... getting out of a sonnet is much more
> > > > difficult than getting in."
> > > > Brad Leithauser
> > > >
> > > > _______________________________________________
> > > > 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
> > >
> > _______________________________________________
> > 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