Error connecting to MarkLogic ODBC server from pyodbc on Windows

Asked Jul 05 '19 at 02:22

Active Jul 06 '19 at 20:51

Viewed 106 times

I am trying to connect to MarkLogic ODBC server using pyodbc. The connection opens fine. However, when I run a query with cursor.execute, I get an error,

XDMP-UNEXPECTED: (err:XPST0003) Unexpected token syntax error, unexpected "", expecting ""

As per MarkLogic, this might happen if client expects transaction or adds "BEGIN..." at the start. In this case, even after turning pyodbc autocommit off, the error persists.

Note that the same query works with C# DataSet code.

The SQL query is simple SELECT * FROM TABLE_NAME.

edited Jul 06 '19 at 20:51

Mads Hansen

63,927
12
112
147

asked Jul 05 '19 at 02:22

Yogesh Sajanikar

1,086
7
19

Try turning autocommit *on*, e.g., `cnxn = pyodbc.connect(connection_string, autocommit=True)` – Gord Thompson Jul 05 '19 at 06:16
autocommit=True works! – Yogesh Sajanikar Jul 16 '19 at 03:51
However, pyodbc fails to reflect schemas from Marklogic. This should be another question though. – Yogesh Sajanikar Jul 16 '19 at 03:51

Error connecting to MarkLogic ODBC server from pyodbc on Windows

0 Answers0