| View previous topic :: View next topic |
| Author |
Message |
Borland
Guest
|
 Posted: Tue Dec 23, 2003 12:33 am Post subject: Works in ADO, not BDE |
 |
|
I have a stored procedure on a SQL based DBMS called Cache (by
Intersystems). Don't ask.
Anyway, I wrote s simple stored procedure with an input/output parameter.
Running it via the BDE the value of the parameter does not change. Running
it via ADO the parameter changes exactly as expected.
Any tips on where to look to try to resolve this? Is it possible to resolve
this?
|
|
| Back to top |
|
 |
Bill Todd (TeamB)
Guest
|
| Posted: Tue Dec 23, 2003 1:18 am Post subject: Re: Works in ADO, not BDE |
|
|
I assume you are using an ODBC driver with the BDE. Is that correct?
Did you try the same ODBC driver with ADO? If not, you should. That
will tell you if the problem is related to the driver or not.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Bill Todd (TeamB)
Guest
|
| Posted: Tue Dec 23, 2003 1:19 am Post subject: Re: Works in ADO, not BDE |
|
|
Also, please change the name in your messages to something other than
Borland. Someone might assume you are a Borland employee.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Jim Carr
Guest
|
| Posted: Wed Dec 24, 2003 7:23 pm Post subject: Re: Works in ADO, not BDE |
|
|
Sorry about the name on the account. New computer, new OE setup, careless
me.
I used ADO with the same ODBC driver. With a result parameter, the IDE
breaks into the CPU window. If I set Active to True on the TStoredProc
component in the IDE (dumb and useless, I know), Delphi 7 just disappears.
Gone. Bye Bye. No error message. ADO runs like a charm.
|
|
| Back to top |
|
|
Bill Todd (TeamB)
Guest
|
| Posted: Wed Dec 24, 2003 7:54 pm Post subject: Re: Works in ADO, not BDE |
|
|
At least you know where the problem is not. :)
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
Jim Carr
Guest
|
| Posted: Wed Dec 24, 2003 10:14 pm Post subject: Re: Works in ADO, not BDE |
|
|
| Quote: | At least you know where the problem is not. 
|
Lemons: BDE crashes
Lemonade: Get to lead the push into moving past the BDE.
Long Island Iced Tea: What I feel like drinking when I think about the effor
involved!
|
|
| Back to top |
|
|
Bill Todd (TeamB)
Guest
|
| Posted: Wed Dec 24, 2003 11:55 pm Post subject: Re: Works in ADO, not BDE |
|
|
On Wed, 24 Dec 2003 15:14:01 -0700, "Jim Carr" <jim (AT) azwebpages (DOT) com>
wrote:
| Quote: | At least you know where the problem is not. :)
Lemons: BDE crashes
|
Since the problem seems to be the ODBC driver the only other
alternative is to try to find another ODBC driver that works.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
