KEV KNOX
KEV KNOX

Reputation: 1

Using Foxpro tables and Advantage Data Architect

I mainly want to use advantage to be able to access Fox tables larger than 2 gig. My programs are simple and are run from the command window. I have Adv Data Archetect installed and have the ODBC driver installed.
I'm not very knowledgeable with connections, etc. Can someone explain to me, provide a link or provide the code that I would need to be able to use and create 2 gig + tables. Thanks

Upvotes: 0

Views: 933

Answers (1)

Mark Wilkins
Mark Wilkins

Reputation: 41262

I cannot tell from the OP what you have actually done, but it sounds like you are expecting to be able to use an ODBC driver with an existing Visual FoxPro application without changing the application from the direct table access. That is not possible.

Here is a link to a screencast showing an example of using ODBC to get to a table that is over the 2GB limit. If I recall correctly, it shows how to use views to access the data; doing it that way can minimize the number of changes you need to make. More information about remote views can be found here.

You can also use ODBC "directly" with SQL pass through statements. It is also possible to use OLE DB with cursor adapters if you prefer that over ODBC.

Upvotes: 2

Related Questions