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: venkata krishna Thaluru <venkatakrishnat1 AT gmail.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Unclosed quotation mark
  • Date: Mon, 4 Aug 2014 23:31:43 +0530

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*




Archive powered by MHonArc 2.6.24.

Top of Page