insert object in database using pyodbc

32 views
Skip to first unread message

kshtz....@gmail.com

unread,
Sep 22, 2018, 11:39:08 AM9/22/18
to pyodbc
I tried the following but it didn't work:

import pyodbc
import pickle

server = 'localhost'
database= 'Student_DB'
username = 'username'
password = 'password'
conn = pyodbc.connect('DRIVER={ODBC Driver 17 for SQL Server}; SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+password)
cursor = conn.cursor()
keypoints_database = pickle.load( open( "5958.p", "rb" ) )
sql = 'INSERT INTO tb_fpdata (Std_SymbolNo , FP_Descriptors) VALUES (5958 , ?)' , pyodbc.Binary(keypoints_database)

I got the following error:

error.png

error.png
Reply all
Reply to author
Forward
0 new messages