Question: Prerequisites documentation

[MPParsley]

Thank you very much for this valuable component.

Are there any other prerequisites besides the python libraries mentioned and a default VOS setup that provides the odbc on port 1111?

It might be useful to have a devcontainer running Virtuoso to run the examples, or any steps that are needed within Virtuoso to configure the user/password (although looking at the example DSN I assume the default username/password are used).

[HughWilliams]

In addition to the python libs you also need to have unixODBC used by pyodbc to make the ODBC connection to the Virtuoso database.

The SPASQL examples can be tested using our Live Demo Virtuoso instance where the necessary Northwind database tables and views are already in place and is accessible via SQL on Address demo.openlinksw.com:21118 , to a database name Demo , with readonly access to username/password of demo/demo. Thus an ODBC DSN of the following form is required:

[VOS]
Driver  = /opt/virtuoso/lib/virtodbcu_r.so 
Address = demo.openlinksw.com:21118
Username = demo
Password = demo
Database = Demo
WideAsUtf16 = Y

Note the WideAsUtf16 = Y is required for use with unixODBC ...