FreeTDS Development Group

["Carlos S. Alonso de Linaje" <calonso AT i-network.com>]

:-( .....
I'm trying with user... prueba, passwd..prueba (test in spanish)
all in lowercase and dbname in lowercase, etc...
but nothing.....

In tsql output, when we connect to the pool (./tsql -Spooldesarrollo 
-Uprueba -Pprueba) we can see this;
locale is "es_ES@euro"
charset is "ISO-8859-15"
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

and the output from pool is like this
Found conf file in /usr/local/freetds/etc/pool.conf reading sections
Listening on port 5000
waiting for a connect
accepting connection
waiting for a connect
Violación de segmento (Segmentation Fault in Spanish)

Perhaps is the charset??? when we connect directly to MS-SQL with tsql

./tsql -Sdesarrollosql -Uprueba -Pprueba

the output is like the other and works fine!... I tried to change and put 
the locates.conf.
The error is the same, only changing the charset to this one; locale is "C" 
charset is "ANSI_X3.4-1968"

.....

My pool.conf
[global]
        min pool conn = 50
        max pool conn = 150
        max member age = 180

[pooldesarrollo]
        user = prueba
        password = prueba
        database = desarrollo
        server = desarrollosql
        min pool conn = 5
        max pool conn = 10
        port = 5000

My freetds.conf
[global]
        tds version = 4.2
        initial block size = 512
        swap broken dates = no
        swap broken money = no
dump file = /var/tmp/freetds/freetds.log
dump file appaned = yes
debug level = 99
timeout = 50;
connect timeout = 10;

[desarrollosql]
        host = 192.168.6.205
        port = 1433
        tds version = 4.2

[pooldesarrollo]
        host = 192.168.6.133
        port = 5000
        tds version = 4.2

Thanks for the help.
Regards.


At 04:16 PM 7/28/2003 -0400, you wrote:

> > From: Lowden, James K [mailto:LowdenJK AT bernstein.com]
> > Sent: July 28, 2003 4:10 PM
> > > From: Carlos S. Alonso de Linaje [mailto:calonso AT i-network.com]
> > > Sent: July 28, 2003 3:04 PM
> > >
> > > Also we try to download tdspool files from CVS and compile it
> > > but its the same...
> >
> > It looks like tdspool is broken.  I just tried it.  It fails
> > to connect to
> > the server if your username isn't all lower case, which
> > wasn't hard to fix.
>
> Withdrawn, my error.  I was able to connect, once $U was right!:
>
> $ tdspool mypool 2>pool.err >pool.log &
> [7] 8368
> LowdenJK@ntc5003$ tsql -Smypool -U$U -P$P
> locale is "C"
> using default charset "ISO-8859-1"
> 1> select @@version
> 2> go
>
> Microsoft SQL Server  7.00 - 7.00.1077 (Intel X86)
>         Sep  6 2002 15:10:15
>         Copyright (c) 1988-2002 Microsoft Corporation
>         Enterprise Edition on Windows NT 4.0 (Build 1381: Service Pack 6)
> 1>
>
> Just make sure you're using TDS version 4.2.  And that your credentials are
> all lower case.
>
> --jkl
> -----------------------------------------
> The information contained in this transmission may contain privileged and 
> confidential information and is intended only for the use of the person(s) 
> named above. If you are not the intended recipient, or an employee or 
> agent responsible for delivering this message to the intended recipient, 
> any review, dissemination, distribution or duplication of this 
> communication is strictly prohibited. If you are not the intended 
> recipient, please contact the sender immediately by reply e-mail and 
> destroy all copies of the original message. Please note that we do not 
> accept account orders and/or instructions by e-mail, and therefore will 
> not be responsible for carrying out such orders and/or instructions.
>
>
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003

Carlos S. Alonso de Linaje García
Director Técnico
I-network
C/Marqués de Riscal 11, 2ª planta
28010 Madrid
Tel: +34. 91.702.17.57
"Si buscas resultados distintos, no hagas lo mismo" (Albert Einstein)

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.504 / Virus Database: 302 - Release Date: 7/24/2003