Thread View: borland.public.cppbuilder.database.multi-tier
8 messages
8 total messages
Started by mpowell
Thu, 24 May 2001 19:44
EOF Detected
Author: mpowell
Date: Thu, 24 May 2001 19:44
Date: Thu, 24 May 2001 19:44
9 lines
1177 bytes
1177 bytes
Hi, I am trying to interface with an Oracle database over our WAN and am getting the following error. I am suspecting that I am terminating the process earlier than expected. Is there something that should be done with my TQuery instance to verify this suspicion? EIBClientError with message 'SQL Parse Error: EOF in string detected'
Re: EOF Detected
Author: mpowell
Date: Thu, 24 May 2001 22:09
Date: Thu, 24 May 2001 22:09
23 lines
1502 bytes
1502 bytes
I feel this might be a configuration issue with the parameters that are passing upon connection with the database itself. Is there a complete listing of Oracle parameters somewhere that might help to shed some light on the error below? Thanks! "mpowell" <mike.powell@transcore.com> wrote in message news:3b0d65ad_2@dnews... > > Hi, > > I am trying to interface with an Oracle database over our WAN and am getting > the following error. I am suspecting that I am terminating the process > earlier than expected. Is there something that should be done with my TQuery > instance to verify this suspicion? > > EIBClientError with message 'SQL Parse Error: EOF in string detected' > > >
Re: EOF Detected
Author: mpowell
Date: Fri, 25 May 2001 17:32
Date: Fri, 25 May 2001 17:32
32 lines
1740 bytes
1740 bytes
Anybody? "mpowell" <mike.powell@transcore.com> wrote in message news:3b0d87c8$1_1@dnews... > > I feel this might be a configuration issue with the parameters that are > passing upon connection with the database itself. Is there a complete > listing of Oracle parameters somewhere that might help to shed some light on > the error below? Thanks! > > > "mpowell" <mike.powell@transcore.com> wrote in message > news:3b0d65ad_2@dnews... > > > > Hi, > > > > I am trying to interface with an Oracle database over our WAN and am > getting > > the following error. I am suspecting that I am terminating the process > > earlier than expected. Is there something that should be done with my > TQuery > > instance to verify this suspicion? > > > > EIBClientError with message 'SQL Parse Error: EOF in string detected' > > > > > > > >
Re: EOF Detected
Author: Jeff Overcash (TeamB)
Date: Fri, 25 May 2001 20:52
Date: Fri, 25 May 2001 20:52
22 lines
1685 bytes
1685 bytes
mpowell wrote:
>
> Hi,
>
> I am trying to interface with an Oracle database over our WAN and am getting
> the following error. I am suspecting that I am terminating the process
> earlier than expected. Is there something that should be done with my TQuery
> instance to verify this suspicion?
>
> EIBClientError with message 'SQL Parse Error: EOF in string detected'
I'm confused here. You say you are connecting to Oracle, but the EIBClientError
is an IBX exception and IBX only connects to InterBase.
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Anyone who cannot cope with mathematics is not fully human.
At best he is a tolerable subhuman who has learned to wear
shoes, bathe and not make messes in the house. (Heinlein)
Re: EOF Detected
Author: mpowell
Date: Fri, 25 May 2001 21:52
Date: Fri, 25 May 2001 21:52
34 lines
2002 bytes
2002 bytes
Yes, that's the error that occurs. It's got me stumped as well. I ran it just now to make sure I wasn't dreaming it (I wasn't). The error generally rears its ugly head on Next(). "Jeff Overcash (TeamB)" <overcash@onramp.net> wrote in message news:3B0EC61D.2D9C78C3@onramp.net... > > > mpowell wrote: > > > > Hi, > > > > I am trying to interface with an Oracle database over our WAN and am getting > > the following error. I am suspecting that I am terminating the process > > earlier than expected. Is there something that should be done with my TQuery > > instance to verify this suspicion? > > > > EIBClientError with message 'SQL Parse Error: EOF in string detected' > > > I'm confused here. You say you are connecting to Oracle, but the EIBClientError > is an IBX exception and IBX only connects to InterBase. > > -- > Jeff Overcash (TeamB) > (Please do not email me directly unless asked. Thank You) > Anyone who cannot cope with mathematics is not fully human. > At best he is a tolerable subhuman who has learned to wear > shoes, bathe and not make messes in the house. (Heinlein)
Re: EOF Detected
Author: Jeff Overcash (TeamB)
Date: Mon, 28 May 2001 15:43
Date: Mon, 28 May 2001 15:43
19 lines
1825 bytes
1825 bytes
I don't know what to tell you except to make certain the IBX isn't being loaded
in if you aren't using IBX. You might try running your app under MemProof to
see if you have done a memory overwrite somewhere that causes this strange side
effect.
mpowell wrote:
>
> Yes, that's the error that occurs. It's got me stumped as well. I ran it
> just now to make sure I wasn't dreaming it (I wasn't). The error generally
> rears its ugly head on Next().
>
--
Jeff Overcash (TeamB)
(Please do not email me directly unless asked. Thank You)
Anyone who cannot cope with mathematics is not fully human.
At best he is a tolerable subhuman who has learned to wear
shoes, bathe and not make messes in the house. (Heinlein)
Re: EOF Detected
Author: mpowell
Date: Tue, 29 May 2001 13:44
Date: Tue, 29 May 2001 13:44
35 lines
2199 bytes
2199 bytes
That is the other half of the equation yes (e.g. IBX). IOW, I am using traditional MIDAS data components in conjunction with IBX data components. I do not have any leeway here (at least not without a major re-write of SQL and other code). If there is an overwrite it is happening withing the TQuery::Next() method. I know because I stepped through, and this is where the error occurs. "Jeff Overcash (TeamB)" <overcash@onramp.net> wrote in message news:3B127232.64B6CF0A@onramp.net... > I don't know what to tell you except to make certain the IBX isn't being loaded > in if you aren't using IBX. You might try running your app under MemProof to > see if you have done a memory overwrite somewhere that causes this strange side > effect. > > mpowell wrote: > > > > Yes, that's the error that occurs. It's got me stumped as well. I ran it > > just now to make sure I wasn't dreaming it (I wasn't). The error generally > > rears its ugly head on Next(). > > > > > -- > Jeff Overcash (TeamB) > (Please do not email me directly unless asked. Thank You) > Anyone who cannot cope with mathematics is not fully human. > At best he is a tolerable subhuman who has learned to wear > shoes, bathe and not make messes in the house. (Heinlein)
Re: EOF Detected
Author: mpowell
Date: Tue, 29 May 2001 15:08
Date: Tue, 29 May 2001 15:08
32 lines
2076 bytes
2076 bytes
As I was stepping through in more detail... it turns out the data I am
selecting from the Oracle database has embedded tick marks ("\'") in them,
so to the subsequent TIBQuery this looks like an early termination of a
string (a la the exception).
"Jeff Overcash (TeamB)" <overcash@onramp.net> wrote in message
news:3B127232.64B6CF0A@onramp.net...
> I don't know what to tell you except to make certain the IBX isn't being
loaded
> in if you aren't using IBX. You might try running your app under MemProof
to
> see if you have done a memory overwrite somewhere that causes this strange
side
> effect.
>
> mpowell wrote:
> >
> > Yes, that's the error that occurs. It's got me stumped as well. I ran it
> > just now to make sure I wasn't dreaming it (I wasn't). The error
generally
> > rears its ugly head on Next().
> >
>
>
> --
> Jeff Overcash (TeamB)
> (Please do not email me directly unless asked. Thank You)
> Anyone who cannot cope with mathematics is not fully human.
> At best he is a tolerable subhuman who has learned to wear
> shoes, bathe and not make messes in the house. (Heinlein)
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