Error Code 0

[Zordon]

ok just set up my 3.55 server (bout 11th try now) and got this error code.

any1 know what it means or how to sort it?

Also got this come up in Setupchecker,

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 0 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 0 rows.
---------- Manage Database (ODBC) ----------
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
---------- Base Data Database (Direct) ----------
Base Data Database is connected successfully.
HL_Stditems table is healthy.
---------- Game Database (Direct) ----------
Game Database is connected successfully.
TBL_ABILITY has 0 rows.
---------- Hero Database (Direct) ----------
Hero Database is connected successfully.
rareitemsdata has 192 rows.
---------- SQL Checking Done ----------

any1 know how to fix?

 

[dilina]

ur stres.txt or crueldragon.ini aren't good

 

[darkkiller]

Guy I think you are doing 3.38 with 3.55 Loader wtf? see the guide guy.. or you never gonna make ur server

 

[Alecs]

he said hes making a 3.55 server but i think he changed anything in Stres.txt and he gets this error

 

[Zordon]

yeah was making a 3.38 but had too many problems with that so decided to go back to trying 3.55. thanks it was the Stres3g and the cd.ini wrong sorted that. just need to sort the other error in setup checker now,

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 0 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 0 rows.
---------- Manage Database (ODBC) ----------
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
---------- Base Data Database (Direct) ----------
Base Data Database is connected successfully.
HL_Stditems table is healthy.
---------- Game Database (Direct) ----------
Game Database is connected successfully.
TBL_ABILITY has 0 rows.
---------- Hero Database (Direct) ----------
Hero Database is connected successfully.
rareitemsdata has 192 rows.
---------- SQL Checking Done ----------

any1 know how to sort that?

got this error on loader now, any idea how to fix??

 

[Kaori]

---------- Manage Database (ODBC) ----------
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

you didn't have manager in your odbc? or it's not configured properly.

 

[Zordon]

---------- Manage Database (ODBC) ----------
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

you didn't have manager in your odbc? or it's not configured properly.

see thats the thing, checked it, done the connection test after setting it up and it comes back ok, then go to setup checker and it comes up with that error. no idea what is going on but its annoying. Tried setting it up differently and still same prob. will try again in a bit.

Any idea whats going on with the loader?

also, any1 know if this is supposed to show what it does, so many options dunno what is right :S

any idea what these problems are about?

---------- SQL Checking Start ----------
---------- Account Database (ODBC) ----------
Account ODBC is connected successfully.
TBL_ACCOUNT has 0 rows.
---------- Game Database (ODBC) ----------
Game ODBC is connected successfully.
TBL_CHARACTER has 0 rows.
---------- Manage Database (ODBC) ----------
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
---------- Base Data Database (Direct) ----------
The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
---------- Game Database (Direct) ----------
The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
---------- Hero Database (Direct) ----------
The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
---------- SQL Checking Done ----------

screen of obdc and sql database, names are exactly the same so thats not a prob.

 

[Kaori]

Manage ODBC DSN
you are typing "Manage" right?

 

[Zordon]

yes of course i am typing manage lol why wouldnt i be? any idea what the java.net connection exception thing is about?

 

[Kaori]

yes of course i am typing manage lol why wouldnt i be? any idea what the java.net connection exception thing is about?

because you have been pasting this, so I assume you didn't put "manage" properly
---------- Manage Database (ODBC) ----------
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

and about your "Connection refused: connect"
your sql server is down or not accepting TCP connection or your config is wrong again.

 

[Zordon]

because you have been pasting this, so I assume you didn't put "manage" properly
---------- Manage Database (ODBC) ----------
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

and about your "Connection refused: connect"
your sql server is down or not accepting TCP connection or your config is wrong again.

right, so how do i check the config is right in sql/obdc then? nothing i do seems to make any difference so any help sorting it would be appreciated.

 

[Kaori]

screenshot of the setup checker.

 

[Zordon]

omg in setup checkr it had 3G at the end of manage, lol didnt even notice it til now :| lol what a stupid thing to miss. any idea how to sort the jave.net connection exception?

 

[Kaori]

ok the next step is to check if your sql server is running

cmd
netstat -na | find "1433"

 

[Zordon]

ok the next step is to check if your sql server is running

cmd
netstat -na | find "1433"

ok ran command prompt, typed netstat -a got this...

ran command prompt, typed netstat -n got this...

 

[Kaori]

You didn't follow my instruction!
I said -na not -n not -a

Anyway...
I don't see 1433, so that means your SQL Server is not started OR your SQL Server is not setup to listen to 1433.

Check Network configuration:
right click the server in enterprise manager
properties
network configuration.

 

[Zordon]

command prompt -na result.

sql network config.

 

[Kaori]

is this the sqleval?

stop the sql server and start again

check event viewer in
control panel
administrative tools
event viewer
application log
anything related to sql?

 

[Zordon]

ok done that and found this:

Error:15457, Severity 0, State 1.
Configuration option "show advanced options" changed from 1 to 1. Run the RECONFIGURE statement to install.

For more information see Help and Support Centre at
http://go.microsoft.com/fwlink/events.asp

 

[Kaori]

don't think that's the event I am hoping for...
date/time is old right?

restart computer
wait until sql server starts.

then run the netstat -na to see if 1433 is there.