Working with MSSQL Views... ?

[xluryan]

I run a query on a regular MSSQL table and it returns a RecordSet just fine. However, when I try to query a "view", I only ever get an empty RecordSet. Any help?

Dim DB : Set DB = CreateObject("ADODB.Connection")
Dim RS : Set RS = CreateObject("ADODB.RecordSet")
Dim sQuery

DB.Open CONNECTION_STRING
sQuery = "SELECT * FROM SampleView"
RS.Open sQuery, DB, 3, 3, 1

RS.RecordCount always == -1.

 

[tsuji]

>RS.RecordCount always == -1.
Cannot confirm this if the SampleView has been created and is existing. It would response as if it is a table.