First off, I'm sorry if this has been asked before.

I'm currently having an issues exporting, or getting the data via an odbcdatareader from a ADT file that is currently able to be viewed via Advantage Architect, but not able to be exported out. Let me explain what I've done so far, and what I've seen.

  1. I've attempted to export via Advantage Architect. (received a 7071 error. To which I then set the file Advanced Option to Exclusive, and it allowed me to only view the data.)
  2. I made an ODBC connection to the data dictionary to which allows me to open read data from other tables, but not this specific one.
  3. I've attempted to import, and link to an Access database.
  4. I've attempted opening up the database with a local server, and still received the error.
  5. I've attempted to mess with the registries in order to get the settings to be nonexclusive.
  6. I've attempted to export the data into notepad++
  7. I've attempted to export the data into Excel.

Things that I've noticed. 1. The data file is 4gb+ 2. I receive the error 7071(file size is too large) if the file is not opened exclusively from within the Advantage Architect database. 3. I receive the error 7008(meme, or index is not able to be linked or found) when trying to export, read, or connect to the file when the file is open in Advantage Architect. 4. The database is set to work with a program, and I've matched that programs settings for the service, and config files. 5. Both the free, and linked to Data Dictionary version both have the same issues. 6. The data file has no problem opening with the program initially using it, but cannot be exported by any method that I've tried thus far.

Does anyone else have an idea as to why I could try, or attempt next?

asked 28 Apr '15, 17:41

brandonCPM's gravatar image

brandonCPM
11112
accept rate: 0%


If you set ADSTable1.Exclusive := True successfully, there should be no problems with exporting data bigger than 4 GB.

link

answered 29 Apr '15, 04:55

Marc's gravatar image

Marc
522202539
accept rate: 20%

edited 29 Apr '15, 04:56

The actual answer was updating from 11.0 to 11.1. Apparently the proprietary rights, and exclusive rights configuration has been fixed throughout the latest version, but I didn't see any notation in the logs. Anywho, it's resolved.

link

answered 29 Apr '15, 08:36

brandonCPM's gravatar image

brandonCPM
11112
accept rate: 0%

Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×55
×43
×7
×7

Asked: 28 Apr '15, 17:41

Seen: 2,804 times

Last updated: 29 Apr '15, 08:36

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.