Linked Server Error

  • 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.

  • When you expand the linked server under Security in Enterprise Manager can you see a list of tables when you click on Tables ?

    Daniel

  • 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

  • Is your linked server an Excel file??

  • 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