Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

5024 error

3 posts in Networking Last posting was on 2003-10-16 18:23:19.0Z
John Posted on 2003-10-13 00:05:34.0Z
From: "John" <none@none.com>
Newsgroups: Advantage.Networking
Subject: 5024 error
Date: Sun, 12 Oct 2003 20:05:34 -0400
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 24.229.136.67
Message-ID: <3f89ed0c@solutions.advantagedatabase.com>
X-Trace: 12 Oct 2003 18:08:44 -0700, 24.229.136.67
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.229.136.67
Xref: solutions.advantagedatabase.com Advantage.Networking:428
Article PK: 1131859

Error 7200: AQE Error: State=Hy000; NativeError = 5024; [Extended
Systems][Advantage
SQL][ASA] Error 5024; Advantage does not have a connection open with the
specifie handle. Connection not to the same server. Table name: etc


I have been stumped on this for hours, I checked the advantage Dbase but I
only get a Crystal Reports Solution, this is a table issue. Could someone
please help me out. I am trying to connect the local server to the database
server located on a Win2K machine. I have also checked all of the
permissions and all is good???

I'd appreciate some help.
Thanks
- John


Lee Stigile Posted on 2003-10-15 15:08:46.0Z
From: "Lee Stigile" <Advantage@extendsys.com>
Newsgroups: Advantage.Networking
References: <3f89ed0c@solutions.advantagedatabase.com>
Subject: Re: 5024 error
Date: Wed, 15 Oct 2003 09:08:46 -0600
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 204.134.216.213
Message-ID: <3f8d62cc@solutions.advantagedatabase.com>
X-Trace: 15 Oct 2003 09:07:56 -0700, 204.134.216.213
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!204.134.216.213
Xref: solutions.advantagedatabase.com Advantage.Networking:429
Article PK: 1131858

What's your SQL statement? I usually see this error with remote server --
any chance that you're making a remote connection to your local machine and
then referencing a table on the server? Try forcing local server.
Regards,
Lee Stigile
Advantage Support

"John" <none@none.com> wrote in message
news:3f89ed0c@solutions.advantagedatabase.com...
> Error 7200: AQE Error: State=Hy000; NativeError = 5024; [Extended
> Systems][Advantage
> SQL][ASA] Error 5024; Advantage does not have a connection open with the
> specifie handle. Connection not to the same server. Table name: etc
>
>
> I have been stumped on this for hours, I checked the advantage Dbase but I
> only get a Crystal Reports Solution, this is a table issue. Could someone
> please help me out. I am trying to connect the local server to the
database
> server located on a Win2K machine. I have also checked all of the
> permissions and all is good???
>
> I'd appreciate some help.
> Thanks
> - John
>
>


John Posted on 2003-10-16 18:23:19.0Z
From: "John" <none@none.com>
Newsgroups: Advantage.Networking
References: <3f89ed0c@solutions.advantagedatabase.com> <3f8d62cc@solutions.advantagedatabase.com>
Subject: Re: 5024 error
Date: Thu, 16 Oct 2003 14:23:19 -0400
Lines: 45
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 24.229.193.3
Message-ID: <3f8ee2ce@solutions.advantagedatabase.com>
X-Trace: 16 Oct 2003 12:26:22 -0700, 24.229.193.3
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!24.229.193.3
Xref: solutions.advantagedatabase.com Advantage.Networking:430
Article PK: 1131860

Yes, thanks I figured it out a few days ago, the program was using a general
mapped path, a UNC path solved my problem.
\\Server-Name\Folder...etc.

Thanks
- John

"Lee Stigile" <Advantage@extendsys.com> wrote in message
news:3f8d62cc@solutions.advantagedatabase.com...
> What's your SQL statement? I usually see this error with remote server --
> any chance that you're making a remote connection to your local machine
and
> then referencing a table on the server? Try forcing local server.
> Regards,
> Lee Stigile
> Advantage Support
>
>
> "John" <none@none.com> wrote in message
> news:3f89ed0c@solutions.advantagedatabase.com...
> > Error 7200: AQE Error: State=Hy000; NativeError = 5024; [Extended
> > Systems][Advantage
> > SQL][ASA] Error 5024; Advantage does not have a connection open with the
> > specifie handle. Connection not to the same server. Table name: etc
> >
> >
> > I have been stumped on this for hours, I checked the advantage Dbase but
I
> > only get a Crystal Reports Solution, this is a table issue. Could
someone
> > please help me out. I am trying to connect the local server to the
> database
> > server located on a Win2K machine. I have also checked all of the
> > permissions and all is good???
> >
> > I'd appreciate some help.
> > Thanks
> > - John
> >
> >
>
>