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.

Error while checking system table

4 posts in Xbase++ Last posting was on 2010-01-29 19:30:18.0Z
Toma? Grom Posted on 2010-01-28 16:28:23.0Z
From: "Toma? Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
Subject: Error while checking system table
Date: Thu, 28 Jan 2010 17:28:23 +0100
Lines: 34
Organization: Goldenbit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 93.103.62.80
Message-ID: <4b61bb1f@solutions.advantagedatabase.com>
X-Trace: 28 Jan 2010 09:28:15 -0700, 93.103.62.80
Path: solutions.advantagedatabase.com!93.103.62.80
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1098
Article PK: 1140932

Hello,
I am running my xBase++ app on Windows 2008 server.
I am using ADS 9.1, appropriate ODBC driver and SQLExpress .
Data table format is .CDX and database uses data dictionary.
Everything works well, although one of the indexes exceeds 300 MB.

But when I am trying to perform SQL statement :

SELECT PARENT, NAME, FIELD_TYPE, FIELD_LENGTH, FIELD_DECIMAL FROM
system.COLUMNS ORDER BY PARENT, NAME, FIELD_TYPE, FIELD_LENGTH,
FIELD_DECIMAL

I get an error, like:

Procedure : SQLSTATEMENT:__ALLOCHANDLE
Line Number : 199
Information : Error BASE/5
Description : Internal data structures corrupted
Operation : dllExecuteCall

But I can perform the same SQL command within ARC utility on the same
computer and same database.
Also all other routines work well with SQLExpress, except that one.

With ADS 8.1 installed on another computer (Windows server 2003) for example
also that problematic SQL statement works without any problem.

Any idea, why ?


Best regards
Toma?


Edgar Sherman Posted on 2010-01-28 20:37:37.0Z
Date: Thu, 28 Jan 2010 13:37:37 -0700
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
Newsgroups: Advantage.Xbase++
Subject: Re: Error while checking system table
References: <4b61bb1f@solutions.advantagedatabase.com>
In-Reply-To: <4b61bb1f@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <4b61f51a@solutions.advantagedatabase.com>
X-Trace: 28 Jan 2010 13:35:38 -0700, 10.24.34.164
Lines: 41
Path: solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1099
Article PK: 1140933

Not sure if I am going in the right direction on this, but did you
update the DLL files (ACE32.dll) to 9.1 when you connect to this server?
If so, can you try it with the 8.x ACE32.dll?

Edgar

On 1/28/2010 9:28 AM, Toma? Grom wrote:
> Hello,
> I am running my xBase++ app on Windows 2008 server.
> I am using ADS 9.1, appropriate ODBC driver and SQLExpress .
> Data table format is .CDX and database uses data dictionary.
> Everything works well, although one of the indexes exceeds 300 MB.
>
> But when I am trying to perform SQL statement :
>
> SELECT PARENT, NAME, FIELD_TYPE, FIELD_LENGTH, FIELD_DECIMAL FROM
> system.COLUMNS ORDER BY PARENT, NAME, FIELD_TYPE, FIELD_LENGTH,
> FIELD_DECIMAL
>
> I get an error, like:
>
> Procedure : SQLSTATEMENT:__ALLOCHANDLE
> Line Number : 199
> Information : Error BASE/5
> Description : Internal data structures corrupted
> Operation : dllExecuteCall
>
> But I can perform the same SQL command within ARC utility on the same
> computer and same database.
> Also all other routines work well with SQLExpress, except that one.
>
> With ADS 8.1 installed on another computer (Windows server 2003) for example
> also that problematic SQL statement works without any problem.
>
> Any idea, why ?
>
>
> Best regards
> Toma?
>
>


Tomaz Grom Posted on 2010-01-29 07:40:40.0Z
From: "Tomaz Grom" <tomaz.grom@siol.net>
Newsgroups: Advantage.Xbase++
References: <4b61bb1f@solutions.advantagedatabase.com> <4b61f51a@solutions.advantagedatabase.com>
Subject: Re: Error while checking system table
Date: Fri, 29 Jan 2010 08:40:40 +0100
Lines: 11
Organization: Goldenbit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: 93.103.62.80
Message-ID: <4b6290cf@solutions.advantagedatabase.com>
X-Trace: 29 Jan 2010 00:39:59 -0700, 93.103.62.80
Path: solutions.advantagedatabase.com!93.103.62.80
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1100
Article PK: 1140934

Thank you, Edgar.
I did not think, that is possible.
On the SQLExpress forum Boris suggested me to downgrade the ODBC to 8.x.

Is that commom procedure in such cases ? I mean, is that allways compatible
for other tasks of the server ?

Best regards
Tomaz


Edgar Sherman Posted on 2010-01-29 19:30:18.0Z
Date: Fri, 29 Jan 2010 12:30:18 -0700
From: Edgar Sherman <no@email.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-US; rv:1.9.1.7) Gecko/20100111 Thunderbird/3.0.1
MIME-Version: 1.0
Newsgroups: Advantage.Xbase++
Subject: Re: Error while checking system table
References: <4b61bb1f@solutions.advantagedatabase.com> <4b61f51a@solutions.advantagedatabase.com> <4b6290cf@solutions.advantagedatabase.com>
In-Reply-To: <4b6290cf@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 10.24.34.164
Message-ID: <4b6336d3@solutions.advantagedatabase.com>
X-Trace: 29 Jan 2010 12:28:19 -0700, 10.24.34.164
Lines: 30
Path: solutions.advantagedatabase.com!10.24.34.164
Xref: solutions.advantagedatabase.com Advantage.Xbase++:1101
Article PK: 1140935

It is because a new fieldtype was introduced in 9.x. The server decides
if the new type should be sent to the client based on the client version
(ACE32.dll). Since your ACE32.dll is 9.x it gets the new fieldtype, but
I suspect that xBase was not updated to know about this new field type yet.

-----------------
Pre 9.0 version of the Advantage TDataSet Descendant, OLE DB Provider,
and ODBC driver may not function properly with a 9.0 or newer version of
the Advantage Client Engine (ACE) DLL. The SQL engine may return a
VarCharFox field type in static cursors when certain string scalars are
used in the SELECT list. The older clients will not recognize this data
type. For the TDataset Descendant, if it is desirable to use a newer
version of the ACE DLL, you will need to re-compile the application
using a 9.0 or newer version of the TDataset Descendant. For OLE DB or
ODBC based applications, a 9.0 or newer version of the driver must be used.

---------------

On 1/29/2010 12:40 AM, Tomaz Grom wrote:
> Thank you, Edgar.
> I did not think, that is possible.
> On the SQLExpress forum Boris suggested me to downgrade the ODBC to 8.x.
>
> Is that commom procedure in such cases ? I mean, is that allways compatible
> for other tasks of the server ?
>
> Best regards
> Tomaz
>
>