vbscript and sql table view

You can use the CreateObject procedure to create an ADODB object and then use that like you would in standard VB.

set adoCon = CreateObject("ADODB.Connection")
adoCon.Open(connectionstring)

set adoRs = adoCon.Execute(sqlstatement)

while not adoRs.Eof()
..
adoRs.MoveNext
wend

Greg Conely

I appreciate your comments. I was able to find some links that help me last night, and thought I would post the code.

Const adOpenStatic = 3
Const adLockOptimistic = 3
Const adUseClient = 3
strUserName = "testuser"
strPassword = "password"

Dim x
Dim objConnection, objRecordset
Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")

objConnection.Open "DSN=test;", strUserName, strPassword
objRecordset.CursorLocation = adUseClient
objRecordset.Open "SELECT * FROM zz_table_view" , objConnection, adOpenStatic, adLockOptimistic

objRecordSet.MoveFirst

Do Until objRecordset.EOF
x = objRecordset.Fields("export")
fac.WriteLine x
objRecordset.MoveNext
Loop

objRecordset.Close
objConnection.Close