I think Serus forget a important thingie.
You need to add some sys.servers.
Execute that code to add RANKING, ACCOUNT, CHAR to sys.servers:
Add linked server "RANKING"
Code:
exec sys.sp_addlinkedserver 'RANKING', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'RANKING_DBF'
exec sys.sp_serveroption @server='RANKING', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='RANKING', @optname='rpc out', @optvalue='true'
Add linked server "ACCOUNT"
Code:
exec sys.sp_addlinkedserver 'ACCOUNT', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'ACCOUNT_DBF'
exec sys.sp_serveroption @server='ACCOUNT', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='ACCOUNT', @optname='rpc out', @optvalue='true'
Add linked server "CHR01"
Code:
exec sys.sp_addlinkedserver 'CHR01', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'CHARACTER_01_DBF'
exec sys.sp_serveroption @server='CHR01', @optname='rpc', @optvalue='true'
exec sys.sp_serveroption @server='CHR01', @optname='rpc out', @optvalue='true'
If you want enable Guild Rankings @ Juria, just create a ODBC Native Client for MANAGE_DBF
Synaptic~
原帖由 ☆魔鬼皇☆ 於 10-5-14 06:19 PM 發表
唔識俾分你 標題沒列入加分項 請留意以下連結內說明再作修改你的主題是邊一門:
http://www1.2000fun.com/bbs/redi ... o=lastpost#lastpost
歡迎光臨 2000FUN論壇 (https://www.2000fun.com/) | Powered by Discuz! X1.5.1 |