From freddy77 at gmail.com Fri Oct 1 10:26:37 2021 From: freddy77 at gmail.com (Frediano Ziglio) Date: Fri, 1 Oct 2021 15:26:37 +0100 Subject: [freetds] Failure to receive xml query result larger than 2GB In-Reply-To: References: Message-ID: Hi, first make sure you are using a recent protocol, I would say 7.4 for sure. Said that it could be that MSSQL refuses to send the reply for a XML text (FreeTDS does not support XML binary). I would try to get logs and see if there are any hints. Regards, Frediano Il giorno gio 30 set 2021 alle ore 10:34 Tille, Andreas via FreeTDS < freetds at lists.ibiblio.org> ha scritto: > Hi, > > I have a query which returns a result as XML which is larger than 2GB. > When doing this on Windows via > > sqlcmd -S myserver -d mydb -E -i myquery.sql > myresult.xml > > a 2.7GB XML file myresult.xml is created. > > If I try this with freetds 1.2.3 under Debian 11 I get: > > sqsh -w 256 -h -S myserver -U myuser -D mydb -i myquery.sql -o > myresult.xml > > I get > > Msg 6365, Level 16, State 1 > Server 'myserver', Line 70 > An XML operation resulted an XML data type exceeding 2GB in size. > Operation aborted. > > > I used this query successfully a long time but I used a Python3 script to > run it. This stopped working some days ago when the amount of data seemed > to exceed some limit. The actual error message that was thrown by the > Python3 script is > > > An XML operation resulted an XML data type exceeding 2GB in size. > Operation aborted. > DB-Lib error message 20018, severity 16: > General SQL Server error: Check messages from the SQL Server > > > Any idea why sqlcmd on Windows is succeeding here why sqsh and Python3 are > throwing this error? > > Kind regards > > Andreas. > _______________________________________________ > FreeTDS mailing list > FreeTDS at lists.ibiblio.org > https://lists.ibiblio.org/mailman/listinfo/freetds > From ikorot01 at gmail.com Fri Dec 24 21:50:52 2021 From: ikorot01 at gmail.com (Igor Korot) Date: Fri, 24 Dec 2021 20:50:52 -0600 Subject: [freetds] Licensing question Message-ID: Hi, (Frediano), Is it OK if I keep the source code in my repository? Or I should just keep the binary? Or maybe a reference as a module, since I use Git? Thank you. From freddy77 at gmail.com Sat Dec 25 04:02:00 2021 From: freddy77 at gmail.com (Frediano Ziglio) Date: Sat, 25 Dec 2021 09:02:00 +0000 Subject: [freetds] Licensing question In-Reply-To: References: Message-ID: Hi, Il giorno sab 25 dic 2021 alle ore 02:52 Igor Korot ha scritto: > Hi, (Frediano), > > Is it OK if I keep the source code in my repository? > Or I should just keep the binary? > > Or maybe a reference as a module, since I use Git? > > Thank you. > > Libraries code is LGPL, rest (apps/tests) are GPL. Some code is public domain. You can copy it, modify it, if distributed to some people they should be able to get sources from you and good habit to give changes to the project. Obviously license files are more accurate than my little summary above. A module would be a good idea if you are not changing code but just add, for example, applications (this more a technical solution than a license consideration). Regards, Frediano