Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
M_BSQL
Starting Member
8 Posts |
 Posted - 2008-02-19 : 11:33:03
|
Hi all, I'm having issues with a FoxPro linked server.I've set up a linked server to a FoxPro dbc using the Microsoft OLE DB Provider for Visual FoxPro. When I'm on Management Studio on my server the link appears to be working fine and a stored procedure I've created to get the indo from the dbc and put it into a temp table works fine. However, when I try to execute the sp on management studio on my local machine I get the following error:OLE DB provider "VFPOLEDB" for linked server "tern" returned message "Invalid path or file name.".Msg 7303, Level 16, State 1, Procedure usp_SSRS_007, Line 28Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "tern".And I also get a similar error when I try to test the connection of the linked server on my local machince.This is now driving me nuts , so many many thanks in advance for any help!!! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-19 : 12:08:59
|
| maybe this helps:http://msdn2.microsoft.com/en-us/library/aa975609(VS.71).aspx |
 |
|
|
M_BSQL
Starting Member
8 Posts |
Posted - 2008-02-20 : 04:27:14
|
quote:
Originally posted by sodeep
maybe this helps:http://msdn2.microsoft.com/en-us/library/aa975609(VS.71).aspx
That's what I've used and it works fine on my server just not on my local machine |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 15:45:48
|
| Can you access foxpro from your pc outside of sql? Does sql service account have permission to access it? |
|
|
|
amcamx
Starting Member
3 Posts |
Posted - 2011-02-09 : 10:13:59
|
| I am getting this same problem. Has anyone else been able to resolve it ?Thank You, |
|
|
|
|
|
|
FoxPro linked server