Re: FreeTDS Digest, Vol 79, Issue 11

 
___________________________ 
Sent From NTIA BlackBerry Server  
-----Original Message----- 
From: [email protected] 
To:  <[email protected]> 
To:  <[email protected]> 
 
Sent: 8/12/2009 1:20:49 PM 
Subject: FreeTDS Digest, Vol 79, Issue 11 
 
Send FreeTDS mailing list submissions to 
	[email protected] 
 
To subscribe or unsubscribe via the World Wide Web, visit 
	http://lists.ibiblio.org/mailman/listinfo/freetds 
or, via email, send a message with subject or body 'help' to 
	[email protected] 
 
You can reach the person managing the list at 
	[email protected] 
 
When replying, please edit your Subject line so it is more specific 
than "Re: Contents of FreeTDS digest..." 
 
 
Today's Topics: 
 
   1. Re: NT Authentication with Named Instances (Mittel, Alexander) 
   2. Re: Unable to install freetds on Unixware 7 (Paul S. Kemp) 
   3. Re: Unable to install freetds on Unixware 7 (Fabrice Manfroi) 
   4. rowcount not available? [NC] (Cedric ROUVRAIS) 
 
 
---------------------------------------------------------------------- 
 
Message: 1 
Date: Wed, 12 Aug 2009 12:01:58 +0200 
From: "Mittel, Alexander" <[email protected]> 
Subject: Re: [freetds] NT Authentication with Named Instances 
To: FreeTDS Development Group <[email protected]> 
Message-ID: 
	<5EA97F57AE4E9D4BBC7879FEF671C0DA53501FAB23@DEFTHW99E15MSX.ww902.siemens.net>

	 
Content-Type: text/plain; charset="iso-8859-1" 
 
Hi, 
 
Can You look at file ERRORLOG of the SQL Server (i.e. with Server
Management Studio)? 
Can You look at "Event Viewer" of the Windows Server? 
Can You use shares at the Windows Server if You connect to it from a
Windows PC using username/password? 
 
The initial error must come from Windows because Windows does the
authentication, and if this fails 
Windows send the User '' (or null) to SQL Server, and then of course SQL
Server cannot assign a 
SQL-User. [If I try to connect with an non-existent Windows-User I get
the same error "Login failed for user ''....." 
ERRORLOG show 2 errors and "Event Viewer" (security protocol) shows
"unknown user or password"] 
 
Before trying Perl You may try FreeTDS-tsql: 
[/usr/local/freetds/bin/]tsql -H 147.54.157.28 -p 1737 -U
'windomain\username' -P password 
[/usr/local/freetds/bin/]tsql -H 147.54.157.28 -p 1737 -U
'winserverhostname\username' -P password 
 
Mfg Alexander 
 
-----Urspr?ngliche Nachricht----- 
Von: [email protected]
[mailto:[email protected]] Im Auftrag von Anon Ymous 
Gesendet: Dienstag, 11. August 2009 18:21 
An: [email protected] 
Betreff: [freetds] NT Authentication with Named Instances 
 
Hello FreeTDS enthusiasts! I first would like to say that I love FreeTDS
and 
the great connectivity it brings. I have a question for you all today,
that 
I have been having a hard time with lately. I have a SQL Server 2000
server 
that I need to connect to via Linux FreeTDS. The server is in NT 
Authentication mode only, and is using a named instance on port 4433.
The 
sql server is not connected to a domain, and can't be. The account I am 
using to login is a local user on the server. Unfortunately, I cannot
have 
anything changed on the server, so I'm trying to work with what I have
been 
given. I am trying to connect using Perl's DBI:ODBC connection. For 
reference, here is my DSN, (substituted localhost for real ip) 
 
my $host = '127.0.0.1\InstanceName'; 
my $usr = 'HostName\UserName'; 
my $pw = 'Password'; 
my $dsn = 
DRIVER=/usr/local/lib/libtdsodbc.so;SERVER=$host;PORT=4433;DATABASE=DataBase;UID=$usr;PW=$pw;TDS_Version=8.0";

my $dbh = DBI->connect('DBI:ODBC:'.$dsn) || die $DBI::errstr; 
 
I keep getting the error, "Login failed for user '(null)'. Reason: Not 
associated with a trusted SQL Server connection." I read the guide
talking 
about this, http://www.freetds.org/userguide/domains.htm, but the server
is 
set at "Send LM & NTLM - use NTLMv2 session secuiryt if negotiated".
Here 
are my conf files. 
 
*odbc.ini* 
[ODBC Data Sources] 
VOIP 
[VOIP] 
Driver = FreeTDS 
Description = Connection to the new voip DB 
Trace = No 
Server = 127.0.0.1 
Port = 4433 
Database = databasename 
[Default] 
Driver = FreeTDS 
 
*freetds.conf* 
[VOIP] 
host = 127.0.0.1 
instance = CRSSQL 
port = 4433 
client charset = UTF-8 
tds version = 8.0 
 
*odbcinst.ini* 
[FreeTDS] 
Description = FreeTDS Driver 
Driver = /usr/local/lib/libtdsodbc.so 
 
 
I can connect remotely by creating a user on my local windows maching
that 
matches the sql server user, and using Microsoft's Sql Server Management

Studio. I am hoping someone can help me, as I have run clean out of
ideas. 
My Google-fu seems to have failed me so far on this one. 
_______________________________________________ 
FreeTDS mailing list 
[email protected] 
http://lists.ibiblio.org/mailman/listinfo/freetds 
 
 
------------------------------ 
 
Message: 2 
Date: Wed, 12 Aug 2009 16:00:14 +0100 
From: "Paul S. Kemp" <[email protected]> 
Subject: Re: [freetds] Unable to install freetds on Unixware 7 
To: <[email protected]> 
Message-ID: <[email protected]> 
Content-Type: text/plain;	charset="us-ascii" 
 
Hi All, 
 
  
 
Thanks for the responses 
 
  
 
Ok I tired installing the snapshot  which has removed the error on the 
configure statement, but unfortunately i still get the same error on the

make check in relation to the missing libs directory which doesn't seem 
to exist in my freetds directory. 
 
  
 
UX:make: WARNING: No suffix list. 
 
Making check in include 
 
UX:make: WARNING: No suffix list. 
 
Making check in src 
 
UX:make: WARNING: No suffix list. 
 
Making check in replacements 
 
Making check in tds 
 
        make  check-recursive 
 
Making check in unittests 
 
        make  t0001 t0002 t0003  t0004 t0005 t0006 t0007  t0008 dynamic1

convert 
 
  dataread utf8_1 utf8_2  utf8_3 numeric iconv_fread  toodynamic 
 
        /bin/ksh ../../../libtool --tag=CC --mode=link cc -Kthread -g 
-no-insta 
 
ll -L../.libs -R /../.libs  -o t0001  t0001.o common.o  ../libtds.la 
../../repla 
 
cements/libreplacements.la -lsocket 
 
../../../libtool[1961]: cd: ../.libs: [No such file or directory] 
 
libtool: link: cannot determine absolute directory name of `../.libs' 
 
libtool: link: cannot find the library `../libtds.la' or unhandled 
argument `../ 
 
libtds.la' 
 
*** Error code 1 (bu21) 
 
UX:make: ERROR: fatal error. 
 
*** Error code 1 (bu21) 
 
UX:make: ERROR: fatal error. 
 
*** Error code 1 (bu21) 
 
UX:make: ERROR: fatal error. 
 
  
 
Thanks in advance. 
 
  
 
Cheers Paul. 
 
  
 
  
 
Paul Kemp - Microsoft Certified Professional 
KB Technology 
 
  
 
Tel: 
 
0845 838 1227 
 
Fax: 
 
0845 838 1228 
 
Mobile: 
 
07949 151061 
 
Email: 
 
[email protected] <mailto:[email protected]>  
 
Web: 
 
www.kbtech.co.uk <http://www.kbtech.co.uk>  
 
  
 
KB Tech Ltd. Reg No. 5624417. Registered in England. Registered Office: 
175 High Street, Tonbridge, Kent, TN9 1BX. 
 
  
 
The contents of this message and all attachments are strictly 
confidential and should not be copied, shared or passed on to anyone 
other than the intended recipient, if you are not the intended recipient

you are kindly requested to preserve this confidentiality and to advise 
the sender immediately of the error in transmission.  
 
  
 
 
 
This message has been scanned by MailController -
www.MailController.altohiway.com 
 
 
------------------------------ 
 
Message: 3 
Date: Wed, 12 Aug 2009 17:09:22 +0200 
From: Fabrice Manfroi <[email protected]> 
Subject: Re: [freetds] Unable to install freetds on Unixware 7 
To: FreeTDS Development Group <[email protected]> 
Message-ID: <[email protected]> 
Content-Type: text/plain; charset=ISO-8859-1; format=flowed 
 
Hello, 
 
The "UX:make" means that you are using the natif make (the one provided 

by SCO). 
 
Try to use a GNU make 3.81 instead of the native one. It should fixe the
 
probleme... And maybe show a lot of new one ^^ 
 
Regards. 
 
Paul S. Kemp wrote: 
> Hi All, 
>  
>   
>  
> Thanks for the responses 
>  
>   
>  
> Ok I tired installing the snapshot  which has removed the error on the

> configure statement, but unfortunately i still get the same error on
the 
> make check in relation to the missing libs directory which doesn't
seem 
> to exist in my freetds directory. 
>  
>   
>  
> UX:make: WARNING: No suffix list. 
>  
> Making check in include 
>  
> UX:make: WARNING: No suffix list. 
>  
> Making check in src 
>  
> UX:make: WARNING: No suffix list. 
>  
> Making check in replacements 
>  
> Making check in tds 
>  
>         make  check-recursive 
>  
> Making check in unittests 
>  
>         make  t0001 t0002 t0003  t0004 t0005 t0006 t0007  t0008
dynamic1 
> convert 
>  
>   dataread utf8_1 utf8_2  utf8_3 numeric iconv_fread  toodynamic 
>  
>         /bin/ksh ../../../libtool --tag=CC --mode=link cc -Kthread -g 
> -no-insta 
>  
> ll -L../.libs -R /../.libs  -o t0001  t0001.o common.o  ../libtds.la 
> ../../repla 
>  
> cements/libreplacements.la -lsocket 
>  
> ../../../libtool[1961]: cd: ../.libs: [No such file or directory] 
>  
> libtool: link: cannot determine absolute directory name of `../.libs' 
>  
> libtool: link: cannot find the library `../libtds.la' or unhandled 
> argument `../ 
>  
> libtds.la' 
>  
> *** Error code 1 (bu21) 
>  
> UX:make: ERROR: fatal error. 
>  
> *** Error code 1 (bu21) 
>  
> UX:make: ERROR: fatal error. 
>  
> *** Error code 1 (bu21) 
>  
> UX:make: ERROR: fatal error. 
>  
>   
>  
> Thanks in advance. 
>  
>   
>  
> Cheers Paul. 
>  
>   
>  
>   
>  
> Paul Kemp - Microsoft Certified Professional 
> KB Technology 
>  
>   
>  
> Tel: 
>  
> 0845 838 1227 
>  
> Fax: 
>  
> 0845 838 1228 
>  
> Mobile: 
>  
> 07949 151061 
>  
> Email: 
>  
> [email protected] <mailto:[email protected]>  
>  
> Web: 
>  
> www.kbtech.co.uk <http://www.kbtech.co.uk>  
>  
>   
>  
> KB Tech Ltd. Reg No. 5624417. Registered in England. Registered
Office: 
> 175 High Street, Tonbridge, Kent, TN9 1BX. 
>  
>   
>  
> The contents of this message and all attachments are strictly 
> confidential and should not be copied, shared or passed on to anyone 
> other than the intended recipient, if you are not the intended
recipient 
> you are kindly requested to preserve this confidentiality and to
advise 
> the sender immediately of the error in transmission.  
>  
>   
>  
>  
>  
> This message has been scanned by MailController -
www.MailController.altohiway.com 
> _______________________________________________ 
> FreeTDS mailing list 
> [email protected] 
> http://lists.ibiblio.org/mailman/listinfo/freetds 
>  
 
 
 
 
------------------------------ 
 
Message: 4 
Date: Wed, 12 Aug 2009 12:24:21 -0400 
From: Cedric ROUVRAIS <[email protected]> 
Subject: [freetds] rowcount not available? [NC] 
To: FreeTDS Development Group <[email protected]> 
Message-ID: 
	<OF66745DBA.118CDF92-ON85257610.0059E308-85257610.005A1F1D@us.world.socgen>

	 
Content-Type: text/plain; charset="us-ascii" 
 
Hi guys, 
 
I have come across an interesting behaviour with SQL Server 2008, when
you 
use the instruction: "set rowcount nn" such as "set rowcount 10" then 
DBCOUNT(dbproc) returns -1. 
 
Anyone have any ideas??? 
 
Thanks, 
 
Cedric 
 
 
*************************************************************************

This message and any attachments (the "message") are confidential,
intended  
solely for the addressee(s), and may contain legally privileged
information.   
Any unauthorised use or dissemination is prohibited.  E-mails are
susceptible  
to alteration.  Neither SOCIETE GENERALE nor any of its subsidiaries or 

affiliates shall be liable for the message if altered, changed or
falsified. 
*************************************************************************

 
 
 
------------------------------ 
 
_______________________________________________ 
FreeTDS mailing list 
[email protected] 
http://lists.ibiblio.org/mailman/listinfo/freetds 
 
 
End of FreeTDS Digest, Vol 79, Issue 11 
***************************************