Problem with BLOB Insert to MySQL using ODBC

[gauthampdas]

I have to copy a file into MySQL database as a Blob. I tried it using 2 methods.

1. Using MySQLdb module
2. Using mxODBC & pyodbc modules (through ODBC)

The first one executed properly and I was able to retrieve the data from database. When I tried it with ODBC (second), I got stuck up at cursor.execution(). I want to use the ODBC method as I am doing a testing for the ODBC connection. Both codes are given below. Please help. Thanks in advance.

GPD

Using MySQLdb

import MySQLdb
fid = open("file","rb")
bindata = fid.read()
fid.close()
dat = MySQLdb.Binary(bindata)
i=130
db = MySQLdb.connect('localhost','root','root','blob_test')
cursor = db.cursor()
stat = cursor.execute("insert into test_db (ts,packet) values (%s,%s)", (i,bindata))
db.commit()
#stat = cursor.execute("select packet from test_db where ts=%s",i)
#data = cursor.fetchall()
#print len(data[0][0]),data[0][0]
#fid = open("newfile","wb")
#fid.write(data[0][0])
#fid.close()
cursor.close()
db.close()

Using mxODBC & pyodbc modules (through ODBC)

import mx.ODBC.Windows as drv

db = drv.DriverConnect("DSN=testDSN")
cursor = db.cursor()

fid = open("file","rb")
bindata = fid.read()
fid.close()
dat = drv.Binary(bindata)
num = 130

cursor.execute("insert into test_db (ts,packet) values (%s,%s)", (num,dat))
#cursor.execute("insert into test_db (ts,packet) values (%s,%s)", (num,bindata))
db.commit()
cursor.close()
db.close()