Connect to Virtuoso (ODBC, JDBC, OLE DB, .NET)

OLE DB Data Access Providers (Windows Client)

Configure & Test Virtuoso OLE DB Provider Strings

1. Expand the Start menu.

2. Expand the All Programs menu.

3. Expand the OpenLink Virtuoso folder.

4. Expand the Client Samples folder.

4. Expand the OLEDB folder.

5. Launch the OLEDB Rowset Viewer application.

6. Expand the File menu.

7. Select Full Connect.

8. Use the Provider: drop-down menu on the Provider tab to select VIRTOLEDB.

9. Click OK.

10. Provide the target DBMS dba username and password when prompted.

11. Click the options button to ensure that the target DSN is properly configured.

12. Proceed to configure your DSN.

13. Click OK.

14. Type your SQL statement into the SQL statement box.

15. Click SQL->.

16. Click OK.

17. Review your resultset.

18. Upon succesful connection and querying, 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=Demo;Prompt=NoPrompt;"

For example:

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