[freetds] Freetds-0.64-6 gets crazy

Adriano Duarte adriano.didi at gmail.com
Wed Oct 31 13:26:34 EST 2007


   Please could someone here help me??

   I have this problem:

isql -v coad user password
  SQL> select SENHA from ura_instant where SENHA ='24772375'
+---------+
| SENHA   |
+---------+
| 24772375|
| 24772375|
+---------+
SQLRowCount returns 2
2 rows fetched
SQL> select SENHA from ura_instant where SENHA ='24772375'
+------------+
|            |
+------------+
+------------+
SQLRowCount returns 0
SQL> select SENHA from ura_instant where SENHA ='24772375'
SQLRowCount returns -1
SQL> select SENHA from ura_instant where SENHA ='24772375'
+---------+
| SENHA   |
+---------+
| 24772375|
| 24772375|
+---------+
SQLRowCount returns 2
2 rows fetched

    I have tried to install both freetds-0.64-6.rpm and
freetds-stable.tgzand it's all the same.

    System:  Fedora 6 - Kernel 2.6.18-1.2798.fc6 - i386 - freetds-0.64-6 -
unixODBC-2.2.11-7.1

/etc/odbc.ini
[instantvoice]
Description     = InstantVoice database
Trace       = Off
TraceFile   = stderr
Driver      = MySQL
SERVER      = localhost
USER        = user
PASSWORD    = password
PORT        = 3306
SOCKET      = /var/lib/mysql/mysql.sock
DATABASE    = instantvoice

[coad]
Driver          = TDS
Description     = Coad MSSQL
SERVER          = 10.0.0.7
DATABASE        = corporativo2
USER            = user
PASSWORD        = password
PORT            = 1433

/etc/odbcinst.ini
[MySQL]
Description             = ODBC for MySQL
Driver          = /usr/lib/libmyodbc3_r.so
UsageCount              = 8

[TDS]
Description             = ODBC Driver for MSSQL
Driver          = /usr/lib/libtdsodbc.so
Setup           = /usr/lib/libtdsS.so
UsageCount              = 6

    And please forgive my english.


More information about the FreeTDS mailing list