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: 154965 # Views: 2 # Ratings: 0
Version: Visual FoxPro 8 Category: ODBC, ADO and OLEDB
Date: Thursday, December 20, 2007 8:27:33 PM         
   


> >
> >
> > Chris,
> > Vfp ODBC is 6.0 and never updated . As i see your version is 8 .. Compatibility might be a issue...
> >
> > You might download the new VFP oledb driver from
> > http://www.microsoft.com/downloads/details.aspx?familyid=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&displaylang=en
> >
> > To check which version is installed check the version in properties of the installed VFPoledb.dll in C:\Program Files\Common Files\System\Ole DB ( atleast on my system).
> > It is here 9.0.0.3504
> >
> > I have seen good improvements in speed using the latest Vfpoledb driver
> >
> > [Edit] With ODBC that was never unpdated are u sure the results were proper ?
> > thanx
> > suhashegde
>
>
> I'm positive the results are correct.
>
> Now what I'm not positive of is what vfpoledb version I'm using. I have 2 on my system.
>
> 8.0.0.2521 in c:\documents and settings\all users\documents\vfp8\program files\common\system\ole db
> and
> 9.0.0.3504 in c:\program files\common files\system\ole db


rename the first -- 8.0.0.2521 in c:\documents and settings\all users\documents\vfp8\program files\common\system\ole db\vfploedb.dll to something

then see if the connection works
If it complains provider not found then it is using 8.0.0...

Alternate way is to check the registry keys at

HKEY_CLASSES_ROOT\VFPOLEDB
HKEY_CLASSES_ROOT\VFPOLEDB.1
HKEY_CLASSES_ROOT\Vfpoledb.ConnectionPage
HKEY_CLASSES_ROOT\Vfpoledb.ConnectionPage.1
HKEY_CLASSES_ROOT\VFPOLEDB.ErrorLookup
HKEY_CLASSES_ROOT\VFPOLEDB.ErrorLookup.1

with the following keys


[HKEY_CLASSES_ROOT\VFPOLEDB]
@="Microsoft OLE DB Provider for Visual FoxPro"

[HKEY_CLASSES_ROOT\VFPOLEDB\CLSID]
@="{50BAEED9-ED25-11D2-B97B-000000000000}"

[HKEY_CLASSES_ROOT\VFPOLEDB\CurVer]
@="VFPOLEDB.1"

[HKEY_CLASSES_ROOT\VFPOLEDB.1]
@="Microsoft OLE DB Provider for Visual FoxPro"

[HKEY_CLASSES_ROOT\VFPOLEDB.1\CLSID]
@="{50BAEED9-ED25-11D2-B97B-000000000000}"

[HKEY_CLASSES_ROOT\Vfpoledb.ConnectionPage]
@="VfpOLEDBConnectionPage Class"

[HKEY_CLASSES_ROOT\Vfpoledb.ConnectionPage\CLSID]
@="{50BAEEDB-ED25-11D2-B97B-000000000000}"

[HKEY_CLASSES_ROOT\Vfpoledb.ConnectionPage\CurVer]
@="vfpOLEDBDLink.ConnectionPage.1"

[HKEY_CLASSES_ROOT\Vfpoledb.ConnectionPage.1]
@="VfpOLEDBConnectionPage Class"

[HKEY_CLASSES_ROOT\Vfpoledb.ConnectionPage.1\CLSID]
@="{50BAEEDB-ED25-11D2-B97B-000000000000}"

[HKEY_CLASSES_ROOT\VFPOLEDB.ErrorLookup]
@="VFPOLEDB Error Lookup"

[HKEY_CLASSES_ROOT\VFPOLEDB.ErrorLookup\CLSID]
@="{50BAEEDA-ED25-11D2-B97B-000000000000}"

[HKEY_CLASSES_ROOT\VFPOLEDB.ErrorLookup.1]
@="VFPOLEDB Error Lookup"

[HKEY_CLASSES_ROOT\VFPOLEDB.ErrorLookup.1\CLSID]
@="{50BAEEDA-ED25-11D2-B97B-000000000000}"


suhashegde

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