From: Uldis B. <cap...@gm...> - 2012-11-24 21:15:19
|
Hi Hugh, > 1. The version of Virtuoso being used as last we spoke you were using 6.1.4 shipped with Ubuntu 12.04 and were going to attempt to rebuild for source to update to the latest 6.1.6 version ? Still 6.1.4 shipped with Ubuntu. Will update, but did not get around to it yet. However, this problem appears to be client-side. > 2. The version of the Virtuoso ODBC Driver on windows being used ie how does it compare with the server version being used on Ubuntu ? Version 6.04.3132.01 from Virtuoso Connectivity Kit (guess that is the name). > 3. The query being run that is causing this error, which I assume runs successfully if run from isql or the /sparql endpoint ? It's a series of INSERT IN GRAPH <uri> { triples } statements. The failure does not happen on the first query, but takes some time (3 - 10 statements in a row) to build up. For some time it happened on every 3rd statement. It does not seem to be associated with any particular statement. It's a number of statements in a row that causes the problem. > You indicate a C# .Net 4.0 application is being used, in which case how does this application invoke the Virtuoso ODBC Driver does it use the ADO.Net ODBC Bridge Provider (System.Data.Odbc) built-in or other method. Also have you Using the ODBC bridge (System.Data.Odbc): _Conn = new OdbcConnection(ConnectionStrings.Sparql()); _Conn.Open(); >considered using the Virtuoso ADO.Net Provider to make a direct connection to Virtuoso and invoke SPASQL queries via this means, see: How does this approach differ from the ODBC bridge? Could you show (or point to) an example of doing a SPASQL query via ADO.Net Provider? I got lost in the contents of http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtAdoNet35Provider -- could not find a simple example how to run a SPARQL query. Thanks, Uldis |