Database Interaction with vbscript

Hi all,

Can I interact with a SQL Server database using vbscript as I would using VB6 ? Does this require client side and server side processing??

any examples would be appreciated,

Cheers

Colin

Try this, this works for me

Sub LogOff(sID)

On error resume next
Dim dBase
Set dBase=CreateObject("ADODB.Connection")
sConn="PROVIDER=SQLOLEDB;Data Source=SERVER_1;Initial Catalog=MainData;uid=TestUser;pwd="
dBase.CursorLocation="3"
dBase.ConnectionTimeout=30
dBase.Open sConn
sSQL="DELETE FROM vwLoggedOn WHERE LogInitials='" & sID & "'"
dBase.execute(sSQL)
dBase.close
Set dBase=nothing

End sub

cheers parkes,

thats what I was looking for

Colin