Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS Digest, Vol 79, Issue 11

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Kevin Pearce" <KPearce AT ntia.doc.gov>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS Digest, Vol 79, Issue 11
  • Date: Wed, 12 Aug 2009 13:23:20 -0400


___________________________
Sent From NTIA BlackBerry Server
-----Original Message-----
From: freetds-request AT lists.ibiblio.org
To: <freetds AT lists.ibiblio.org>
To: <freetds-request AT lists.ibiblio.org>

Sent: 8/12/2009 1:20:49 PM
Subject: FreeTDS Digest, Vol 79, Issue 11

Send FreeTDS mailing list submissions to
freetds AT lists.ibiblio.org

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
freetds-request AT lists.ibiblio.org

You can reach the person managing the list at
freetds-owner AT lists.ibiblio.org

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" <Alexander.Mittel AT siemens.com>
Subject: Re: [freetds] NT Authentication with Named Instances
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID:

<5EA97F57AE4E9D4BBC7879FEF671C0DA53501FAB23 AT 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: freetds-bounces AT lists.ibiblio.org
[mailto:freetds-bounces AT lists.ibiblio.org] Im Auftrag von Anon Ymous
Gesendet: Dienstag, 11. August 2009 18:21
An: freetds AT lists.ibiblio.org
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
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


------------------------------

Message: 2
Date: Wed, 12 Aug 2009 16:00:14 +0100
From: "Paul S. Kemp" <paul AT kbtech.co.uk>
Subject: Re: [freetds] Unable to install freetds on Unixware 7
To: <freetds AT lists.ibiblio.org>
Message-ID: <B769F7502FAA98448499675C41992E59586759 AT kbdc.KBTech.local>
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:

paul AT kbtech.co.uk <mailto:paul AT kbtech.co.uk>

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 <fm AT 4js.com>
Subject: Re: [freetds] Unable to install freetds on Unixware 7
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID: <4A82DB22.7050001 AT 4js.com>
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:
>
> paul AT kbtech.co.uk <mailto:paul AT kbtech.co.uk>
>
> 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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>




------------------------------

Message: 4
Date: Wed, 12 Aug 2009 12:24:21 -0400
From: Cedric ROUVRAIS <cedric.rouvrais AT sgcib.com>
Subject: [freetds] rowcount not available? [NC]
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Message-ID:

<OF66745DBA.118CDF92-ON85257610.0059E308-85257610.005A1F1D AT 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
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds


End of FreeTDS Digest, Vol 79, Issue 11
***************************************



  • Re: [freetds] FreeTDS Digest, Vol 79, Issue 11, Kevin Pearce, 08/12/2009

Archive powered by MHonArc 2.6.24.

Top of Page