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.

Linked Server -> Error 7010: Problem with Advantage server file read.

3 posts in OLEDB Last posting was on 2010-12-20 22:43:35.0Z
Matthias Vandercleyen Posted on 2010-12-13 18:53:49.0Z
Date: Mon, 13 Dec 2010 19:53:49 +0100
From: Matthias Vandercleyen <matthias.vandercleyen@syscom.be>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; nl; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: Advantage.OLEDB
Subject: Linked Server -> Error 7010: Problem with Advantage server file read.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.240.253.132
Message-ID: <4d066adc@solutions.advantagedatabase.com>
X-Trace: 13 Dec 2010 11:50:04 -0700, 81.240.253.132
Lines: 29
Path: solutions.advantagedatabase.com!81.240.253.132
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1355
Article PK: 1133873

Hello,

I'm trying to link an ADS 10.10 server to an MSSQL 2008 server.

I can browse the tables in MSSQL but having problems with executing SQL.
I have table called GFAC with 44934 rows in it. Offcourse doing a
SELECT * FROM GFAC in dataarchitect works without a problem.

When i try to do the same in MSSQL, I get this error:

OLE DB provider "Advantage OLE DB Provider" for linked server "ADSBASE"
returned message "Error 7010: Problem with Advantage server file read.
AdsGetDataLength".
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "Advantage OLE DB Provider" for
linked server "ADSBASE".

The SQL instruction used:

SELECT * FROM OPENQUERY(ADSBASE, 'SELECT * FROM GFAC')

When i limit the amount off records by adding a WHERE, I don't get this
error. All the records are returned without a problem.

Any idea?

Thanks,

Matthias


Matthias Vandercleyen Posted on 2010-12-20 09:24:30.0Z
Date: Mon, 20 Dec 2010 10:24:30 +0100
From: Matthias Vandercleyen <matthias.vandercleyen@syscom.be>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; nl; rv:1.9.2.12) Gecko/20101027 Thunderbird/3.1.6
MIME-Version: 1.0
Newsgroups: Advantage.OLEDB
Subject: Re: Linked Server -> Error 7010: Problem with Advantage server fileread.
References: <4d066adc@solutions.advantagedatabase.com>
In-Reply-To: <4d066adc@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 81.240.253.132
Message-ID: <4d0f20be$1@solutions.advantagedatabase.com>
X-Trace: 20 Dec 2010 01:24:14 -0800, 81.240.253.132
Lines: 35
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1356
Article PK: 1133875

Anybody?

Op 13/12/2010 19:53, Matthias Vandercleyen schreef:

> Hello,
>
> I'm trying to link an ADS 10.10 server to an MSSQL 2008 server.
>
> I can browse the tables in MSSQL but having problems with executing SQL.
> I have table called GFAC with 44934 rows in it. Offcourse doing a SELECT
> * FROM GFAC in dataarchitect works without a problem.
>
> When i try to do the same in MSSQL, I get this error:
>
> OLE DB provider "Advantage OLE DB Provider" for linked server "ADSBASE"
> returned message "Error 7010: Problem with Advantage server file read.
> AdsGetDataLength".
> Msg 7330, Level 16, State 2, Line 1
> Cannot fetch a row from OLE DB provider "Advantage OLE DB Provider" for
> linked server "ADSBASE".
>
> The SQL instruction used:
>
> SELECT * FROM OPENQUERY(ADSBASE, 'SELECT * FROM GFAC')
>
> When i limit the amount off records by adding a WHERE, I don't get this
> error. All the records are returned without a problem.
>
> Any idea?
>
> Thanks,
>
> Matthias


Mark Wilkins Posted on 2010-12-20 22:43:35.0Z
From: "Mark Wilkins" <a@b.c>
Newsgroups: Advantage.OLEDB
References: <4d066adc@solutions.advantagedatabase.com>
In-Reply-To: <4d066adc@solutions.advantagedatabase.com>
Subject: Re: Linked Server -> Error 7010: Problem with Advantage server file read.
Date: Mon, 20 Dec 2010 15:43:35 -0700
Lines: 1
Organization: Sybase
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 14.0.8089.726
X-MimeOLE: Produced By Microsoft MimeOLE V14.0.8089.726
NNTP-Posting-Host: 10.6.199.122
Message-ID: <4d0fdc06@solutions.advantagedatabase.com>
X-Trace: 20 Dec 2010 14:43:18 -0800, 10.6.199.122
Path: solutions.advantagedatabase.com
Xref: solutions.advantagedatabase.com Advantage.OLEDB:1357
Article PK: 1133876

The 7010 error should have an entry in the server error log (ads_err.*). It
should narrow down the specific file that is involved. If I had to guess at
the problem, it would be that there is a memo file associated with that
table and that there is an invalid (corrupt) entry in the table for at least
one of the values. The table has the size and offset information for the
memo data. If it was somehow corrupted, it can result in that error.

Running the query in ARC would not necessarily cause all that data to be
read. Running it from SQL Server may cause the entire data set to be read.
If you include a WHERE clause, it may be avoiding the record that is causing
the problem.

Mark Wilkins
Advantage R&D

"Matthias Vandercleyen" <matthias.vandercleyen@syscom.be> wrote in message
news:4d066adc@solutions.advantagedatabase.com...
> Hello,
>
> I'm trying to link an ADS 10.10 server to an MSSQL 2008 server.
>
> I can browse the tables in MSSQL but having problems with executing SQL. I
> have table called GFAC with 44934 rows in it. Offcourse doing a SELECT *
> FROM GFAC in dataarchitect works without a problem.
>
> When i try to do the same in MSSQL, I get this error:
>
> OLE DB provider "Advantage OLE DB Provider" for linked server "ADSBASE"
> returned message "Error 7010: Problem with Advantage server file read.
> AdsGetDataLength".
> Msg 7330, Level 16, State 2, Line 1
> Cannot fetch a row from OLE DB provider "Advantage OLE DB Provider" for
> linked server "ADSBASE".
>
> The SQL instruction used:
>
> SELECT * FROM OPENQUERY(ADSBASE, 'SELECT * FROM GFAC')
>
> When i limit the amount off records by adding a WHERE, I don't get this
> error. All the records are returned without a problem.
>
> Any idea?
>
> Thanks,
>
> Matthias