ADO Trouble with MSSQL/Iconics Database

[dklemm]

Hello All,

I am facing Trouble with Connection a MSSQL Database, which is linked To an Iconics Data SW, via a VBS to Read out the data. Ihave attached my beginner VBS and the EOF,BOF Fault it creates.

Does it mean I am not connect or no Database, or whatever.

I am a beginner in this matter, and help would be welcome !!!

Thanks

Dieter

[AndreasK]

I am not sure about the error but in my code I never call GetRows with default parameters.

e.g.

dim getResult : set getResult = conn.Execute(sqlGetStatement)
dim rowVals : rowVals = getResult.GetRows(-1, 0, 0)
            
dim valueIndex : valueIndex = 1
dim value : For Each value In rowVals
  channel.Values(valueIndex) = value
  valueIndex = valueIndex + 1
Next

Maybe that helps.