title: First argument is not an open RODBC channel
body: <p>I am connecting to an Oracle database via DNS (set up the connection on the tnsnames.ora with the name "database"). </p>
  
  <p>I am able to succesfully run the following code:</p>
  
  <pre><code>con &lt;- DBI::dbConnect(odbc::odbc(), 
                    "database",
                    UID = "user",
                    PWD = "password",
                    trusted_connection = TRUE)
  </code></pre>
  
  <p>I am also able to succesfully list all the tables in the database via:</p>
  
  <pre><code>list &lt;- dbListTables(con)
  View(list)
  </code></pre>
  
  <p>However, when I run:</p>
  
  <pre><code>results &lt;- sqlQuery(channel = con, query = "select * from myschemaname.table")
  </code></pre>
  
  <p>I get the error: </p>
  
  <pre><code>Error in sqlQuery(channel = con, query = "select * from myschemaname.table") : 
            first argument is not an open RODBC channel
  </code></pre>
  
  <p>I have owner privileges and I am also able to update Excel Spreadsheets connected to this database via ODBC. 
  If it's of any use, here's the output of str(con)</p>
  
  <pre><code>str(con)
  Formal class 'Oracle' [package ".GlobalEnv"] with 4 slots
    ..@ ptr     :&lt;externalptr&gt; 
    ..@ quote   : chr "\""
    ..@ info    :List of 13
    .. ..$ dbname               : chr ""
    .. ..$ dbms.name            : chr "Oracle"
    .. ..$ db.version           : chr "11.02.0040"
    .. ..$ username             : chr "user"
    .. ..$ host                 : chr ""
    .. ..$ port                 : chr ""
    .. ..$ sourcename           : chr "database"
    .. ..$ servername           : chr "database"
    .. ..$ drivername           : chr "SQORA32.DLL"
    .. ..$ odbc.version         : chr "03.80.0000"
    .. ..$ driver.version       : chr "11.02.0001"
    .. ..$ odbcdriver.version   : chr "03.52"
    .. ..$ supports.transactions: logi TRUE
    .. ..- attr(*, "class")= chr [1:3] "Oracle" "driver_info" "list"
    ..@ encoding: chr ""
  </code></pre>