[help]ODBC problem ?

[vinyerna]

Hello, i would say great thanks for the server files,

But if someone can help me with this problem,

thank you for help

 

[Daffchilly]

It's a session server problem? After setting up your database, did you execute this in the Query Analyzer?

EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'

exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'

Ah and not to forget, you have to use service pack 4 for sql 2000 otherwise it won't work..


Greets and good luck!

 

[vinyerna]

don't work ,

Someone can make a .reg for create the odbc ?

Thank you.

 

[Booms]

1.You need allow remote access for sql. (properties of SQL/Connections)
2.Disable firewall for SQL access. (depends of firewall, if standart turn it off)
3.ODBC only need Account (attached)

 

[vinyerna]

I tried, it's when i launch "sessionserver" like "5th" link


and i have it in my event.log

Session Server Start
>> [ 10B43048 ][ 192.168.5.7 ]--- Server Connected ---
>> [ 10B43084 ][ 192.168.5.7 ]--- Server Connected ---
>> [ 11CF3738 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3738 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 10B43084 ][ 192.168.5.7 ]--- Server Disconnected ---
>> [ 10B43048 ][ 192.168.5.7 ]--- Server Connected ---
>>SP_LOGIN_FLAG_SET CALL SUCCESS : UserCount = [0]
Session Server Start
>> [ 10B43084 ][ 192.168.5.7 ]--- Server Connected ---
>> [ 11CF3738 ][ 456025 ] BL_IF_BuyProc_CRU FAIL
>> [ 11CF3C20 ][ yl2008 ] CREATE CHARACTER FAIL
>> [ 11CF3C20 ][ yl2008 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3C20 ][ yl2008 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3738 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3C20 ][ yl2008 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3C20 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3738 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3C20 ][ yl2008 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3C20 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3738 ][ yl2008 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3738 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3738 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3C20 ][ yl2008 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3C20 ][ 456025 ] OnClose in STATE : CHECKOUTED
>> [ 11CF3738 ][ yl2008 ] OnClose in STATE : CHECKOUTED
>> [ 10B43084 ][ 192.168.5.7 ]--- Server Disconnected ---
>> [ 10B43048 ][ 192.168.5.7 ]--- Server Disconnected ---
>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
>> CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL




And why that's again this ip 192.168.5.7 ] ??? :s


Anyone can help me ? :'(

 

[BladeCX]

Try using the old files from tinkle, that ip is somewere in your ini files and you forgot to edit it check a bit more your files. If you cant manage with those, use the first files tinkle released those are the most stable for starting with.

 

[vinyerna]

mmm, this old files don't work (can"t find DB ...)



But with this new files, I will wait a tuto for look if i have make all right.


* Can say me all files, where i need change IP ?
dkserver\Cast\config.ini
dkserver\DekaronServer\config.ini
dkserver\Login\config.ini
dkserver\Session\config.ini


* Why when i start webMan.exe?

i have 0.0.0.0:80.

thanks