[HELP]Database Ranking

06/17/2014 05:22 Wezzy_Dev#1
HOw to fix this error






2014/06/17 11:21:09
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]VIA Provider: The specified module could not be found.


2014/06/17 11:21:09
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "Login timeout expired".
2014/06/17 11:21:09
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:01000 error:[Microsoft][SQL Native Client][SQL Server]OLE DB provider "SQLNCLI" for linked server "RANKING" returned message "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.".
06/17/2014 12:08 banktakung#2
linked the ranking DBF
06/17/2014 13:44 CrackTex#3
[Only registered and activated users can see links. Click Here To Register...]
06/20/2014 12:55 - DK#4
[Only registered and activated users can see links. Click Here To Register...] Easy Way #
06/20/2014 18:01 Wezzy_Dev#5
Quote:
Originally Posted by Armageddon' View Post
[Only registered and activated users can see links. Click Here To Register...] Easy Way #
nothing happen sir =(

ScreenShot: [Only registered and activated users can see links. Click Here To Register...]
06/20/2014 19:40 CrackTex#6
Quote:
Originally Posted by Wezzy_Dev View Post
nothing happen sir =(

ScreenShot: [Only registered and activated users can see links. Click Here To Register...]
Make it on the Sourceway.. this will works 100%
06/20/2014 19:48 xTwiLightx#7
Quote:
Originally Posted by Wezzy_Dev View Post
nothing happen sir =(

ScreenShot: [Only registered and activated users can see links. Click Here To Register...]
Drop the old linked server
->
Code:
EXEC master.dbo.sp_dropserver @server=N'RANKING', @droplogins='droplogins'
GO
If you still have issues, use my guide - should work fine then.
06/20/2014 20:18 Wezzy_Dev#8
Quote:
Originally Posted by xTwiLightx View Post
Drop the old linked server
->
Code:
EXEC master.dbo.sp_dropserver @server=N'RANKING', @droplogins='droplogins'
GO
If you still have issues, use my guide - should work fine then.
last time i use your guide but same problem =( i hope this one sir it helps thanks for helping.