[unixODBC-dev] Error on Fisrt steps for noob

Reinaldo A. Fagundes reinaldo at desenvolvedores.net
Thu Jun 28 13:28:13 BST 2012


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#
        
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-dev/attachments/20120628/eafb36e0/attachment.html>


More information about the unixODBC-dev mailing list