sqlanydb python - load table failing. sqlanydb.OperationalError: Operation failed on file due to file permissions

[former_member292708]

sqlanydb.OperationalError: Operation failed on file due to file permissions. File: /tmp/junk.junk

-- (hos_clientfileio.cxx 142)

unfortunately, this msg doesn't allow me to discern real permission issue from missing file b/c when I use the name of a non-existent file, i get the same error.

I am using sqlanydb python module version: sybase-iq-15.4

i have tried to set this option:

       sql_statement='''

            sa.stored_proc_name '{f}' '''.format(f=filename)

        conn = sqlanydb.connect( DSN=s, userid=u, pwd=p )

        cur = conn.cursor()

        cur.execute('''set option ALLOW_READ_CLIENT_FILE='ON' ''')

        cur.execute(sql_statement)

        cur.close()

        conn.commit()

        conn.close()

but no luck.

can you help me determine what is wrong here?

thanks,

Mark

[Former Member]

Are you able to run these SQL statements direct with e.g. dbisql?