Hi Julien, This is a generic option available across all OS’es, to use add the following to the param to your Postgres ST Driver DSN in the odbc.ini file:
MultipleActiveStmtsEmul = Yes
I shall have this added to the Unix ST documentation page ...
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
On 25 Jun 2012, at 18:10, Julien Plu wrote:
> Thanks Hugh, but I'm not on OSX, but on Linux Ubuntu, and in the drivers
> provide for Linux (as you can see there :
> http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallPostgreSQLLiteUnix
>
> There is no option for MASE in the process.
>
> -------------------------------------------------------------------------------------------------------------------------------
> Julien Plu
>
> Etudiant en 2ème année de Master Ingénierie en Intelligence Artificielle à
> l'université Montpellier 2.
> Responsable de la rubrique Web sémantique de Developpez.com.
> Mes projets Web sémantique: http://data.lirmm.fr
> Page personnelle: http://jplu.developpez.com
> Fichier FOAF (version RDF): http://jplu.developpez.com/julien
> Fichier FOAF (version RDFa): http://jplu.developpez.com/julien.html
> Adresse mail personnelle: [email protected]
> Adresse mail universitaire: [email protected]
>
>
>
> 2012/6/25 Hugh Williams <[email protected]>
> Hi Julien,
>
> Please enable the Multiiple Active Statement Emulation (MASE) option of the
> UDA Postgres Lite Driver which should resolve this error as detailed at:
>
>
> http://wikis.openlinksw.com/dataspace/owiki/wiki/UdaWikiWeb/InstallPostgreSQLLiteOSX
>
> Best Regards
> Hugh Williams
> Professional Services
> OpenLink Software, Inc. // http://www.openlinksw.com/
> Weblog -- http://www.openlinksw.com/blogs/
> LinkedIn -- http://www.linkedin.com/company/openlink-software/
> Twitter -- http://twitter.com/OpenLink
> Google+ -- http://plus.google.com/100570109519069333827/
> Facebook -- http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 25 Jun 2012, at 17:51, Julien Plu wrote:
>
>> Problem solved, but now I have another problem, when I execute my request
>> now I have this error message :
>>
>> Virtuoso IM921 Error VD052: Remote DSN PostgreSQL Sample DSN:
>> [OpenLink][ODBC][Driver]Connection is busy with results for another hstmt.
>> Any idea of what's happened ?
>>
>> -------------------------------------------------------------------------------------------------------------------------------
>> Julien Plu
>>
>> Etudiant en 2ème année de Master Ingénierie en Intelligence Artificielle à
>> l'université Montpellier 2.
>> Responsable de la rubrique Web sémantique de Developpez.com.
>> Mes projets Web sémantique: http://data.lirmm.fr
>> Page personnelle: http://jplu.developpez.com
>> Fichier FOAF (version RDF): http://jplu.developpez.com/julien
>> Fichier FOAF (version RDFa): http://jplu.developpez.com/julien.html
>> Adresse mail personnelle: [email protected]
>> Adresse mail universitaire: [email protected]
>>
>>
>>
>> 2012/6/25 Julien Plu <[email protected]>
>> Hi,
>>
>> I made a R2RML mapping and I use a SQL view in this mapping that I created.
>> So when I try to query the result of this mapping I fall on this error :
>>
>> Virtuoso 42000 Error SQ200: Must have select privileges on view
>> musicbrainz_db.musicbrainz.musicbrainz_view
>> Even if I do :
>>
>> GRANT SELECT ON musicbrainz_db.musicbrainz.musicbrainz_view TO "SPARQL",
>> "SPARQL_UPDATE"
>>
>> Have-you an idea for why this error occur ?
>>
>> Thanks in advance.
>>
>> Best.
>>
>> -------------------------------------------------------------------------------------------------------------------------------
>> Julien Plu
>>
>> Etudiant en 2ème année de Master Ingénierie en Intelligence Artificielle à
>> l'université Montpellier 2.
>> Responsable de la rubrique Web sémantique de Developpez.com.
>> Mes projets Web sémantique: http://data.lirmm.fr
>> Page personnelle: http://jplu.developpez.com
>> Fichier FOAF (version RDF): http://jplu.developpez.com/julien
>> Fichier FOAF (version RDFa): http://jplu.developpez.com/julien.html
>> Adresse mail personnelle: [email protected]
>> Adresse mail universitaire: [email protected]
>>
>>
>> ------------------------------------------------------------------------------
>> Live Security Virtual Conference
>> Exclusive live event will cover all the ways today's security and
>> threat landscape has changed and how IT managers can respond. Discussions
>> will include endpoint security, mobile security and the latest in malware
>> threats.
>> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
>> Virtuoso-users mailing list
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats.
> http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
