1.In strore procedure:
SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0',
'Data Source="\\10.100.111.111\dd\phoneex.mdb";User
ID=Admin;Password=')...CallFlow
2.the system show me information:
Mine failed with error: "Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.
[OLE/DB provider returned message: Unrecognized database format
'c:\temp\authors.xls'.]
OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0'
IDBInitialize::Initialize returned 0x80004005: ].

3.i login the sql server with sa

Let's see if the following article helps:

PRB: Error 7399 When You Run a Linked Server Query That Uses the OLE DB
Provider for Microsoft Jet

http://support.microsoft.com/default...b;en-us;814398

Thanks,

Lan Lewis-Bevan
MS SQL support

This posting is provided "AS IS" with no warranties, and confers no rights.