VBscript/ADO/add record problem
- From: "j2222" <j2222@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 17 Jun 2005 04:39:01 -0700
Same program, 2 servers, works on one (well, dozens), crashes on the other at
ADDNew statement, same MDAC, both can connect and test connection on ODBC CP
applet ... works on NT4, 200 etc. SQLTrace shows initial connection ok from
SELECT statement, just addnew fails - Any ideas? DBServer is an IP address.
Set objConn = CreateObject("ADODB.Connection")
set dictEventCodes = CreateObject("Scripting.Dictionary")
Set objRS = CreateObject("ADODB.Recordset")
Set WshNetwork = WScript.CreateObject("WScript.Network")
set objFSO = CreateObject("Scripting.FileSystemObject")
objConn.Open "Driver={SQL Server};Server=" & DBServer &
";Uid=xxxx;Pwd=xxxx;Database=ServerMonitoring;Address=" & DBServer &
",1433;Network=DBMSSOCN"
objRS.CursorLocation = 3
objRS.Open "SELECT top 1 * FROM Events" , objConn, 3, 3
wscript.echo " Adding Heatbeak record"
objRS.AddNew
objRS("EventDateTime") = year(now()) & "/" & month(now()) & "/" &
day(now()) & " " & hour(now()) & ":" & minute(now()) & ":" & second(now())
objRS("ServerName") = WshNetwork.ComputerName
objRS("EventLog") = "-"
objRS("EventID") = "0"
objRS("EventUser") = "-"
objRS("EventSource") = "HBEAT"
objRS("EventType") = "HBEAT"
objRS("EventCategory") = "HBEAT"
objRS("EventDetails") = "Heartbeat record"
objRS.Update
.
- Prev by Date: Re: Data Shaping in VB6
- Next by Date: Re: msi's configuration
- Previous by thread: restaurer base de données sous windows XP
- Next by thread: Problem: duplicate rows on OracleDataAdapter.fill, PKs are defined
- Index(es):