We are using SAP DB with Windows XP SP1, Visual Basic 6 SP5 and ADO. Works fine.
But (now) we get an error when using DISTINCT or GROUP BY:
Error Number: -2147467259
Error Description: [SAP AG][SQLOD32 DLL][SAP DB]General error;-7008 POS(78) Updates of this table not allowed.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
The statement is: SELECT DISTINCT Ort FROM LagerPlatz
The Create Statement is:
create table LagerPlatz ( Platz varchar(11) not null, Ort varchar(3) not null, Regal varchar(2) DEFAULT '' not null, Reihe varchar(2) DEFAULT '' not null, Hoehe varchar(2) DEFAULT '' not null, Status int DEFAULT 0 not null , Info varchar(30) DEFAULT '' not null, cnt int DEFAULT 0 not null , primary key (Platz, Ort) )
The Connection String is:
;DRIVER=SAP DB 7.4;SERVERNODE=TEST_PC;UID=XXX;PWD=YYY;SERVERDB=ZZZ;SERVER=TEST_PC
!!!When trying the Statemtent with RDO or DBMCLI everything works!!!
When trying SELECT Ort FROM LagerPlatz it works under ADO.
When trying SELECT Ort FROM LagerPlatz GROUP BY 1 I get the same error as with DISTINCT.
The error occured on SAP DB 7.3.0.29, so I installed 7.4.3.10. I dropped the database and created a completely new one. I also updated the ODBC driver and the DSN entry. But that had no effect. I get the same error.
Do you have any suggestions on this problem?
Kind regards,
Benjamin Lukner trinomix GmbH
_______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
