Re: VFPOLEDB as a link server in SQL Server 2000
- From: Phil H <philhege@xxxxxxxxxxxxxxxxx>
- Date: Wed, 8 Jun 2005 08:07:02 -0700
No; I keep getting the following error:
Error 7303: could not initialize data source object of OLEDB provider
'VFPOLEDB'.
OLE DB error trace [OLE/DB Provider 'VFPOLEDB' IDBInitialize::Initialize
returned 0x80040e21].
I've tried both mapped and UNC paths to the DBC. The mapped drive is not
'red-X'ed', and the SQL server service account and machine have rights to the
target resource.
My forehead's bloody from this brick wall. Besides, you can't update Fox
data from this setup anyway; you can only query it. On to other projects.
--
Phil Hegedusich
Senior P/A
IIMAK
----
A skeleton walks into a bar and says, "I need a beer and a mop."
"Cindy Winegarden" wrote:
> Hi Phil,
>
> You're right about the linked server name being the one that shows in the
> tree. The product name isn't important and you can leave it blank. As for
> the relationship of the provider string to the choices in the combobox, I'm
> not entirely sure but sometimes there might be more than one version of the
> VFP OLE DB data provider installed and you might want VFPOLEDB.1.
>
> Were you able to get your linked server to work?
>
> --
> Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
> cindy_winegarden@xxxxxxx www.cindywinegarden.com
> Blog: http://spaces.msn.com/members/cindywinegarden
.
- References:
- VFPOLEDB as a link server in SQL Server 2000
- From: Phil H
- Re: VFPOLEDB as a link server in SQL Server 2000
- From: Cindy Winegarden
- Re: VFPOLEDB as a link server in SQL Server 2000
- From: Phil H
- Re: VFPOLEDB as a link server in SQL Server 2000
- From: Cindy Winegarden
- VFPOLEDB as a link server in SQL Server 2000
- Prev by Date: Re: VFPOLEDB as a link server in SQL Server 2000
- Next by Date: Re: Linked Server in SQL Server 2000 Evaluation Version
- Previous by thread: Re: VFPOLEDB as a link server in SQL Server 2000
- Next by thread: SQL Linked Server with FoxPro
- Index(es):
Relevant Pages
|
