November 7, 2005 at 5:47 pm
I've been trying to determine the cause of a web error for a datasource and have been totally unsuccessful. The Web pages previously worked but now are giving an error. Although I can susccessfully run sp_tables_ex AIDEBOMs using the master table when I query the data directly it gives and error about the authentication but the linkedserver is using not security context. I've attempted a number of alternatives, all with the same results. Any assistance with this problem would be appreciated.
November 8, 2005 at 7:03 am
When you expand the linked server under Security in Enterprise Manager can you see a list of tables when you click on Tables ?
Daniel
November 8, 2005 at 8:39 am
Yes I can expand to the tables. The provider string is 'Excel 8.0; IMEX=1' and the product name is 'Jet 4.0'. We have been using this successfully for months before these problems
November 8, 2005 at 8:42 am
Is your linked server an Excel file??
November 8, 2005 at 9:19 am
Yes, it is an Excel file. I deleted it and recreated the Linked Server and modified permissions and am now able to select data from the server.
EXEC sp_addlinkedserver @server=N'AIDEBOMs', @srvproduct=N'Excel',
@provider = N'Microsoft.Jet.OLEDB.4.0',
@Datasrc=N'\\MYLOGAPPS\C$\MYAPPS\EXCELDATA\AIDEDB.xls',
@provstr='Excel 8.0',
@Catalog=N'Excel 8.0'
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply