Skip to Content.
Sympa Menu

freetds - [freetds] Freetds-0.64-6 gets crazy

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Adriano Duarte" <adriano.didi AT gmail.com>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Freetds-0.64-6 gets crazy
  • Date: Wed, 31 Oct 2007 15:26:34 -0300

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.




Archive powered by MHonArc 2.6.24.

Top of Page