Having problem with OLE DB provider 'IBMDADB2'

From: Sudhir (Sudhir_at_discussions.microsoft.com)
Date: 09/28/04 

Date: Mon, 27 Sep 2004 20:31:02 -0700

Hi everyone,

I would really appreciate if anyone could tell me what is happening with
OLEDB provider.
I have a stored procedure which inserts data into IBM DB2 tables using a
linked server, the linked server uses OLE DB provider 'IBMDADB2'. I ran the
stored procedure a couple of days back and i was able to insert 250 records
in a batch. But today when I tried to insert 200 records in a batch, the
stored procedure was able to insert only 100 records and the Job failed with
the following reason

Executed as user: ENT\pacesql. OLE DB provider 'IBMDADB2' reported an error.
The provider ran out of memory. [SQLSTATE 42000] (Error 7399) OLE DB error
trace [OLE/DB Provider 'IBMDADB2' ICommandText::Execute returned 0x8007000e:
The provider ran out of memory.]. [SQLSTATE 01000] (Error 7300). The step
failed.

I then tried calling the stored procedure from Query Analyser but it gave me
the same error. After re-creating the linked the Job ran fine and was able to
insert the remaining record.

I was wondering if anyone here faced this problem or does anyone know why
this is occuring and if anyone could point me when to find a solution to this
problem i would really appreciate it.

Thanks in Advance.

Relevant Pages

  • Re: Stored Procedures & Parameters Insert Problem
    ... Why use the MSDataShape provider? ... This is so that I can easily change the stored procedure in the sample ... an AutoNumber primary key field, and lngTestCount. ... Dim adoDBConn As ADODB.Connection ...
    (microsoft.public.data.ado)
  • Re: DeriveParameters and Jet OLEDB Provider
    ... retrieves provider-side parameter information for the stored procedure or ... parameterized query specified in the Command object. ... In Jet a 'saved' query is not a stored procedure. ... > method with this provider to populate a Paramters collection. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Foxpro vs SQL Server
    ... "OLE DB Provider for Visual FoxPro". ... These apply to any Stored Procedure your write! ... While there is a newer one that comes with the VFP 9.0 public beta, ...
    (microsoft.public.fox.vfp.queries-sql)
  • RE: problem exectuing storded procedure
    ... I can execute the oracle stored procedure through linked server by using MSDASQL, but as this service is now depricated and cannot accessible in 64 bit, I am unable to use the same sp using OLE DB provider. ...
    (microsoft.public.sqlserver.server)
  • Re: Sybase ASE through DBD::ADO: Problem calling proc with param
    ... I am having trouble calling any stored procedure with a parameter through DBI ... "The provider cannot derive parameter info and SetParameterInfo has not been called" ... Sybase ASE OLE DB Provider 2.70.0.24 ...
    (perl.dbi.users)