OLE/DB Provider 'OpenXML' IRowset::RestartPosition returned 0x80004005

From: swamgan (anonymous_at_discussions.microsoft.com)
Date: 02/23/04 

Date: Mon, 23 Feb 2004 10:06:08 -0800

Hi,
     I am using OpenXML to pass selections from ASP webpage to Stored proc on SQL Server 2000. I got the following
error

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB error trace [OLE/DB Provider 'OpenXML' IRowset::RestartPosition returned 0x80004005: The provider did not give any information about the error.].
/summary/Generic_sum_pt.asp, line 187

Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322)

Page:
POST 395 bytes to /summary/Generic_sum_pt.asp

POST Data:
sdate=02%2F19%2F2004+4%3A35AM&edate=02%2F20%2F2004+3%3A45+AM&problemtype=Accident&problemtype=Emergency&problemtype=Farebox&problemtype=Incident&problemtype=Mechanical&problemtype=Other&problemtype=Se . . .

The line 187 on the ASP page calls the stored proc with the SQL query containing XML parsed data.

Any suggestions/ideas how to get around this?

Your help is greatly appreciated.

Thanks,
swamgan.

Relevant Pages

  • handling errors from stored procs
    ... SQL Server 2000 ... comprise the call to a stored proc ... the stored proc gets run...if so, it would be nice if the Access app ... - when stored proc encounters error, it returns that error message ...
    (comp.databases.ms-access)
  • Re: Retrieve error text from extended stored proc
    ... was only on first execution, the following executions, error number was 0. ... However, use OSQL with the -m-1 switch, and you will see that the RAISERROR ... Tibor Karaszi, SQL Server MVP ... > When I call the stored proc from Query Analyzer and force an error, ...
    (microsoft.public.sqlserver.programming)
  • Re: best way to retrieve thousands of records.
    ... I understand you should have a chunky not chatty interface, ... i.e code up another stored proc that accepts ... > retrieve records from sql server. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: best way to retrieve thousands of records.
    ... I understand you should have a chunky not chatty interface, ... i.e code up another stored proc that accepts ... > retrieve records from sql server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: dlookup with stored procs
    ... The lookup criteria is unique based on the primary key value but i'm missing ... Tried amending the Dlookup but as the error message tells me a stored proc ... In a SQL stored procedure you can use a join instead of the DLOOKUP ... David Portas, SQL Server MVP ...
    (microsoft.public.access.adp.sqlserver)
Loading