Setting Parameter Values Using TADOStoredProc Generates AV Error.

Thread View: borland.public.cppbuilder.database.ado

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Alan Lichtenstein Thu, 29 Mar 2001 18:37

#5567

Author: Alan Lichtenstein
Date: Thu, 29 Mar 2001 18:37

34 lines
2016 bytes

Can anyone tell me why the code below works fine on Windows 98 however
generates an 'Access Violation' error when you try to set the parameter
values running on Windows NT Workstation. Using either 'Value' or
'ParamByName' generates the same AV error:

   m_pStp->Close();

   m_pStp->Parameters->CreateParameter("paramClient", ftString, pdInput,
                                          20, NULL );

   m_pStp->Parameters->CreateParameter("paramPoolno", ftString, pdInput,
                                          20, NULL );

   m_pStp->Parameters->CreateParameter("paramTaxid", ftString, pdInput,
                                          20, NULL );

   m_pStp->Parameters->Items[0]->Value =
       m_pTbl->FieldByName("Client")->AsString;

   m_pStp->Parameters->Items[1]->Value =
       m_pTbl->FieldByName("PoolNo")->AsString;

   m_pStp->Parameters->Items[2]->Value =
       m_pTbl->FieldByName("Taxid")->AsString;


This fails too:

    m_pStp->Parameters->Items[0]->Value = "1234";
    m_pStp->Parameters->Items[1]->Value = "1994ABCD";
    m_pStp->Parameters->Items[2]->Value = "123456789";


Thanx in advance for your help.........

Re: Setting Parameter Values Using TADOStoredProc Generates AV Error.

#5594

Author: J. R. Antley
Date: Mon, 02 Apr 2001 08:18

9 lines
1086 bytes

This is just a crude guess:  What versions of MDAC are you running on the
two machines?

HTH,
JR

"Alan Lichtenstein" <alanl@sss.sungard.com> wrote in message
news:3ac380ff$1_2@dnews...
<snip>

Re: Setting Parameter Values Using TADOStoredProc Generates AV Error.

#5601

Author: Alan Lichtenstein
Date: Tue, 03 Apr 2001 22:04

17 lines
1283 bytes

I believe MDAC 2.5 is installed on both machines� but I'm not sure.  Do you
know how I can determine which versions are actually installed?�.

Thanx�.

J. R. Antley wrote in message <3ac83ff9$1_1@dnews>...
>This is just a crude guess:  What versions of MDAC are you running on the
>two machines?
>
>HTH,
>JR
>
>"Alan Lichtenstein" <alanl@sss.sungard.com> wrote in message
>news:3ac380ff$1_2@dnews...
><snip>
>
>

Re: Setting Parameter Values Using TADOStoredProc Generates AV Error.

#5523

Author: Alan Lichtenstein
Date: Thu, 05 Apr 2001 14:28

26 lines
1526 bytes

Yup,

I checked, and it appears that MDAC 2.5 is installed on both machines.....
Any ideas....?


Alan Lichtenstein wrote in message <3aca48e5_2@dnews>...
>I believe MDAC 2.5 is installed on both machines� but I'm not sure.  Do you
>know how I can determine which versions are actually installed?�.
>
>Thanx�.
>
>J. R. Antley wrote in message <3ac83ff9$1_1@dnews>...
>>This is just a crude guess:  What versions of MDAC are you running on the
>>two machines?
>>
>>HTH,
>>JR
>>
>>"Alan Lichtenstein" <alanl@sss.sungard.com> wrote in message
>>news:3ac380ff$1_2@dnews...
>><snip>
>>
>>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads