Hi Mark,
I'm not sure if I follow you, but for what I understand when you try to call
data from one server to other you get the error bellow, right?, are you writing the whole path in your SQL statement, like this:
ServerName.DatabaseName.DBO.TableName
i.e.
SELECT *
FROM ServerName.DatabaseName.DBO.TableName
WHERE Condition
HTH
>I am trying to implement linked servers to access some legacy VFP data.
>I have created a linked server and I can access data using it when I run my select queries on the SQL box, but I running it remotely returns this:
>
>OLE DB provider "VFPOLEDB" for linked server "specifications" returned message "Invalid path or file name.".
>Msg 7303, Level 16, State 1, Line 1
>Cannot initialize the data source object of OLE DB provider "VFPOLEDB" for linked server "specifications".
>
>I was told I have to use a SQL authentication to run LSs. Not sure what I need to do. Any idea out there?
>
>Thanks
Luis Guzman, MCP
"The only glory most of us have to hope for
is the glory of being normal." Katherine Fulleton Gerould