https://communities.sas.com/t5/SAS-Data-Management/ODBC-ERROR/m-p/70214#M635 When trying to update a record in an Ingres database from DI Studio I get the following error: <BR /> <BR /> ERROR: Error updating table entry: [Ingres][Ingres ODBC Driver]No cursor name available<BR /> <BR /> I am able to select values from the same table. Just unable to perform UPDATE operation.<BR /> <BR /> any help?<BR /> <BR /> Allen Tue, 08 Feb 2011 19:13:05 GMT tarheel56 2011-02-08T19:13:05Z https://communities.sas.com/t5/SAS-Data-Management/ODBC-ERROR/m-p/70214#M635 When trying to update a record in an Ingres database from DI Studio I get the following error: <BR /> <BR /> ERROR: Error updating table entry: [Ingres][Ingres ODBC Driver]No cursor name available<BR /> <BR /> I am able to select values from the same table. Just unable to perform UPDATE operation.<BR /> <BR /> any help?<BR /> <BR /> Allen Tue, 08 Feb 2011 19:13:05 GMT https://communities.sas.com/t5/SAS-Data-Management/ODBC-ERROR/m-p/70214#M635 tarheel56 2011-02-08T19:13:05Z https://communities.sas.com/t5/SAS-Data-Management/ODBC-ERROR/m-p/70215#M636 You need to isolate the problem.<BR /> -Is the happening when executing code from standard transformations (Table Loader/SCD Type 2 Loader)?<BR /> -Can you update this table from other ODBC clients?<BR /> -Can you update the table "inside" Ingres using the same userid/schema as used in the ODBC connection?<BR /> <BR /> Pls share a more complete log.<BR /> <BR /> /Linus Tue, 15 Feb 2011 09:05:08 GMT https://communities.sas.com/t5/SAS-Data-Management/ODBC-ERROR/m-p/70215#M636 LinusH 2011-02-15T09:05:08Z