[freetds] error on fist steps

[Reinaldo A. Fagundes]

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#

[James K. Lowden]

On Thu, 28 Jun 2012 11:46:15 -0300

Post by Reinaldo A. Fagundes
Now isql
ts7500:~# isql MSSQLTestServer sa **** -v
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

What does osql say?

--jkl

[Reinaldo A. Fagundes]

jkl,

I re-install all and remake config files, work tsql osql isql fine, now
I need one sample to make CRUD with ODBC connection on C++, I try to find it
on internet if have anything to show me, please.

tks

-----Mensagem Original-----
From: James K. Lowden
Sent: Thursday, June 28, 2012 11:16 PM
To: freetds at lists.ibiblio.org
Subject: Re: [freetds] error on fist steps

On Thu, 28 Jun 2012 11:46:15 -0300

Post by Reinaldo A. Fagundes
Now isql
ts7500:~# isql MSSQLTestServer sa **** -v
[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

What does osql say?

--jkl