John Kendall | 4 May 19:46 2016

freebcp in -n native switch not working with Sybase

On MS SQL Server this works:

   select col1="one", col2="2" into tempdb..tbl

   freebcp tempdb..tbl out tbl.bcp -n -Uusr -Ppw
   freebcp tempdb..tbl in  tbl.bcp -n -Uusr -Ppw

On Sybase the bcp in fails like so:

   Starting copy...

   Msg 20104, Level 3
   Unexpected EOF encountered in bcp datafile

   bcp copy in failed

Notes:
The bcp file created is identical for on both server flavors.
Using the character -c option works.

Anyone else able to reproduce this problem?

John
John Kendall | 4 May 18:07 2016

Re: "Fix affected rows after insert with prepared query" side effect


> On Apr 30, 2016, at 4:23 PM, Frediano Ziglio <freddy77 <at> gmail.com> wrote:
> 
> Now works much better. Please try last RC (4).
> 
> Frediano
> 

Looks good. 
Thank you!
John 

> 
> 2016-04-24 16:55 GMT+01:00 John Kendall <john <at> capps.com>:
>> Sorry, my last post had the wrong link to sybase infocenter.
>> 
>> 2016-04-23 13:04 GMT+01:00 Frediano Ziglio <freddy77 at gmail.com>:
>> 
>>> 2016-04-22 1:03 GMT+01:00 John Kendall <john at capps.com>:
>>> 
>>>> Thu, 21 Apr 2016 11:04:54 +0100 Frediano Ziglio <freddy77 at gmail.com>
>>>> 
>>>>> 2016-04-21 8:00 GMT+01:00 John Kendall <john at capps.com>:
>>>>>> On Oct 19, 2015 this patch was applied to ct.c:
>>>>>> 
>>>>>> "Fix affected rows after insert with prepared query"
>>>>>> 
>>>>>> This patch has the side-effect of a 'rows affected' being displayed for every
>>>>>> select statement within a ASE stored procedure. For example, sp_help returns
>>>>>> 136 extra 'rows affected' lines. See below. Backing out this patch stops this from
(Continue reading)

Velichko Yuriy | 3 May 11:34 2016
Picon

ntlmv2 default value

Hello, what is default value for ntlmv2 option?
If ''no", can you add method, like DBSETUTF16, to avoid using .conf file to
setup this option?

Thanks!
Frediano Ziglio | 2 May 22:00 2016
Picon

Re: Setting `login->use_utf16` With DBLIB Using Sybdb.h

Added the DBSETUTF8 option! Not really hard :-)

Frediano

2016-05-02 12:18 GMT+01:00 Ken Collins <ken <at> actionmoniker.com>:
> The option to set the long would make sense to me. I love the default, but
> would love to allow someone to set this in my client without going to a conf
> file. Hope that helps.
>
>  - Ken
>
>
> On April 25, 2016 at 8:20:08 AM, Frediano Ziglio (freddy77 <at> gmail.com) wrote:
>
> 2016-04-24 20:58 GMT+01:00 Ken Collins <ken <at> metaskills.net>:
>> So I saw the news about `use utf-16 = true` via the conf file for 0.95 and
>> how this is the default in 1.0 release candidate. However, I was wondering
>> if there is a way I can set this long in bit using either an environment
>> variable or some other means when compiling against sybdb.h?
>>
>> - Thanks in advance,
>> Ken Collins
>
> An environment variable looks to much.
> An option to set using setlshort/setllong would make sense to me.
> Does it sound reasonable? I don't understand how you want to use this
> option.
>
> Frediano
> _______________________________________________
(Continue reading)

Frediano Ziglio | 1 May 01:22 2016
Picon

FreeTDS 1.0 Release Candidate 4 is out!

This release contains:
- fix some compile issues with Mac OS X;
- fix CT-Library rows counts;
- fix minor compatibility issues with some unit tests;
- other minor issues.

Frediano
Frediano Ziglio | 29 Apr 19:50 2016
Picon

Re: 'compute' deprecated (Re: rc3 looks good on OpenVMS)

2016-04-29 14:41 GMT+01:00 Craig A. Berry <craigberry <at> mac.com>:
>
>> On May 28, 2015, at 5:16 PM, Frediano Ziglio <freddy77 <at> gmail.com> wrote:
>>
>> Il 28/Mag/2015 09:58, "Craig A. Berry" <craigberry <at> mac.com> ha scritto:
>>>  With SQL 2012 this test below fails, but I
>>> think it's just because "compute" has been removed in SQL 2012:
>
>> Yes, that test check how compute queries reply so cannot work but is not a
>> Freetds issue
>
> I’m reviving this year-old thread because this is still a problem and getting to be a bigger one, and
while it isn’t FreeTDS’s fault, it is FreeTDS’s problem if its test suite can’t even run to
completion on 3 of the 4 currently-supported versions of Microsoft’s server (SQL 2005 went out of
support a week or two ago, so SQL 2008 is the only one that can run the test suite).
>

