Rdfs_rule_set via ODBC

Virtuoso Universal Server Web Application Services
, ,
1

I am trying to execute the rdfs_rule_set() command through ODBC.

I am getting the following error pyodbc.ProgrammingError: ('42000', '[42000] [OpenLink][Virtuoso ODBC Driver][Virtuoso Server]SQ074: Line 1: syntax error (-1) (SQLExecDirectW)').

The fact that it is a syntax error bugs me, since it is the exact same command I would have typed in isql : rdfs_rule_set ('http://hyperstorylines.com/session/g','http://hyperstorylines.com/session/g'); and when I test it live it works without a problem.

Is there a subtility I’m missing about using these commands through ODBC ?

2

Hi @nk-fouque,

The ODBC communications channel is for SQL calls. ISQL handles more than SQL calls hence the difference you are experiencing.

3

Hi,
Thanks for your clear answer, but then how can I achieve the same thing as rdfs_rule_set through an API and without having to manually open iSQL ?

4

@nk-fouque

If you have trailing semi-colon remove it, and execute with SQLExecDirect, this (; ) character is statement delimiter for ISQL tool.

HTH