I am trying to execute query via python Getting error like: Driver not Capable. Any Direction or suggestion for resolution would be helpful.
('HYC00', '[HYC00] [Micro Focus][Relativity for RM]Driver not capable. (0) (SQLBindParameter)')
My setup:
Operating System: Red Hat Enterprise Linux release 8.0 (Ootpa)
Relativity Client Version : 12.17
Relativity Server: 12.17
Python code:
import pyodbc
import datetime
import time
conn=pyodbc.connect('DSN=xxxxxx;UID=yyyy;PWD=zzzz')
Array=[]
InsertQueue=[3,'xxx','uuuu','tttt']
cursor=conn.cursor()
sql="INSERT INTO table VALUES (?,?,?,?)"
Array=['A1,'A2','A3']
rowno = 0
for subx,item in enumerate(Array):
InsertQueue[1]= item
InsertQueue[2] = 'SSSS'
InsertQueue[3] = str(datetime.datetime.now())
try:
cursor.execute(sql,InsertQueue)
except pyodbc.Error as e:
print(e)
conn.commit()
conn.close()