Skip to Content.
Sympa Menu

freetds - [freetds] invalid cursor state

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "fred" <fred AT fredsnet.org>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] invalid cursor state
  • Date: Tue, 28 Jun 2005 11:44:11 -0500

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

--





Archive powered by MHonArc 2.6.24.

Top of Page