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

ODBC Data Access Drivers (Windows Client)

Configure the DSN

1. Launch the ODBC Data Sources Administrator which appears in the Control Panel or its Administrative Tools sub-folder.

2. Click the System DSN tab.

3. Click Add.

4. Select the OpenLink Virtuoso driver from the ODBC Drivers listbox.

5. Click Finish.

6. Use the first dialog to provide the following information:

• Name - A descriptive title for your DSN
  
• Description - An optional description of the DSN
  
• Server - The IP address and TCP port associated with the Virtuoso DBMS server. For example: localhost:1111
  
• This server requires a secure connection (SSL) - Check to instantiate SSL data encryption

7. Use the second dialog to provide the following information:

• Authentication method - Select Client/Server challenge protocol, encrypted password, or plaintext password
  
• Connect to the Virtuoso Server to obtain default settings for the additonal configuration options - Check to poll the Virtuoso DBMS for other configurable options
  
• User name - The Virtuoso DBA username
  
• Password - The Virtuoso DBA password

8. Use the third dialog to provide the following information:

• Change the default database to - Select the target database schema
  
• Change the default character set to - Select the desired characterset
  
• Change the default transaction isolation level to - Select the desired isolation level
  
• Automatically corret for daylight savings changes - Check to ensure that time data values are adjusted to counter the effects of daylight saving.
  
• Treat system tables as user tables -
  
• Treat views as user tables -

9. Click the Finish button.

Test the DSN

1. Launch the C++ Demo program that appears in Start->All Programs->OpenLink Virtuoso->Client Samples->ODBC.

2. Expand the Environment menu.

3. Select Open Connection.

4. Locate your DSN using the ODBC Data Sources Administrator.

5. Highlight your DSN.

6. Click OK.

7. Provide authentication, as needed.

8. Expand the SQL menu.

9. Select Execute SQL.

10. Type your SQL statement into the SQL statement text box.

11. Click OK.

12. Expand the Environment menu.

13. Select Close Connection.

14. Expand the File menu.

15. Select Exit.