Help with this

[Kirk John Sales]

Error runing Certifier
2013/06/25 07:18:56
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/25 07:19:04
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/25 07:19:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/25 07:19:06
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/25 07:19:06
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/25 07:19:07
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/25 07:19:07
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/25 07:19:08
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

 

[raventh1984]

You need to configure the ODBC.

in windows click on start and run and type in odbc then you see the program.

If you cant find it search google. ragezone flyff about odbc.

 

[Kirk John Sales]

You need to configure the ODBC.

in windows click on start and run and type in odbc then you see the program.

If you cant find it search google. ragezone flyff about odbc.

i already did this login character log ranking

 

[raventh1984]

its

login
character01
log01
ranking

Als check your CQuery log file. Then you now what is wrong with it

 

[Kirk John Sales]

its

login
character01
log01
ranking

Als check your CQuery log file. Then you now what is wrong with it

sorry im LAZY to type 01 when im posting i already did the same what could be the problem?

 

[raventh1984]

Did you use Windows Authentication or the one with sa and password?

 

[Kirk John Sales]

in MSSQL 2005 i use sa and password in odbc i use windows authentication

 

[Kirk John Sales]

Server log

2013/06/26 00:39:09query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:39
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:40
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:41
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:42
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:42
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:43
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:43
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:44
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:00
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2013/06/26 00:40:00
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".
2013/06/26 00:40:00
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.".
2013/06/26 00:40:04
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:06
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:06
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:07
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:43:10
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:43:12
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:46:44
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

2013/ 6/26 00:40:12 OP: 23640217, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0



