Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Micros 3700 ISL SIM, error inserting record

Status
Not open for further replies.

JCCR

IS-IT--Management
Mar 20, 2016
71
CO
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
 
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
 
//connection string
Format gDbConnectionString As "ODBC;UID=",dbUser,";PWD=",dbPass

//open database connection
DLLCALL_CDECL gDbDllHandler, sqlInitConnection("micros", gDbConnectionString, " ")
 
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
 
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
 
codexPOSed I am qualifying like this INSERT INTO custom.table_name

CathalMF The SQL statements are the same

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top