Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem linking to DBF with CDX in NT40
Message
 
À
13/09/1999 13:21:22
James Marshall
SPAWAR Systems Center Charleston NCR
Washington, District de Colombia, États-Unis
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00264082
Message ID:
00268897
Vues:
15
>First time caller, long time listener.
>
>I have a utility I wrote in VB5sp3, that links in a number of Foxpro 2.6 DBFs into an .MDB file via DAO. Nothing special here, and all works just fine under Win95/98. However, when I run my utility on NT 4.0 sp4/sp5, I get the dreaded Dr. Watson c0000005 data access error. On a lark, I separated the .CDX files from the .DBF directory, and found that everything then worked. I suspect that the header info in the DBF contains associated CDX file info, and attempts to open it. Does anyone have any thoughts as to why this might cause an error on NT?
>
>I've tried recompiling my utility with VB60sp3, as well as applying the latest MDAC from Microsoft, but no joy. Adding .INFs for the .DBFs had no effect. I read somewhere that DCOM for NT is installed automatically with NTsp 3 or 4, but my knowlege of NT is rather limited. I do know that the workstations I'm running have no admin restrictions. I hope to avoid copying the .DBFs into a separate directory, as it is a distributed utility. Thanks in advance.

James, I think I can help. I had a not too dissimilar problem with a FPW2.6a application compiled on a 16 bit machine. When I installed it on a 32 bit WIN95 machine my indexes failed - I do not remember the exact failure but it was due to the fact that the CDX's were built on a 16bit OS and not a 32bit os.

My solution - I setup an "intall" column on my configuration table (which does not use a CDX) and set it to .t. When the installation first executes, I check to see if this flag is on. If it is I execute a udf() that indexes (not reindexes), builds all index tags on all tables from scratch. That worked!

Try that - I suspect it may solve your problem. My humble apologies if it does not.

Carl
Carl R. Perkins
NJ5J Software Corp. http://www.nj5j.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform