B
Bob
I have a stored procedure that is giving me fits. It takes 4 parameters and
retuns a result set of 3 columns. It works fine in Query Analyzer. The event
log indicates a problem with a trusted server connection, but the DB and MSPS
are on the same server - and I have gone through many queries to get to this
point.
---------------------------------
Here is the code to invoke the sp:
var arrParams = new Array();
var dtBegin = new Date(Request.Form("dtRangeBegin"));
var dtEnd = new Date(Request.Form("dtRangeEnd"));
var rstUpdates;
arrParams[0] = "DeptCode";
arrParams[1] = "PF280";
arrParams[2] = "01-Jan-2005 00:00:00";
arrParams[3] = "30-Jun-2005 00:00:00";
oPJQuery.Connect();
rstUpdates = oPJQuery.OpenRecordset(CONST_TE_UPDATE_COUNTS, arrParams);
The parameters are supposed to come from the Request object, but I have hard
coded them to speed testing - this date format has worked on other queries.
----------------------------------------
Here is the code to call the sp:
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/mqi/Library/PJQuery.asp, line 597
The line in question is assigning the ADO query object to "this".
-------------------------------------------------
It puts three messages in the Event Log:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 6/14/2005
Time: 4:10:41 PM
User: NT AUTHORITY\SYSTEM
Computer: IN1RTF3
Description:
File: C:\Proj10\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: Assert Detected. The error code was also included.
___________________________________
Component: Microsoft OLE DB Provider for SQL Server
Description: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 6/14/2005
Time: 4:10:41 PM
User: NT AUTHORITY\SYSTEM
Computer: IN1RTF3
Description:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 142
Error Number: 0x80004005
Description: Assert Detected. The error code was also included.
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 6/14/2005
Time: 4:10:41 PM
User: NT AUTHORITY\SYSTEM
Computer: IN1RTF3
Description:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 419
Error Number: 0x80004005
Description: Assert Detected. The error code was also included.
Thanks for your help
retuns a result set of 3 columns. It works fine in Query Analyzer. The event
log indicates a problem with a trusted server connection, but the DB and MSPS
are on the same server - and I have gone through many queries to get to this
point.
---------------------------------
Here is the code to invoke the sp:
var arrParams = new Array();
var dtBegin = new Date(Request.Form("dtRangeBegin"));
var dtEnd = new Date(Request.Form("dtRangeEnd"));
var rstUpdates;
arrParams[0] = "DeptCode";
arrParams[1] = "PF280";
arrParams[2] = "01-Jan-2005 00:00:00";
arrParams[3] = "30-Jun-2005 00:00:00";
oPJQuery.Connect();
rstUpdates = oPJQuery.OpenRecordset(CONST_TE_UPDATE_COUNTS, arrParams);
The parameters are supposed to come from the Request object, but I have hard
coded them to speed testing - this date format has worked on other queries.
----------------------------------------
Here is the code to call the sp:
ADODB.Recordset error '800a0e78'
Operation is not allowed when the object is closed.
/mqi/Library/PJQuery.asp, line 597
The line in question is assigning the ADO query object to "this".
-------------------------------------------------
It puts three messages in the Event Log:
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 6/14/2005
Time: 4:10:41 PM
User: NT AUTHORITY\SYSTEM
Computer: IN1RTF3
Description:
File: C:\Proj10\WebClient\source\utility\pjadorsutil2.cpp
Line: 1691
Error Number: 0x80004005
Description: Assert Detected. The error code was also included.
___________________________________
Component: Microsoft OLE DB Provider for SQL Server
Description: Login failed for user '(null)'. Reason: Not associated with a
trusted SQL Server connection.
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 6/14/2005
Time: 4:10:41 PM
User: NT AUTHORITY\SYSTEM
Computer: IN1RTF3
Description:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\CnxCookie.cpp
Line: 142
Error Number: 0x80004005
Description: Assert Detected. The error code was also included.
Event Type: Error
Event Source: Microsoft Project Server Tracing Eventlog Provider
Event Category: None
Event ID: 2
Date: 6/14/2005
Time: 4:10:41 PM
User: NT AUTHORITY\SYSTEM
Computer: IN1RTF3
Description:
Component: PjQuery
File: C:\Proj10\WebClient\source\server\pjquery\PjGenericQuery.cpp
Line: 419
Error Number: 0x80004005
Description: Assert Detected. The error code was also included.
Thanks for your help