Page Comparison

...

3. Verify that ODBC recognizes the installed drivers using odbcListDrivers() command.

   Code Block
   library(odbc) sort(unique(odbcListDrivers()[[1]]))

   Here’s a screenshot for reference.

   Image Modified

4. Connect to Kyvos using the following command.

   Code Block
   library(odbc) con <- dbConnect(odbc::odbc(), driver = "Kyvos ODBC Driver", UserName = "username", PWD = "password", host = "192.168.8.190",  port=8081, HTTPPath = "kyvos/sql")

5. Verify the above connection with the command below.

   Code Block
   dbIsValid(con) #Returns TRUE if connection is established else return FALSE.

6. Run the queries using the following command.

   Code Block
   dbGetQuery(con,'Paste your SQL query here')

7. After executing the queries close the connection using the dbDisconnect(con). command.

8. Execute the dbIsValid(con) command to ensure that the connection is disconnected.