473,320 Members | 1,859 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Connecting To FoxPro

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?

Nov 13 '05 #1
4 3343
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.

--
Robert Emmons
re***************@aurigen.com
Nov 13 '05 #2
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.

Nov 13 '05 #3
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
Nov 13 '05 #4
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.

--
Robert Emmons
re***************@aurigen.com
Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

13
by: Simon Bailey | last post by:
I am a newcomer to databases and am not sure which DBMS to use. I have a very simplified knowledge of databases overall. I would very much appreciate a (simplifed) message explaining the advantages...
2
by: Salad | last post by:
OS = WinXP & Win98. Access = A97 & AXP Q1) Where can I find the VFP ODBC driver at Microsoft. I have been working developing an app in Access that will link to some DOS FoxPro tables. I...
14
by: John Spiegel | last post by:
Hi all, I'm missing something, probably stupid, on connecting to a SQL Server database from an aspx file. I haven't really done much w/ SQL Server and suspect that it's a problem on that side. ...
2
by: Edb | last post by:
Hi Everyone, I need to build an ASP.Net project that wraps around a FoxPro Database. It appears that I need to create an ODBC Connection to .dbf files. Some of them have relations to each...
3
by: Amar | last post by:
I have a abc.PRG file in visual foxpro 8.0. I can run this file using visual foxpro environment and it creates a table X.dbf in the same folder where this program file is and populates some data...
3
by: Burak Gunay | last post by:
Hello, I am trying to connect to a visual fox pro table from my asp.net page. I dragged an odbc connection and set it to a visual fox pro driver file dsn pointing to "mydocuments" folder. ...
2
by: Toco | last post by:
Hello. I have app written in C# that we are testing. The executable is shared on our network. The method we are testing is a call to a foxpro table. The call is made to query the table, then...
3
by: Salad | last post by:
Is it the rule that any table that you want to use via ODBC must be a UNIQUE record? And if you want any speed associated with the table it should be indexed? I was having some difficulty...
7
by: z71mdridin | last post by:
I have an asp.net website that uses Form authentication to authenticate users. I need to provide users with a report based on FoxPro data that resides on a remote server. When I attempt to...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.