I though AppVeyor was running check against mssql 2012 !!

> The following tests are the ones affected:
>
> src/ctlib/unittests/t0009
> src/dblib/unittests/t0023
> src/dblib/unittests/dbmorecmds
>
> I tried (unsuccessfully) to come up with a way to skip the tests when running on SQL 2012 or greater.  The
following check tells you what you’ve got, but only at run time, which is too late.  The ‘compute’
keyword will still be seen at parse time so the script will already fail before this check runs.  Plus it uses
Microsoft-specific functions that will probably not parse on Sybase.
>
(Continue reading)

Frediano Ziglio | 29 Apr 19:27 2016
Picon

Re: [PATCH] Test tds_strl* routines on all platforms

Applied

Thanks,
  Frediano

2016-04-29 13:48 GMT+01:00 Craig A. Berry <craigberry <at> mac.com>:
> The src/replacements/unittests/strings.c failed to build for me on OS X.  The test is explicitly using
the routines with the tds_ prefix, which don’t exist when we aren’t using replacements.  So this
change makes them exist for test purposes only in the case where we wouldn’t normally get them.
>
>
>
>
> _______________________________________________
> 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
Peter Deacon | 27 Apr 02:17 2016

DNS lookups not working with freetds

Tried current freetds and name lookups are not working at all with some 
older Linux systems for me.  Everything that isn't an IP address returns 
-2 (EAI_NONAME)

The problem is triggered by setting ai_flags = AI_ADDRCONFIG in hints 
field of getaddrinfo and resolved by setting ai_flags = 0.

From what I've read in various man pages for getaddrinfo when set to 0 
defaults are designed to be reasonable usually including AI_ADDRCONFIG 
anyway.

Would switching to default for ai_flags break anything for anyone?

thanks,
~Peter
Pulver, Alex | 25 Apr 14:26 2016
Picon
Gravatar

Getting "Unexpected EOF from the server" when trying to connect to MS SQL Server 2014

Hi all,

I am trying to connect to MS SQL 2014 Server from SLES11 host, using FreeTDS 0.95.51 version and its tsql
utility. The server uses "Standard Mode" (SQL Server Authentication) and I am able to connect from
Windows using SQL Server 2014 Management Studio.
Before sending this email I've read through FreeTDS troubleshooting, FAQ, domains page, config page,
archives and various SO questions - tried the recommended configurations but with no luck (details below).

The command being run is:
env TDSVER=7.0 TDSDUMP=/tmp/tdsdump.log TDSDUMPCONFIG=/tmp/tdsdumpconfig.log ./src/apps/tsql -H
<host> -p <port> -U <username> -P <password> -D <database>

The output:
locale is "C"
locale charset is "ANSI_X3.4-1968"
using default charset "ISO-8859-1"
Setting <database> as default database in login packet
Error 20017 (severity 9):
        Unexpected EOF from the server
...

Tailing TDSDUMP along with the execution shows that error is happening after the login packet is sent and
FreeTDS tries to process the login tokens:
login.c:852:quietly sending TDS 7+ login packet
token.c:327:tds_process_login_tokens()
<<
Error 20017 (severity 9):
        Unexpected EOF from the server
>>
query.c:3772:tds_disconnect()
(Continue reading)

Jan Blom | 25 Apr 00:23 2016
Picon

osql exits with error on Linux

Hello,

The osql script fails to execute on CentOS (tested on release 6 & 7). We need to add "-F" to grep to avoid
interpreting patterns as a reg exp. Patch attached.

Best regards,
Jan Blom

--- freetds-1.0rc3/src/apps/osql	2015-01-26 21:32:41.000000000 +0100
+++ freetds-1.0rc3_patched/src/apps/osql	2016-04-25 00:05:07.455558900 +0200
 <at>  <at>  -120,7 +120,7  <at>  <at> 
 		continue
 	fi
 
-	grep "[${DSN}]" $F > /dev/null
+	grep -F "[${DSN}]" $F > /dev/null
 
 	if [ $? -eq 0 ]
 	then
 <at>  <at>  -286,7 +286,7  <at>  <at> 
 		fi
 
 		echo "looking for [${TDS_SERVER}] in $F"
-		grep "[${TDS_SERVER}]" $F > /dev/null
+		grep -F "[${TDS_SERVER}]" $F > /dev/null
 
 		if [ $? -eq 0 ]
 		then
(Continue reading)

Ken Collins | 24 Apr 21:58 2016
Picon
Gravatar

Setting `login->use_utf16` With DBLIB Using Sybdb.h

So I saw the news about `use utf-16 = true` via the conf file for 0.95 and how this is the default in 1.0 release
candidate. However, I was wondering if there is a way I can set this long in bit using either an environment
variable or some other means when compiling against sybdb.h? 

 - Thanks in advance,
    Ken Collins
_______________________________________________
FreeTDS mailing list
FreeTDS <at> lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds

Gmane