Linked Server to Excel Issue

I am using a linked server to connect SQL Server to an Excel Spreadsheet on
the network. If I'm physically on the SQL Server box I can open the linked
server and see the named range on the desired spreadsheet. Also If I'm on
the SQL Server box I can query the spreadsheet using OPENQUERY and everythin
g
comes across beautifully.
However, if I connect to the SQL Server box from a different location (via
Enterprise Manager) and try to run a query using the OPENQUERY and linked
server in question. I keep getting the dreaded "error 7399: blah, blah,
blah".
Any thoughts?
Thanks in advance,
RaulYour proxy account does not have access to network resources.
See this article for more info:
http://msdn.microsoft.com/library/d.../>
sz_8sdm.asp
-oj
"Raul" <raul@.nothere.com> wrote in message
news:6AD242AB-BD43-49B2-AC3D-119EC788CF91@.microsoft.com...
>I am using a linked server to connect SQL Server to an Excel Spreadsheet on
> the network. If I'm physically on the SQL Server box I can open the
> linked
> server and see the named range on the desired spreadsheet. Also If I'm on
> the SQL Server box I can query the spreadsheet using OPENQUERY and
> everything
> comes across beautifully.
> However, if I connect to the SQL Server box from a different location (via
> Enterprise Manager) and try to run a query using the OPENQUERY and linked
> server in question. I keep getting the dreaded "error 7399: blah, blah,
> blah".
> Any thoughts?
> Thanks in advance,
> Raul|||Thanks,
Raul
"oj" wrote:

> Your proxy account does not have access to network resources.
> See this article for more info:
> http://msdn.microsoft.com/library/d...
a-sz_8sdm.asp
>
> --
> -oj
>
> "Raul" <raul@.nothere.com> wrote in message
> news:6AD242AB-BD43-49B2-AC3D-119EC788CF91@.microsoft.com...
>
>

linked server to Excel

We've created a linked server to access an Excel spreadsheet that resides on
the same server as SQL Server 2000. If we log on to the database server
(Windows 2000), then launch Enterprise Manager, the linked server works
perfectly.
But, if we launch Enterprise Manager from a desktop machine (Windows 2000)
and attempt to use the linked server we get: "Error 7399 : OLE DB provider
'Microsoft.Jet.OLEDB.4.0' reported an error."
Any ideas?SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=;Password=;Extended properties=Excel
5.0')...[test1$]
And the 'test1' is the name of work sheet.
"Vince" wrote:

> We've created a linked server to access an Excel spreadsheet that resides
on
> the same server as SQL Server 2000. If we log on to the database server
> (Windows 2000), then launch Enterprise Manager, the linked server works
> perfectly.
> But, if we launch Enterprise Manager from a desktop machine (Windows 2000)
> and attempt to use the linked server we get: "Error 7399 : OLE DB provide
r
> 'Microsoft.Jet.OLEDB.4.0' reported an error."
> Any ideas?
>
>|||Thanx for the response.
However, I get the same result.
"luyan" <luyan@.discussions.microsoft.com> wrote in message
news:FFE5CD8B-ED99-4568-8B55-21AB6A73242C@.microsoft.com...[vbcol=seagreen]
> SELECT *
> FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
> 'Data Source="c:\test.xls";User ID=;Password=;Extended properties=Excel
> 5.0')...[test1$]
> And the 'test1' is the name of work sheet.
> "Vince" wrote:
>
resides on[vbcol=seagreen]
2000)[vbcol=seagreen]
provider[vbcol=seagreen]

linked server to Excel

We've created a linked server to access an Excel spreadsheet that resides on
the same server as SQL Server 2000. If we log on to the database server
(Windows 2000), then launch Enterprise Manager, the linked server works
perfectly.
But, if we launch Enterprise Manager from a desktop machine (Windows 2000)
and attempt to use the linked server we get: "Error 7399 : OLE DB provider
'Microsoft.Jet.OLEDB.4.0' reported an error."
Any ideas?
SELECT *
FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="c:\test.xls";User ID=;Password=;Extended properties=Excel
5.0')...[test1$]
And the 'test1' is the name of work sheet.
"Vince" wrote:

> We've created a linked server to access an Excel spreadsheet that resides on
> the same server as SQL Server 2000. If we log on to the database server
> (Windows 2000), then launch Enterprise Manager, the linked server works
> perfectly.
> But, if we launch Enterprise Manager from a desktop machine (Windows 2000)
> and attempt to use the linked server we get: "Error 7399 : OLE DB provider
> 'Microsoft.Jet.OLEDB.4.0' reported an error."
> Any ideas?
>
>
|||Thanx for the response.
However, I get the same result.
"luyan" <luyan@.discussions.microsoft.com> wrote in message
news:FFE5CD8B-ED99-4568-8B55-21AB6A73242C@.microsoft.com...[vbcol=seagreen]
> SELECT *
> FROM OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
> 'Data Source="c:\test.xls";User ID=;Password=;Extended properties=Excel
> 5.0')...[test1$]
> And the 'test1' is the name of work sheet.
> "Vince" wrote:
resides on[vbcol=seagreen]
2000)[vbcol=seagreen]
provider[vbcol=seagreen]