December 4, 2008 at 10:17 pm
HI, I have linked an Excel file as a linked server. Everything works fine under the 'sa' login, but since I am trying to query the file through a web page, I am using a different login other than 'sa'. I have been fighting this for over 2 hours and can't get a regular logon to query the file - this is what is returned: (XLTEST being my excel file link)
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "XLTEST" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".
Workgroup information? - htought that was for Access databases...
Everything works fine with the SA, just won't work with a different user
CAn anyone help - I have googled it for over an hour and none of the results have solutions
Thanks
December 5, 2008 at 1:15 am
[font="Verdana"]Check the user credentials, other than SA, whether it has equivalent with SA.
Mahehs[/font]
MH-09-AM-8694
December 5, 2008 at 8:34 am
Well yes, that is definitely a direction however, I am afraid of making this a very powerful user since it will be eventually a web query, just wondering if there were any specific things I could do without making it the equivalent of a "sa"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply