Thursday, February 16, 2012

Access linked server

I am new to SQL. I am trying to setup a linked server but whenever I try to
view the tables it gives me an error saying
error 7399 : OLEDB provider 'microsoft.jet.oledb. 4.0' reported an error
OLEDB Error Trace
ThanksHi,
have you linked a server using
sp_addlinkedserver and after that have you map logins for and from both
server in order to access it properly using
sp_addlinkedsrvlogin
read BOL for more on this .
Andy Davis
Active Crypt Team
---
SQL Server Encryption Decryption Software
http://www.activecrypt.com
activecrypt@.gmail.com
"Amit" wrote:

> I am new to SQL. I am trying to setup a linked server but whenever I try t
o
> view the tables it gives me an error saying
> error 7399 : OLEDB provider 'microsoft.jet.oledb. 4.0' reported an error
> OLEDB Error Trace
> Thanks

No comments:

Post a Comment