[unixODBC-support] UNIXODBC SUPPORT

[Claudio Francisco Salvador]

I need Access a MS SQL Server 2000 from my Linux environment ( Oracle
Enterprise Linux 4.0).

 

I have the follow RPM's packages installed:

 

unixODBC-2.2.11-1.0.1.RHEL4.1

unixODBC-kde-2.2.11-1.0.1.RHEL4.1

MyODBC-2.50.39-25.RHEL4.1

unixODBC-devel-2.2.11-1.0.1.RHEL4.1

 

I have installed the drivers from FreeTDS and I am using the  configuration
files described bellow.

 

I would like to understand why I am able to connect to MS SQL Server through
the tsql utility and the isql fail.

 

[root at PRODAMBFC0602 ~]# tsql -S MSSQLCON2 -U user_gestao

locale is "en_US.UTF-8"

locale charset is "UTF-8"

Password:

1>

2>

 

 

[root at PRODAMBFC0602 ~]# isql -v MSSQLCON2 user_gestao    <password>

[S1000][unixODBC][FreeTDS][SQL Server]Unable to connect to data source

[ISQL]ERROR: Could not SQLConnect

 

 

Thanks a lot for your help!

 

 

Claudio F. Salvador



(11) 3396-9643

 <mailto:cfsalvador at prodam.sp.gov.br> cfsalvador at prodam.sp.gov.br

 

 

 

/etc/odbc.ini

[MSSQLCON]

Driver           = FreeTDS

Description      = ACESSO AO SQLSERVER

Trace            = no

Servername       = PRODABFC103594

Port             = 1433

Database         = PRODABFC103594\SQLEXPRESS

 

 

[MSSQLCON2]

Driver           = FreeTDS

Description      = ACESSO AO SQLSERVER do BI

Trace            = no

Servername       = c66s211i

Port             = 1433

Database         = c66s211i\DES

 

/etc/odbcinst.ini

[ODBC]

Trace           = Yes

TraceFile       = /tmp/sql.log

ForceTrace      = Yes

Pooling         = No

 

[PostgreSQL]

Description             = ODBC for PostgreSQL

Driver          = /usr/lib/libodbcpsql.so

Setup           = /usr/lib/libodbcpsqlS.so

FileUsage               = 1

 

[TDS]

Description             = v0.52 with protocol v4.2

Driver          = /usr/local/lib/libtdsodbc.so

Setup           = /usr/lib/libtdsS.so

FileUsage               = 1

 

[FreeTDS]

Description             = v0.52 with protocol v4.2

Driver          = /usr/local/lib/libtdsodbc.so

Setup           = /usr/lib/libtdsS.so.1

FileUsage               = 1

 

 

/usr/local/etc/freetds.conf

[MSSQLCON]

        host=<ip_server>

        port = 1433

        tds version = 8.0

        instance = SQLEXPRESS

 

 

[MSSQLCON2]

        host=<ip_server>

        port = 1433

        tds version = 8.0

        instance = DES

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090123/f09f5dee/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image002.jpg
Type: image/jpeg
Size: 2528 bytes
Desc: not available
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20090123/f09f5dee/attachment-0001.jpg>
-------------- next part --------------
________________________________________________________________

?Esta mensagem, incluindo seus anexos, é confidencial e seu conteúdo é restrito ao destinatário da mensagem. Caso você a tenha recebido por engano, queira, por favor, retorná-la ao destinatário e apagá-la de seus arquivos. É expressamente proibido o uso não autorizado, replicação ou disseminação da mesma. As opiniões contidas nesta mensagem e seus anexos não necessariamente refletem a opinião do órgão emissor. Grato pela colaboração?.