Connecting To FoxPro

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Salad
    #1

    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?

    Tags: None
    • Robert Emmons
      #2
      Re: Connecting To FoxPro

      Salad <oil@vinegar.co m> wrote on Thu, 01 Jul 2004 06:30:12 GMT:[color=blue]
      >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?[/color]

      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
      remmonsREMOVECA PS@aurigen.com

        Comment

        • Salad
          #3
          Re: Connecting To FoxPro

          Robert Emmons wrote:[color=blue]
          > Salad <oil@vinegar.co m> wrote on Thu, 01 Jul 2004 06:30:12 GMT:
          >[color=green]
          >>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?[/color]
          >
          >
          > 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.
          >[/color]

          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.

            Comment

            • Robert Emmons
              #4
              Re: Connecting To FoxPro

              Salad <oil@vinegar.co m> wrote on Thu, 01 Jul 2004 19:06:24 GMT:[color=blue]
              >Robert Emmons wrote:[color=green]
              >> Salad <oil@vinegar.co m> wrote on Thu, 01 Jul 2004 06:30:12 GMT:
              >>[color=darkred]
              >>>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?[/color]
              >>
              >>
              >> 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.
              >>[/color]
              >
              >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
              >(ControlPane l/AdminTools/ODBC if XP)? Any idea what your MDAC is?
              >Thank you.[/color]

              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.EX E in the workstation's c:\windows\syst em32. 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
              remmonsREMOVECA PS@aurigen.com

                Comment

                • Robert Emmons
                  #5
                  Re: Connecting To FoxPro

                  Salad <oil@vinegar.co m> wrote on Thu, 01 Jul 2004 19:06:24 GMT:[color=blue]
                  >Robert Emmons wrote:[color=green]
                  >> Salad <oil@vinegar.co m> wrote on Thu, 01 Jul 2004 06:30:12 GMT:
                  >>[color=darkred]
                  >>>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?[/color]
                  >>
                  >>
                  >> 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.
                  >>[/color]
                  >
                  >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
                  >(ControlPane l/AdminTools/ODBC if XP)? Any idea what your MDAC is?
                  >Thank you.[/color]

                  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.EX E in the workstation's c:\windows\syst em32. 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
                  remmonsREMOVECA PS@aurigen.com

                    Comment

                    Previous template Next
                    Working...