Configuring and Testing the OLE DB Provider for Virtuoso

1. In the Start menu, drill down to All Programs -> OpenLink Virtuoso -> Client Samples -> OLE DB -> OLE DB Rowset Viewer.
   
2. Select File -> Full Connect.
   
3. Use the Provider: drop-down menu on the Provider tab to select VIRTOLEDB.
   
4. Click OK.
   
5. Provide the DBA username and password for the target DBMS when prompted (Virtuoso defaults are dba and dba).
   
6. Click the Options button to ensure that the target DSN is properly configured.
   
7. Adjust your DSN configuration, if necessary.
   
8. Click OK.
   
9. Type your SQL statement into the SQL statement box.
   
10. Click SQL->.
    
11. Click OK.
    
12. Review your result set.
    
13. After a successful connection and query, proceed to use the following syntax to build OLE DB provider strings for use with client applications:
    
    

    
    strConn = "Provider=VIRTOLEDB;Data Source=<virtuoso server ip address>:<virtuoso listen port>:1;User Id=<uid>;Password=<pwd>;Initial Catalog=<target catalog>;Prompt=NoPrompt;"
    

    
    For example:
    
    

    
    strConn = "Provider=VIRTOLEDB;Data Source=localhost:1111;User Id=dba;Password=dba;Initial Catalog=Demo;Prompt=NoPrompt;"