Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: suhas hegde
  Where is suhas hegde?
 sirsi
 India
 suhas hegde
 To: Chris
  Where is Chris?
 
 North Carolina - United States
 Chris
 Tags
Subject: RE: accessing foxpro tables from VB .Net
Thread ID: 154685 Message ID: 155188 # Views: 3 # Ratings: 0
Version: Visual FoxPro 8 Category: ODBC, ADO and OLEDB
Date: Thursday, December 27, 2007 5:23:09 AM         
   


>
> I installed the latest version of vfpoledb (9.0.0.3504) and renamed the 8.0.... version and retried. Same 2 minute results.

Hi,

I read your posts over again and this is what i have to say

Your posts:-

ODBC version -- You claim this is faster ..

myOdbcConnection = New OdbcConnection("Driver={Microsoft Visual FoxPro Driver};SourceType=DBF;SourceDB=c:\;Exclusive=No; Collate=Machine;NULL=NO;DELETED=NO;BACKGROUNDFETCH=NO;")

Oledb version

myOleDbConnection = New OleDbConnection("Provider=vfpoledb.1;Data
Source=i:\;Collating Sequence=general")

My inference

1) In oledb try with Collate = Machine)
2) Data Source is pointing to i:\ ? why is it to find the network or a relative remote path everytime it initialises ? time delay ?
3) How could you be sure abt the results when he collate sequence was wrong ? either one must give you wrong results if it were to use the index in VFP 8

Try with this string in OLEDB

myOleDbConnection = New OleDbConnection("Provider=vfpoledb.1;Data
Source=c:\;Collating Sequence=Machine")

Suhashegde
[edit]
P.S.: I have been using Oledb driver with C#. I i really fine your timing unrealistic.

ENTIRE THREAD

accessing foxpro tables from VB .Net Posted by Chris @ 12/18/2007 7:58:03 PM
RE: accessing foxpro tables from VB .Net Posted by Eric den Doop @ 12/18/2007 8:15:16 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 4:46:50 PM
RE: accessing foxpro tables from VB .Net Posted by Eric den Doop @ 12/19/2007 5:11:37 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 9:24:50 PM
RE: accessing foxpro tables from VB .Net Posted by Borislav Borissov @ 12/19/2007 9:38:14 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 9:43:45 PM
RE: accessing foxpro tables from VB .Net Posted by Borislav Borissov @ 12/19/2007 9:50:32 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 10:32:23 PM
RE: accessing foxpro tables from VB .Net Posted by suhas hegde @ 12/19/2007 9:56:25 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/20/2007 4:24:34 PM
RE: accessing foxpro tables from VB .Net Posted by suhas hegde @ 12/20/2007 8:27:33 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/26/2007 9:54:59 PM
RE: accessing foxpro tables from VB .Net Posted by suhas hegde @ 12/27/2007 5:23:09 AM
RE: accessing foxpro tables from VB .Net Posted by suhas hegde @ 12/19/2007 5:44:20 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 9:23:06 PM
RE: accessing foxpro tables from VB .Net Posted by Eric den Doop @ 12/19/2007 9:57:00 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 10:54:01 PM
RE: accessing foxpro tables from VB .Net Posted by Cetin Basoz @ 12/19/2007 7:13:44 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 9:00:21 PM
RE: accessing foxpro tables from VB .Net Posted by Cetin Basoz @ 12/19/2007 9:59:48 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/20/2007 5:01:14 PM
RE: accessing foxpro tables from VB .Net Posted by Cetin Basoz @ 12/27/2007 3:46:45 PM
RE: accessing foxpro tables from VB .Net Posted by Cetin Basoz @ 12/18/2007 8:54:59 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 4:48:41 PM
RE: accessing foxpro tables from VB .Net Posted by tushar @ 12/19/2007 1:38:29 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 4:35:12 PM
RE: accessing foxpro tables from VB .Net Posted by Cetin Basoz @ 12/19/2007 4:38:01 PM
RE: accessing foxpro tables from VB .Net Posted by Chris @ 12/19/2007 4:49:56 PM
RE: accessing foxpro tables from VB .Net Posted by tushar @ 12/20/2007 6:00:50 PM
RE: accessing foxpro tables from VB .Net Posted by William Sanders @ 12/19/2007 6:25:07 PM