Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Unfortunately doing this install makes no difference.
Also, the select command is super slow, i.e. on the order of a minute. There is an index on both part and serial.
I've just about given up.
Thanks for all your help,
Mike
>Have you tried installing the new ODBC drivers [version 2.5] from MS [MDAC_TYP.EXE]. This is just to simple a SQL for it to be failing as you say. I use the VFP ODBC to tap into a VFP DBC in a production app right now, and I never get such errors.
>
>Where is the DBC and tables located? On a Novell drive? NT Shared drive? Do the users have sufficient privileges/rights to access the files? On Novell, the minimum rights are Read and File Scan [R/F].
>
>>I know this is not the problem because I tried it with another table, that has two fields:
>>actdata,data_type
>>if I do a SQL select thusly:
>>select actdata from rawdata where data_type='PRD'
>>The same problem occurs.
>>
>>Thanks so far,
>>Mike
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement