Problem:
Received Open Connection: Driver={Oracle ODBC Driver}; Data Source=DSLATM;
User ID=dsl; Password=dsld; from 10.1.253.12(1364)
Sending: 100 SQL
101 OK
199 EOF
to 10.1.253.12
Received SQL Record Select: SELECT * FROM DSL.ADSL_EQUIPMENT from
10.1.253.12(1364)
Sending: 100 SQL
101 OK
199 EOF
to 10.1.253.12
Received Move to First Delim Record: @@END from 10.1.253.12(1364)
Sending: 100 SQL
101 OK ALCATEL-7300 ~1 ~3 ~ATMIF/122 (LP/12 Sonet/2) ~ABDR SYS 1 CH 096
~177 ~128 ~ATM1/0/1 ~177 ~128 ~BRAS ATM1/0/1.177128 ~ALDENBRIDGE AID
1-1-8-12 ~0 ~0 ~12x12 ~CONROE_ABDR_ABDR SYS 1 CH 096 ~N ~ ~ to 10.1.253.12
Received Move to Next Delim Record: @@END from 10.1.253.12(1364)
Sending: 100 SQL
101 OK
199 EOF
to 10.1.253.12
Received Move to Last Delim Record: @@END from 10.1.253.12(1364)
Sending: 100 SQL
999 ERR 3704 Operation is not allowed when the object is closed. to
10.1.253.12
Solution:
Make sure when trying to query an Oracle database that the field names that you are using in the SELECT statement are correct.
