title: Connecting to Oracle 10g with ODBC from Excel VBA
body: <p>The following code works. the connection opens fine but recordset.recordCount always returns -1 when there is data in the table. ANd If I try to call any methods/properties on recordset it crashes Excel. Any ideas??
  Thanks</p>
  
  <pre><code>Sub GetData()
      Dim conn As New ADODB.connection    
      Dim connString
      connString = "DSN=name;Uid=user;Pwd=pass"
      Dim rsRecords As New ADODB.recordSet
  
      conn.Open connString
      rsRecords.CursorLocation = adUseServer
      rsRecords.Open "select * from xxx", conn, adOpenForwardOnly, adLockReadOnly
  
      If conn.State = adStateOpen Then
        MsgBox rsRecords.RecordCount
      Else
         MsgBox "no connection"
      End If
  
      rsRecords.Close
      Set rsRecords = Nothing
      conn.Close
      Set conn = Nothing
  End Sub
  </code></pre>