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
Post by Craig A. Berry<http://www.freetds.org/userguide/logging.htm>
On Jul 24, 2014, at 1:15 PM, venkata krishna Thaluru <
Post by venkata krishna ThaluruHi Frediano,
Can you please check and reply .
Thanks
Venkata krishna
On Wed, Jul 16, 2014 at 11:22 PM, venkata krishna Thaluru <
Post by venkata krishna ThaluruHi 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
Post by Frediano ZiglioHow 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 <
Post by venkata krishna ThaluruThanks 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
Post by venkata krishna Thalurucharacters for the that coulmn ,then it is failing with invvalid
string
Post by venkata krishna ThaluruPost by venkata krishna ThaluruPost by Frediano ZiglioPost by venkata krishna Thalurubuffer length .
Could you please share the commands for ODBC trace and TDS DUMP..
Thanks
Venkata Krishna
Post by Frediano ZiglioLooks 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 <
Post by venkata krishna ThaluruHi All,
I am exporting data to MSSQL server and getting below error.
ODBC error (42000). [FreeTDS][SQL Server]Unclosed quotation mark
after
Post by venkata krishna ThaluruPost by Frediano Zigliothe
Post by venkata krishna Thalurucharacter string ' test
Could you please share your thoughts and ideas to resolve it or any
know
Post by Frediano ZiglioPost by venkata krishna Thaluruissue 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*