Database Interaction with vbscript

[colin]

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

[parkes]

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

[colin]

cheers parkes,

thats what I was looking for

Colin