Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 28, 2015 at 08:28 AM

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

    Add comment
    10|10000 characters needed characters exceeded