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: Wed, 30 Jul 2014 23:34:20 +0530

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*




Archive powered by MHonArc 2.6.24.

Top of Page