Apologies to Oracle Corp.

From: Mladen Gogala <gogala.mladen_at_bogus.email.com>
Date: Fri, 5 Jun 2009 11:08:24 +0000 (UTC)
Message-ID: <h0aub7$vrj$1_at_solani.org>



It seems that I owe an apology to the Oracle Corp., their ODBC driver works fine:
[mgogala_at_centos trace]$ /usr/local/bin/isql -v OracleODBC-11g scott/tiger
+---------------------------------------+

| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from emp;
+-------+-----------+----------+-------+--------------------+----------+--------
--+-------+

| EMPNO | ENAME | JOB | MGR | HIREDATE | SAL | COMM
  | DEPTNO|
+-------+-----------+----------+-------+--------------------+----------+--------
--+-------+

| 7369 | SMITH | CLERK | 7902 | 1980-12-17 00:00:00| 800 |
| 20 |
| 7499 | ALLEN | SALESMAN | 7698 | 1981-02-20 00:00:00| 1600 | 300
| 30 |
| 7521 | WARD | SALESMAN | 7698 | 1981-02-22 00:00:00| 1250 | 500
| 30 |
| 7566 | JONES | MANAGER | 7839 | 1981-04-02 00:00:00| 2975 |
| 20 |
| 7654 | MARTIN | SALESMAN | 7698 | 1981-09-28 00:00:00| 1250 | 1400
| 30 |
| 7698 | BLAKE | MANAGER | 7839 | 1981-05-01 00:00:00| 2850 |
| 30 |
| 7782 | CLARK | MANAGER | 7839 | 1981-06-09 00:00:00| 2450 |
| 10 |
| 7788 | SCOTT | ANALYST | 7566 | 1987-04-19 00:00:00| 3000 |
| 20 |
| 7839 | KING | PRESIDENT| | 1981-11-17 00:00:00| 5000 |
| 10 |
| 7844 | TURNER | SALESMAN | 7698 | 1981-09-08 00:00:00| 1500 | 0
| 30 |
| 7876 | ADAMS | CLERK | 7788 | 1987-05-23 00:00:00| 1100 |
| 20 |
| 7900 | JAMES | CLERK | 7698 | 1981-12-03 00:00:00| 950 |
| 30 |
| 7902 | FORD | ANALYST | 7566 | 1981-12-03 00:00:00| 3000 |
| 20 |
| 7934 | MILLER | CLERK | 7782 | 1982-01-23 00:00:00| 1300 |
  | 10 |
+-------+-----------+----------+-------+--------------------+----------+--------
--+-------+
SQLRowCount returns -1
14 rows fetched
SQL> The problem is, apparently, in the Linux package unixODBC which I had to link manually. That's why I have /usr/local/bin/isql instead of just "isql".

Also, thanks to Joel who suggested that. Unfortunately, heterogenous services still behave like before.

-- 
http://mgogala.freehostia.com
Received on Fri Jun 05 2009 - 06:08:24 CDT

Original text of this message