[HELP]SQL

[kaique21]

someone could help me because it has this error not understand?

[HellSpider]

Originally Posted by kaique21

someone could help me because it has this error not understand?

Check all config files for right IP, right DB username and DB password.

[conquer93]

The oledb errors are cus u did not add the query codes to your sql look at the dekaron ultimate tutorial it explains u ther how to add it

[Schucodk]

I have kind of the same problem

[alexmak96]

check the config on cast.exe

[conquer93]

U forgot this codes in ur sql query

code 1:



Use master;
Go
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={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL 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={SQ L 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=;'Q-2

Code2 :

Use master;
Go
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'

[Schucodk]

I still cant get it to run...

There is an image below:


Thank You.

[alexmak96]

lemme see your cast.exe config

[Schucodk]

;
CAST_PORT = 7882
DATABASE_ADDRESS = 127.0.0.1,1433
DATABASE_DATABASE = CHARACTER
DATABASE_ACCOUNT = account
DATABASE_PASSWORD = account
CAST_SERVER_ID = 1101
LOG_PATH = ..\LogFiles\

[Trac3r]

at database address why do you have the ,1433?

Try removing that and start it again

[Schucodk]

But now there is a other error, not in the server console, but in WebMan.
something about ELD Socket error in activate...

and when i try to login, I get a message about i need to check the network.

BTW thaks trac3r

[conquer93]

Originally Posted by Schucodk

But now there is a other error, not in the server console, but in WebMan.
something about ELD Socket error in activate...

and when i try to login, I get a message about i need to check the network.

BTW thaks trac3r

The ,1433 is normal ... I also have it in my config files and doesn work without it ao put it back to normal ^.^

[Schucodk]

Ahhh... okay.

Anyone have any other advice with my error...?

[conquer93]

arr u 100% sure u loged in ur account u use for dekaron at SQL and added the 2 query codes i posted ? without the codes it wont work and i think this is ur problem.
and if it aint the query then it is ur ODBC follow the tutorial of ultimate dekaron tut. its good tut to understand !

[Schucodk]

I think its the ODBC, but i dont understand it... can you help me with it?