I have a .Net dll which provides me exposed function RunSqlQuery(). This function returns System.Data.Dataset. I am calling this function from VBScript.
If I use the C# syntax of dataset in VBScript, I get error "Object required"
How can I get the data from the dataset in VBScript?
.NET Dll function signature:
public DataSet RunSqlQuery(string query); My VBScript code:
On Error Resume Next Dim objSQLDB Dim dataset Dim retVal set objSQLDB = CreateObject("SQLManagement.SQLServer") retVal = objSQLDB.Connect("server-address", "username", "password") If retVal = 0 Then WScript.echo "Failed to connect: " & Err.Number & " " & Err.Description WScript.Quit End If 'Any of the below two lines does not help resolving Object required error dataset = objSQLDB.RunSqlQuery("Select 1") 'set dataset = objSQLDB.RunSqlQuery("Select 1") If Err.Number <> 0 Then WScript.echo "Error running query: " & Err.Number & " " & Err.Description WScript.Quit End If ' Stuck here : how to extract data from the dataset ' Below two lines does not work ' Error message: Microsoft VBScript runtime error: Object required WScript.echo dataset.Tables.Count WScript.echo dataset.Tables[0].Rows.Count objSQLDB.Disconnect objSQLDB = Nothing
Stuck here:with no actual attempt isn't very helpful. Have you actual tried to call some methods or properties of theDataSetobject? Did you encounter an error when you tried? Can you show your attempts?