FreeTDS Development Group

["fred" <fred AT fredsnet.org>]

greetings folks.

I have a redhat linux AS3 server and I've installed Oracle 10g (release 
10.0.3. for 32 bit linux) We have HS services running.  I have unixODBC-
2.2.8-2.3.0.2 rpm from redhat installed as well as the devel package.

I've downloaded the latest stable release from freetds' website ver 0.63
 and compiled it with these options. 
./configure --prefix=/usr --sysconfdir=/etc --with-tdsver=8

my database name is perfx, and the database link is peis
from sqlplus at my desktop connected to the database perfx,
when I run 

SQL> select * from Actions@PEIS

I get------

ERROR:
ORA-28500: connection from ORACLE to a non-Oracle system returned this 
message:
[Generic Connectivity Using ODBC][unixODBC][FreeTDS][SQL Server]Invalid 
cursor
state (SQL State: 24000; SQL Code: 0)
ORA-02063: preceding 2 lines from PEIS
no rows selected

when I run 
]
SQL> describe Actions@PEIS

I get ----

 Name                                      Null?    Type
 ----------------------------------------- -------- --------------------
--
 ActionID                                  NOT NULL NUMBER(10)
 ActionNumber                                       NUMBER(10)
 Assignee                                           VARCHAR2(50)
 AssigneeID                                         VARCHAR2(50)
 Subject                                            VARCHAR2(80)
 Originator                                         VARCHAR2(50)
 OriginatorID                                       VARCHAR2(50)
 DateOpened                                         DATE
 DateDue                                            DATE
 DateCompleted                                      DATE
 DateRejected                                       DATE
 DateClosed                                         DATE
 Priority                                           VARCHAR2(40)
 Description                                        LONG
 Result                                             LONG
 Category                                           VARCHAR2(40)
 ReferenceID                                        VARCHAR2(50)
 Reference                                          VARCHAR2(40)
 Reviewed                                  NOT NULL NUMBER(10)
 ActionType                                         NUMBER(5)
 Flags                                              VARCHAR2(32512 CHAR)
 Alert                                     NOT NULL NUMBER(3)
 ExternalDueDate                                    DATE
 ActionLocation                                     VARCHAR2(40)
 ActionNotes                                        LONG
 ActionSource                                       VARCHAR2(40)
 ArchiveFlag                                        NUMBER(10)

SQL>


any tips on what I should do?


Thanks 

Fred

--