Salad <oi*@vinegar.com> wrote on Thu, 01 Jul 2004 19:06:24 GMT:
Robert Emmons wrote: Salad <oi*@vinegar.com> wrote on Thu, 01 Jul 2004 06:30:12 GMT:
When I connect to FoxPro tables it takes about 1 1/2 minutes to view the
records in a small table. Is this normal ODBC behavior?
As I recall, FoxPro uses dBASE (*.dbf) tables. I have a 407 record
table with 350 fields. It is linked into an MS-Access 2000 database,
and it loads and displays in seconds.
Hi Robert,
Could you do me a favor and tell me what your version number is of the
ODBC FoxPro driver (Control Panel, ODBC) or
(ControlPanel/AdminTools/ODBC if XP)? Any idea what your MDAC is?
Thank you.
I have a workstation running Windows 2000, and a laptop running
Windows 98. Both computers load the linked table and display it in
seconds.
The laptop has Microsoft Corporation odbcjt32.dll version
4.00.4403.02, date 10/02/03
The workstation has Microsoft Corporation odbcjt32.dll version
4.00.6200.00, date 06/19/03.
I have MDAC_TYPE280.EXE in the workstation's c:\windows\system32. It
is version 28.0.1022.3. I think that is just an extractor for MDAC.
The MDAC is probably whatever was installed with MS-Access 2000, which
is on both computers.
Not sure what else to check. I will not be back until Tuesday.
--
Robert Emmons
re***************@aurigen.com