none
How Can I to Call Sql Server 2008 Stored Procedure in Sql Server7.0

    Question

  • Hi ,All
     
    I have a problem now.This problem troubled me a long time.
    I want to call sql server 2008 stored procedure in sql server 7.0
    but I executed the following code.tell me login in failed.I am sure that username and password is right.

    exec  sp_addlinkedserver  @server='srv_lnk',@srvproduct='',@provider='sqloledb',@datasrc='10.104.16.85' 

    exec  sp_addlinkedsrvlogin  'srv_lnk','false',null,'rsa','pass@word1' 

    exec  sp_serveroption  'srv_lnk','rpc out','true'

    exec srv_lnk.RSADB.dbo.PB_GetRSAEncryptedString 'webuser', 'pass@word','2009-11-2','123.123.123.123','123.123.123.123'


    Are you any ideal?

    Thanks a lot.

    Phile.

    Friday, February 05, 2010 6:21 AM

All replies

  • I am not sure but can you try what happens when you use SQL Native client provider ?

    exec  sp_addlinkedserver  @server='srv_lnk',@srvproduct='',@provider='SQLNCLI',@datasrc='10.104.16.85' 
    Friday, February 05, 2010 6:27 AM
  • executed  next three instance is ok ,nothing wrong.
    exec  sp_addlinkedserver  @server='srv_lnk',@srvproduct='',@provider='sqloledb',@datasrc='10.104.16.85' 

    exec  sp_addlinkedsrvlogin  'srv_lnk','false',null,'rsa','pass@word1' 

    exec  sp_serveroption  'srv_lnk','rpc out','true'

    executed exec srv_lnk.RSADB.dbo.PB_GetRSAEncryptedString 'webuser', 'pass@word','2009-11-2','123.123.123.123','123.123.123.123' has some wrong that login failed!

    I not sure my code is any problem and about call procedure syntax?

     

    Friday, February 05, 2010 6:32 AM