Inserting Long Binary data into Access db using pyodbc

Question

I can insert text and integer data to MS Access db (.mdb) by using pyodbc package. But now i want to insert Large Binary objects. I have a table that consists ID(COUNTER type), Name(VARCHAR type), File (LONGBINARY type), Author(VARCHAR type) columns. I use that code to insert some text and int data:

cursor.execute("""INSERT INTO table(ID, Name) VALUES(1,'book')""")

After that i used that code but always getting error.

with open('c:/tree.jpg', 'rb') as file:
      binData = file.read()

SQL = """INSERT INTO table VALUES(2,'threePicture', %s, 'Mike')""" %(binData)

cursor.execute(SQL)

The error is: ProgrammingError: ('42000', "[42000])

pyNihat · Accepted Answer · 2014-04-28 21:16:17Z

1

I found the solution using ? ? ? characters...

cursor.execute("insert into table values(?, ?, ?, ?)", 2, 'treePicture', pyodbc.Binary(binData), 'Mike')

Use ? chars for values in expression.

edited Apr 28, 2014 at 21:16

answered Apr 28, 2014 at 11:00

pyNihat

314 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Inserting Long Binary data into Access db using pyodbc

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related