|
|
Posted by Erland Sommarskog on 05/24/05 00:31
(grondaia@gmail.com) writes:
> Thanks for the help.....
>
> It definitely seems to be NT permission related and related to being a
> named instance of sql server. I can run reports off of it using SQL
> reporting but again only if I specify in the data source to use the
> same NT account that is used by the name instance service.
I've yet to receive a response.
One thing you could check is whether this happens with any linked
server that uses ODBC. You can add a linked server to access an Excel
file like this:
EXEC sp_addlinkedserver 'ExcelSource',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'C:\temp\test.xls',
NULL,
'Excel 5.0'
GO
and access it like this:
select * from ExcelSource...Sheet1$
If this works, it's starting to look like an issue with the Timberland
ODBC driver, in which case it's starting to look difficult...
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|