March 26, 2009 at 2:05 pm
Hi,
I search and found hunderes of link on this topic but I am still not finding what I want. Sorry for the repeated questions.
We have hundereds of servers/workstations on our network
MyComp is my workstation on network.
AppServer is the file server where my FoxPro application and data stored. Also have access file stored here.
SQLDev is the servername (computer name) where I have installed SQL server 2000 for development
U: drive is mapped to \\FoxData\MyFoxData, and on SQL server I
created link server for foxpro dbc file located on U: (AppServer) using
vfpoledb driver. It works fine SQLDev box and I can view all tables in dbc
file and I can also query.
Now I open enterprise manager on MyComp (my workstation) and can see the
linked server but when I try to see all tables, it gives me error: 7303
Could not initialize data source object of OLE DB provider 'VFPOLEDB'.
What am I doing wrong here? Can anyone please explain?
March 29, 2009 at 8:17 pm
The SQL Server needs to see that drive, and see if using the Service account running SQL Server. That is the account that will access the drive as a linked server.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply