Skip to Content.
Sympa Menu

freetds - [freetds] error on fist steps

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Reinaldo A. Fagundes " <reinaldo AT desenvolvedores.net>
  • To: <FreeTDS AT lists.ibiblio.org>
  • Subject: [freetds] error on fist steps
  • Date: Thu, 28 Jun 2012 11:46:15 -0300

hi,
Sorry my noob question.
I try run unixODBC and FreeTDS but still having problem, I try connect with
tsql and run fine, but with isql no, and with software in .c no run.
need help to solve this please.
let me show.
tsql:
ts7500:~# odbcinst -s -q
[MSSQLTestServer]
[NSSQL]
ts7500:~# odbcinst -d -q
[FreeTDS]
ts7500:~# tsql -S MSSQLTestServer -U sa
Password:
locale is "C"
locale charset is "ANSI_X3.4-1968"
using default charset "ISO-8859-1"
1> use Teste
2> select * from tabela1
3> go
ID Nome
1 Reinaldo
3 Charles
10 Teste
(3 rows affected)
1>
Now isql
ts7500:~# isql MSSQLTestServer sa **** -v
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source
[01000][unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
[01000][unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
[ISQL]ERROR: Could not SQLConnect
ts7500:~#
and with software basic connect sample
ts7500:~/temp# ./conect
Failed to connect
The driver reported the following diagnostics whilst running SQLDriverConnect
08001:1:0:[unixODBC][FreeTDS][SQL Server]Unable to connect to data source
01000:2:20002:[unixODBC][FreeTDS][SQL Server]Adaptive Server connection failed
01000:3:20017:[unixODBC][FreeTDS][SQL Server]Unexpected EOF from the server
ts7500:~/temp#
>From jklowden AT freetds.org Thu Jun 28 22:16:23 2012
Return-Path: <jklowden AT freetds.org>
X-Original-To: freetds AT lists.ibiblio.org
Delivered-To: freetds AT lists.ibiblio.org
Received: by lists.ibiblio.org (Postfix, from userid 20217)
id 3686BE8A46; Thu, 28 Jun 2012 22:16:23 -0400 (EDT)
X-Spam-Checker-Version: SpamAssassin 3.3.1 (2010-03-16) on
mailman1.ibiblio.org
X-Spam-Level:
X-Spam-Status: No, score=-1.8 required=5.0 tests=AWL,BAYES_00,
RCVD_IN_DNSWL_NONE autolearn=ham version=3.3.1
Received: from mail15.sea5.speakeasy.net (mail15.sea5.speakeasy.net
[69.17.117.17])
by lists.ibiblio.org (Postfix) with ESMTP id 30246E8A3B
for <freetds AT lists.ibiblio.org>; Thu, 28 Jun 2012 22:16:21 -0400 (EDT)
Received: (qmail 21178 invoked from network); 29 Jun 2012 02:16:20 -0000
Received: by simscan 1.4.0 ppid: 24999, pid: 30985, t: 0.0196s
scanners: clamav: 0.88.2/m:52/d:10739
Received: from mxperim7.sea5.speakeasy.net ([69.17.117.72])
(envelope-sender <jklowden AT freetds.org>)
by mail15.sea5.speakeasy.net (qmail-ldap-1.03) with SMTP
for <freetds AT lists.ibiblio.org>; 29 Jun 2012 02:16:20 -0000
Received: from localhost (localhost [127.0.0.1])
by mxperim7.sea5.speakeasy.net (Postfix) with ESMTP id 88A65AF5AA
for <freetds AT lists.ibiblio.org>; Thu, 28 Jun 2012 19:16:20 -0700 (PDT)
X-Virus-Scanned: Debian amavisd-new at mxperim7.sea5.speakeasy.net
Received: from mxperim7.sea5.speakeasy.net ([127.0.0.1])
by localhost (mxperim7.sea5.speakeasy.net [127.0.0.1]) (amavisd-new,
port 10024)
with ESMTP id yyjzMKGHiZYJ for <freetds AT lists.ibiblio.org>;
Thu, 28 Jun 2012 19:16:20 -0700 (PDT)
Received: from oak.schemamania.org (dsl254-083-208.nyc1.dsl.speakeasy.net
[216.254.83.208]) by mxperim7.sea5.speakeasy.net (Postfix) with ESMTP
for <freetds AT lists.ibiblio.org>; Thu, 28 Jun 2012 19:16:20 -0700 (PDT)
Received: from oak.schemamania.org (localhost [IPv6:::1])
by oak.schemamania.org (Postfix) with SMTP id 750F830E118C
for <freetds AT lists.ibiblio.org>; Thu, 28 Jun 2012 22:16:19 -0400 (EDT)
Date: Thu, 28 Jun 2012 22:16:19 -0400
From: "James K. Lowden" <jklowden AT freetds.org>
To: freetds AT lists.ibiblio.org
Message-Id: <20120628221619.6bedc776.jklowden AT freetds.org>
In-Reply-To: <9F54EA6B0BF34D8BAA644D69E07C1E5A@ReinaldoNoteHP>
References: <9F54EA6B0BF34D8BAA644D69E07C1E5A@ReinaldoNoteHP>
X-Mailer: Sylpheed 3.0.2 (GTK+ 2.20.1; x86_64--netbsd)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Subject: Re: [freetds] error on fist steps
X-BeenThere: freetds AT lists.ibiblio.org
X-Mailman-Version: 2.1.9
Precedence: list
Reply-To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
List-Id: FreeTDS Development Group <freetds.lists.ibiblio.org>
List-Unsubscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
<mailto:freetds-request AT lists.ibiblio.org?subject=unsubscribe>
List-Archive: <https://lists.ibiblio.org/sympa/arc/freetds>
List-Post: <mailto:freetds AT lists.ibiblio.org>
List-Help: <mailto:sympa AT lists.ibiblio.org?subject=HELP>
List-Subscribe: <http://lists.ibiblio.org/mailman/listinfo/freetds>,
<mailto:freetds-request AT lists.ibiblio.org?subject=subscribe>
X-List-Received-Date: Fri, 29 Jun 2012 02:16:23 -0000

On Thu, 28 Jun 2012 11:46:15 -0300
"Reinaldo A. Fagundes " <reinaldo AT desenvolvedores.net> wrote:

> Now isql
> ts7500:~# isql MSSQLTestServer sa **** -v
> [S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

What does osql say?

--jkl





Archive powered by MHonArc 2.6.24.

Top of Page