Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: tushar Kanvinde
  Where is tushar Kanvinde?
 Kolhapur, Maharastra
 India
 tushar Kanvinde
 To: Chris
  Where is Chris?
 
 North Carolina - United States
 Chris
 Tags
Subject: RE: accessing foxpro tables from VB .Net
Thread ID: 154685 Message ID: 154937 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: ODBC, ADO and OLEDB
Date: Thursday, December 20, 2007 6:00:50 PM         
   


> >
> > Chris
> >
> > In case OLEDB refuses to use an index, the problem could be a mismatch in the collation sequence. Check out https://www.foxite.com/archives/vfp6-newbie-index-questions-0000150509.htm
> >
> > Regards
> > Tushar
>
> I've tried both general and machine. I was using general first. They work the same.

Chris

If you have VFP, use the table and then give the command DISPLAY STATUS. This will give you the index and the collation sequence. The fact that you are getting good speed with ODBC and not with OLEDB seems to point to a collation mismatch

Regards
Tushar

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