Here is how I have qualified a path using 4 part naming in my sp:

SELECT vgiwpw03-sql3/equentialprod.goLabor30.Batch.ReportDate AS job_date

this:

SELECT 'vgiwpw03-sql3\equentialprod.' + goLabor30.Batch.ReportDate AS job_date

My vb program gives me error when calling the sp:

Invalid object name 'Batch'

My server is VGIWPW03-SQL3\EQUENTIALPROD and database = goLabor30 and table = batch

SELECT Batch.ReportDate AS job_date
from [vgiwpw03-sql3\equentialprod].goLabor30.dbo.Batch