vbs - select on sql view

[elly00]

Hi,
I have a code like that
....
Set ObjAdoDbConnection_5 = CreateObject("ADODB.Connection")
Set ObjAdoDbRecordset_5 = CreateObject("ADODB.recordset")

ObjAdoDbRecordSet_5.Source = "SELECT progressivo FROM View1 WHERE ESERCIZIO=2016"
..

This select doen't return any rows..
If I use a TABLE instead of VIEW1 all work correctly..
So my question is, is possibile to runa select on sql view?

thanks

 

[xwb]

Has the view been created?