This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Problem in executing Query via Python + Passing Parameters + Sql Relativity Unix client + Unix

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()

  • 0

    The HYC00 error in Microsoft's ODBC API documentation lists several exceptions.  Here is the text from Microsoft's documentation:

    HYC00 Optional feature not implemented The driver or data source does not support the conversion specified by the combination of the value specified for the argument ValueType and the driver-specific value specified for the argument ParameterType.

    The value specified for the argument ParameterType was a valid ODBC SQL data type identifier for the version of ODBC supported by the driver but was not supported by the driver or data source.

    The driver supports only ODBC 2.x and the argument ValueType was one of the following:

    SQL_C_NUMERIC SQL_C_SBIGINT SQL_C_UBIGINT

    and all the interval C data types listed in C Data Types in Appendix D: Data Types.

    The driver only supports ODBC versions prior to 3.50, and the argument ValueType was SQL_C_GUID.