ado recordset getstring method not working

• Kevin Herring

  SSC Journeyman

  Points: 86

  More actions

  December 6, 2004 at 7:38 am

  #60455

  Hi

  I am using ado (v2.6) recordsets in a DTS package in VbScript.  I have used recordsets loads of times before in VBA but I am new to them in vbscript.

   

  I have a function like this:

  Public Function exportRSToCSV(rs, strFilename)

  Dim fso

  Dim txtFile

  dim k

      Set fso = CreateObject("Scripting.FileSystemObject")

      Set txtFile = fso.CreateTextFile(strFilename, True)

      txtFile.Write (rs.GetString())

     

  End Function

  However when I run it I get the following error:

  Object doesnt support this property or method

  on the GetString line

  I have tried putting various variables in, e.g. the row and column delimiters, but nothing works.

  anyone any ideas why?

• Kevin Herring

  SSC Journeyman

  Points: 86

  More actions

  December 6, 2004 at 8:31 am

  #532678

  oops, figured it out.  in the code previous to this one I missed out a 'set' when I assigned the recordset to the variable.  so it didnt know it was a recordset.