Icon View Incident Report

Serious Serious
Reported By: Arnd Baranowski
Reported On: 9/28/2004
For: Version 4.10 Build 1
# 1850 SQL INSERT, UPDATE, OR DELETE Statements Do Not Work Inside of a Server-Side Procedure

I am getting the following error on the EXECSQL operations in remote procedures (4.10 and Dlphi 6)

#11288 The user 'ABMTCarrier' is not authorized to perform this operation with the database '' on the database server at ''.

I do the following (Administratively everything is setup correct):

1. Set up a Datamodule with TDBISAMDatabase plus Queries and Tables at designtime,
2. Generate the datamodule when the procedure is called,
3. Extract Directory and assign Directory and ServerSession.SessionName to TDBISAMDatabase
4. Assign ServerSession.SessionName and DBISAMDatabase.DatabaseName to Datasets.
5. Opening, Creating of Tables and Queries works.
6. Executing a Query with EXECSQL (regardless what sort of operation) returns the described error.

Comments Comments and Workarounds
The workaround is to use table-based methods for appending, deleting, etc.

Resolution Resolution
Fixed Problem on 9/29/2004 in version 4.11 build 1