[HELP]SQL

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

[Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by kaique21 someone could help me because it has this error not understand? [Only registered and activated users can see links. Click Here To Register...]

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

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

I have kind of the same problem

check the config on cast.exe

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'

I still cant get it to run...

There is an image below:
[Only registered and activated users can see links. Click Here To Register...]

Thank You.

lemme see your cast.exe config

;
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\

at database address why do you have the ,1433?

Try removing that and start it again

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 :)

Quote:

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 ^.^

Ahhh... okay.

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

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 ;)!

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