×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Micros 3700 ISL SIM, error inserting record

Micros 3700 ISL SIM, error inserting record

Micros 3700 ISL SIM, error inserting record

(OP)
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

RE: Micros 3700 ISL SIM, error inserting record

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/

RE: Micros 3700 ISL SIM, error inserting record

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

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

RE: Micros 3700 ISL SIM, error inserting record

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

RE: Micros 3700 ISL SIM, error inserting record

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/

RE: Micros 3700 ISL SIM, error inserting record

(OP)
codexPOSed I am qualifying like this INSERT INTO custom.table_name

CathalMF The SQL statements are the same

Thanks

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close