Re: Unclosed quotation mark

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*