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
Printable View
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