Micros 3700 ISL SIM, error inserting record

[JCCR]

Hello everybody

I have to insert records into a table from a sim but sybase returns an error saying permission denied, but if I do it directly in sybase central with the same user it does so without generating an error. Does anyone know why this can happen?

DLLCall_CDecl gDbDllHandler, sqlExecuteQuery(ref _sqlComamnd)

Note: I am using Micros Res 3700 5.4

 

[CathalMF]

Can you post the sqlInitConnection line?



Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website

http://www.microspostools.com/

 

[JCCR]

//connection string
Format gDbConnectionString As "ODBC;UID=",dbUser,";PWD=",dbPass

//open database connection
DLLCALL_CDECL gDbDllHandler, sqlInitConnection("micros", gDbConnectionString, " ")

 

[codexPOSed]

hey JCCR,
Depending on what Db, user schema your table is and what user you use in your connection string, you may have to fully qualify the table names you insert into, like micros.micros.mytable, or micros.custom.mytable

 

[CathalMF]

But if he is using the same credentials in the SIM and from sybase then the SQL will be identical.

Are you sure the SQL being executed is exactly the same?

Specialist in creating custom applications for the Micros POS range: 3700, 9700, Simphony FE, Simphony. SIM Scripts, Data Exports, Simphony extension applications, API Creation and integration. If you need anything please contact me via my website

http://www.microspostools.com/

 

[JCCR]

codexPOSed I am qualifying like this INSERT INTO custom.table_name

CathalMF The SQL statements are the same

Thanks