Question

I ve创建了一个与Excel spreedsheet连接的服务器。它在Solker I的ok和工作可向质子中查询前el。

但是,当我试图在我一页进入这一链接服务器时:

Set pishbini = Server.CreateObject("ADODB.Recordset")

pishbini.ActiveConnection = MM_semmet_STRING
pishbini.Source = "SELECT * FROM OPENQUERY(SemnanmetWeekly,  SELECT * FROM [DayPish$] )"
pishbini.CursorType = 0
pishbini.CursorLocation = 2
pishbini.LockType = 1
pishbini.Open()

Semnanmet Weekly is the name oflink服务器 inkou I m 带将这一错误带入我的正页:

Microsoft OLE DB Provider for ODBC Drivers error 80040e14

[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "SemnanmetWeekly" returned message "Cannot start your application. The workgroup information file is missing or opened exclusively by another user.".

/Daypish.asp, 第15行

IUSR (IISuser) 能够充分查阅Excel文档,我在链接服务器选项中采用了所有不同的选择,如匿名或查阅带有管理账户的Excel文档,但错误保持不变!

我宁愿不改变该守则,因为我只是在这一服务器上进行行政管理。它一直在开发一个老服务器,但自从我们把服务器转移到新的服务器后,它停止了工作。这里没有什么东西?

Answer 1

Not related to permissions. I think you logged in to Sql Server with Windows Authentication, everything is okay, you re the boss. But, if the connection in ASP is SQL authenticated, you get this error. So, you should add a linked server login with a query similar to following.

Exec master..sp_addlinkedsrvlogin
@rmtsrvname = N SemnanmetWeekly ,
@useself = N False ,
@locallogin = N sa , /* replace your own - same as sql server authenticated account */
@rmtuser = NULL, 
@rmtpassword = NULL

然后,你可以联系到<><>Semnanmet Weekly在您的协会申请中。

友情链接