🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #1293

Re: ADOConnection and VFPOLEDB

#1293
From: Viatcheslav V. Vassiliev
Date: Wed, 04 Aug 2004 14:18
44 lines
2634 bytes
Provider should be registered as COM object. In Win2000, WinXP and Win2003
it is possible to register COM object for specified user. In this case it
may be not registered for all users.

HKEY_CLASSES_ROOT in registry is sum of HKEY_LOCAL_MACHINE\SOFTWARE\Classes
and HKEY_CURRENT_USER\SOFTWARE\Classes

Look where provider is registered. If for current user, register it for all
users. Check also that CreateComObject(ProgIDToClassID("VFPOLEDB.1")) does
not raise an error.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Orlando Lopez" <hlopezrd@hotmail.com.do> �������/�������� � ��������
���������: news:4110eea9$1@newsgroups.borland.com...
>
> Hi to all,
>
> Sorry by repost the same issue, but I don't get answer in the
> student groups.
>
> I have an application that access and update VFP (6.0) using
> VFPOLEDB and ADO. The application work great, but when I convert
> this application in a Service application I got an error
> when I trying to connect to the VFP tables using the
> ADOConnection component, the error say:
> "Provider cannot be found. It may not properly installed."
>
> I'm using and udl file to connect (the same in the application
> and in the service application). I tried to make the connection
> string by myself:
> "Provider=VFPOLEDB.1;Data
Source=D:\\mbi;Mode=ReadWrite;Password="";Collating Sequence=MACHINE";
>
> But I'm still getting this error, and I don't know why!? :s
> somebody can help me?
>
> Orlando.
Technical Details
Message-ID: <4110f03c@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!hammer.uoregon.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail
References: <4110eea9$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,e73c225905a80d96
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII
From: "Viatcheslav V. Vassiliev" <support@oledbdirect.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <4110eea9$1@newsgroups.borland.com>
Subject: Re: ADOConnection and VFPOLEDB
Date: Wed, 4 Aug 2004 18:18:38 +0400
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1437
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441
NNTP-Posting-Host: 213.234.218.42
Message-ID: <4110f03c@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1091629116 213.234.218.42 (4 Aug 2004 07:18:36 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!hammer.uoregon.edu!logbridge.uoregon.edu!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail