SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

ODBC ERROR

Reply
New Contributor
Posts: 2

ODBC ERROR

When trying to update a record in an Ingres database from DI Studio I get the following error:

ERROR: Error updating table entry: [Ingres][Ingres ODBC Driver]No cursor name available

I am able to select values from the same table. Just unable to perform UPDATE operation.

any help?

Allen
Super User
Posts: 5,424

Re: ODBC ERROR

Posted in reply to tarheel56
You need to isolate the problem.
-Is the happening when executing code from standard transformations (Table Loader/SCD Type 2 Loader)?
-Can you update this table from other ODBC clients?
-Can you update the table "inside" Ingres using the same userid/schema as used in the ODBC connection?

Pls share a more complete log.

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 213 views
  • 0 likes
  • 2 in conversation