2013/ 6/26 00:40:22 CDbManager::UpdateGuildRanking¿¡¼­ (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ


2013/ 6/26 00:40:46 OP: 33469, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:40:46 LUA - Event - ID:1, Title:Flyff-v19, State:1


2013/ 6/26 00:42:10 TRANS : is not alive


2013/ 6/26 00:42:40 OP: 23788330, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:43:22 OP: 41372, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:43:22 LUA - Event - ID:1, Title:Flyff-v19, State:1


2013/ 6/26 00:44:06 OP: 43479, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:44:24 ping CORE - 44, trans:2013/06/26 00:43:40


2013/ 6/26 00:44:24 ping TRANS - 44, trans:2013/06/26 00:43:41


2013/ 6/26 00:44:26 OP: 20718, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:44:30 OP: 4154, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:46:27 OP: 1554, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:47:49 OP: 2388, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0

Client log

Wed Jun 26 00:46:43 2013
0 - CERT_CONNECTED
Wed Jun 26 00:46:44 2013
3 - CERT_ERROR
protocol error:136
Wed Jun 26 00:46:44 2013
15 - CERT_DISCONNECT
network error:64

2013/ 6/26 00:42:56 FileName Music\default.bgm(69) : BGM_BA_FWC Not Found. : BGM_BA_FWC "music\BgmColosseoumMain.ogg"






//»êÇÁ·¹½º Àú·¾ °í·¾


BGM_DU_SANPR


2013/ 6/26 00:42:56 FileName Music\default.bgm(72) : BGM_DU_SANPRES Not Found. : BGM_DU_SANPRES "music\BgmDuSanpres.ogg"


//À¯ÇÁ·¹½Ã¾Æ Àú·¾ °í·¾


BGM_DU_UPRE


2013/ 6/26 00:42:56 FileName Music\default.bgm(74) : BGM_DU_UPRESIA Not Found. : BGM_DU_UPRESIA "music\BgmDuUpresia.ogg"


//Ç츣³×¿À½º Àú·¾ °í·¾


BGM_DU_HERN


2013/ 6/26 00:42:56 FileName Music\default.bgm(76) : BGM_DU_HERNEOS Not Found. : BGM_DU_HERNEOS "music\BgmDuHerneos.ogg"


2013/ 6/26 00:46:33 FileName Music\default.bgm(69) : BGM_BA_FWC Not Found. : BGM_BA_FWC "music\BgmColosseoumMain.ogg"






//»êÇÁ·¹½º Àú·¾ °í·¾


BGM_DU_SANPR


2013/ 6/26 00:46:33 FileName Music\default.bgm(72) : BGM_DU_SANPRES Not Found. : BGM_DU_SANPRES "music\BgmDuSanpres.ogg"


//À¯ÇÁ·¹½Ã¾Æ Àú·¾ °í·¾


BGM_DU_UPRE


2013/ 6/26 00:46:33 FileName Music\default.bgm(74) : BGM_DU_UPRESIA Not Found. : BGM_DU_UPRESIA "music\BgmDuUpresia.ogg"


//Ç츣³×¿À½º Àú·¾ °í·¾


BGM_DU_HERN


2013/ 6/26 00:46:33 FileName Music\default.bgm(76) : BGM_DU_HERNEOS Not Found. : BGM_DU_HERNEOS "music\BgmDuHerneos.ogg"

 

[Kirk John Sales]

Server log

2013/06/26 00:39:09query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:39
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:40
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:41
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:42
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:42
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:43
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:43
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:39:44
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:00
query:RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01'
SQLSTATE:42000 error:[Microsoft][SQL Native Client][SQL Server]Named Pipes Provider: Could not open a connection to SQL Server [2].
2013/06/26 00:40:00
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".
2013/06/26 00:40:00
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.".
2013/06/26 00:40:04
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:05
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:06
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:06
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:40:07
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:43:10
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:43:12
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
2013/06/26 00:46:44
query:login
SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

2013/ 6/26 00:40:12 OP: 23640217, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0



2013/ 6/26 00:40:22 CDbManager::UpdateGuildRanking¿¡¼­ (RANKING.RANKING_DBF.dbo.RANKING_STR 'R1','01') ½ÇÆÐ


2013/ 6/26 00:40:46 OP: 33469, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:40:46 LUA - Event - ID:1, Title:Flyff-v19, State:1


2013/ 6/26 00:42:10 TRANS : is not alive


2013/ 6/26 00:42:40 OP: 23788330, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:43:22 OP: 41372, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:43:22 LUA - Event - ID:1, Title:Flyff-v19, State:1


2013/ 6/26 00:44:06 OP: 43479, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:44:24 ping CORE - 44, trans:2013/06/26 00:43:40


2013/ 6/26 00:44:24 ping TRANS - 44, trans:2013/06/26 00:43:41


2013/ 6/26 00:44:26 OP: 20718, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:44:30 OP: 4154, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:46:27 OP: 1554, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0




2013/ 6/26 00:47:49 OP: 2388, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0

View attachment 133542

Client log

Wed Jun 26 00:46:43 2013
0 - CERT_CONNECTED
Wed Jun 26 00:46:44 2013
3 - CERT_ERROR
protocol error:136
Wed Jun 26 00:46:44 2013
15 - CERT_DISCONNECT
network error:64

2013/ 6/26 00:42:56 FileName Music\default.bgm(69) : BGM_BA_FWC Not Found. : BGM_BA_FWC "music\BgmColosseoumMain.ogg"






//»êÇÁ·¹½º Àú·¾ °í·¾


BGM_DU_SANPR


2013/ 6/26 00:42:56 FileName Music\default.bgm(72) : BGM_DU_SANPRES Not Found. : BGM_DU_SANPRES "music\BgmDuSanpres.ogg"


//À¯ÇÁ·¹½Ã¾Æ Àú·¾ °í·¾


BGM_DU_UPRE


2013/ 6/26 00:42:56 FileName Music\default.bgm(74) : BGM_DU_UPRESIA Not Found. : BGM_DU_UPRESIA "music\BgmDuUpresia.ogg"


//Ç츣³×¿À½º Àú·¾ °í·¾


BGM_DU_HERN


2013/ 6/26 00:42:56 FileName Music\default.bgm(76) : BGM_DU_HERNEOS Not Found. : BGM_DU_HERNEOS "music\BgmDuHerneos.ogg"


2013/ 6/26 00:46:33 FileName Music\default.bgm(69) : BGM_BA_FWC Not Found. : BGM_BA_FWC "music\BgmColosseoumMain.ogg"






//»êÇÁ·¹½º Àú·¾ °í·¾


BGM_DU_SANPR


2013/ 6/26 00:46:33 FileName Music\default.bgm(72) : BGM_DU_SANPRES Not Found. : BGM_DU_SANPRES "music\BgmDuSanpres.ogg"


//À¯ÇÁ·¹½Ã¾Æ Àú·¾ °í·¾


BGM_DU_UPRE


2013/ 6/26 00:46:33 FileName Music\default.bgm(74) : BGM_DU_UPRESIA Not Found. : BGM_DU_UPRESIA "music\BgmDuUpresia.ogg"


//Ç츣³×¿À½º Àú·¾ °í·¾


BGM_DU_HERN


2013/ 6/26 00:46:33 FileName Music\default.bgm(76) : BGM_DU_HERNEOS Not Found. : BGM_DU_HERNEOS "music\BgmDuHerneos.ogg"

 

[Kirk John Sales]

Bump!!