Article View: borland.public.cppbuilder.database.ado
Article #1295Re: ADOConnection and VFPOLEDB
From: Mark Guerrieri
Date: Wed, 04 Aug 2004 16:55
Date: Wed, 04 Aug 2004 16:55
56 lines
3174 bytes
3174 bytes
Also, make sure the user that the service is running under has access to the
driver and its files. I routinely use this driver in services and have had
no problems (at least of that sort...)
Mark
"Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
news:4110f03c@newsgroups.borland.com...
> 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:
<411114fa@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<4110eea9$1@newsgroups.borland.com> <4110f03c@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,e73c225905a80d96 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII Reply-To: "Mark Guerrieri" <mguerrieri@cmsgrp.com> From: "Mark Guerrieri" <mguerrieri@cmsgrp.com> Newsgroups: borland.public.cppbuilder.database.ado References: <4110eea9$1@newsgroups.borland.com> <4110f03c@newsgroups.borland.com> Subject: Re: ADOConnection and VFPOLEDB Date: Wed, 4 Aug 2004 12:55:23 -0400 Lines: 58 Organization: Creative Marketing Strategies X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 66.200.143.50 Message-ID: <411114fa@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1091638522 66.200.143.50 (4 Aug 2004 09:55:22 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news.glorb.com!fr.ip.ndsoftware.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail