I'm using VBScript to access SQL Server and the configuration is ok as it works when inserting new values and even when changing the columns names.
However, now I want to get the name of the columns and I'am able to get the first record, but not the second and the third.
The format of the SQL query results are output in a single column with three rows.
Here's the documentation but I cannot get anything clear:(.
My code:
$result(0) stores correctly the value while $result(1) and $result(2) are blank. I have tried several ways, as definining rst as:
No one worked. Can anyone help me? Thanks.