CruelDragon3GBaseData error?

[crispous]

Hi all.

I have problem with server files 3.56.

On running "CD3.55Crack.exe" or "CruelDragonMir3G.exe" i have an error:

I tried to delete CruelDragon3.ini, tried to set value in that file:
数据库名=CruelDragon3GBaseData
and even: 数据库名=CruelDragon3BaseData (without G)
Even i tried to make both options of databases:

But it's still the same. Anyone know why?

And usually after press OK on error, after about 2-3 seconds, IEserver's window is opening for less then 1 second and in log i see that it tried to connect to gates.

Here is screen from all gates:

P.S.
Of course all paths, IPs and everything else are changed for my needs. In CruelDragon3g.ini i have changed values of

服务器IP=(mylocalipforsql)
登陆帐户=sa
登陆密码=(mypass)

Maybe should i change something else in other places?

 

[Ashran]

Did you make the ODBC setup?

 

[crispous]

Yes, of course. For both versions (with and without G).

I'm running gates in order of:
- loginsvr
- dbsvr
- gamegate (rungate)
- selgate
- mirlogin
And then i'm trying run CruelDragonMir3G.exe. Maybe am i doing something wrong?

Here i'm sharing screens of my 2 basic configs:
DBsvr:

And Loginsvr:

I think, everything is fine, but am i right?

PS: UPDATE:
I have found a mistake. I had databases CruelDragon3(g)BaseDat"E"... Should be "A", but i have changed that for CruelDragon3GBaseData and error still shows.

PS2.
I tried to change value in CruelDragon3G.ini with that CruelDragon3GBasaData for something else, and...

数据库名=qwerty

Guess what.

It still shows:

I was sure that i will show error with "qwerty" not CruelDragon3GBaseData.

Maybe my CruelDragon3G.exe is loading different file than i'm editing?
I have server files in E:\Mud3 and i'm editing E:\Mud3\CruelDragon3G.ini. Is that fine? Or maybe should I check any other file? Maybe in %WINDIR% or something?

 

[Kaori]

that error means your CruelDragon3G.ini is not correct or your SQL server is configured properly.

use this tool to check if your sql is setup correctly.

http://www.kaorimir.com/KaoriMir3SetupChecker/

 

[crispous]

I have checked SQL and i got:

---------- 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) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Charset 0x0408D00000/MS936 is not supported by the JVM.
---------- Game Database (Direct) ----------
Charset 0x0408D00000/MS936 is not supported by the JVM.
---------- Hero Database (Direct) ----------
Charset 0x0408D00000/MS936 is not supported by the JVM.
---------- SQL Checking Done ----------

Is see that really something is wrong with sql, but what? What does it mean not supported by JVM? What is JVM? Is it Java Virtual Machine? If yes, so maybe SQL is ok, but Java can't check that?

 

[Ashran]

JVM is Java Virtual Machine, as you say. Anyway, I would check again these DB (CruelDragon, Hero3G, Game3G)

 

[crispous]

But what to check? I can read all those databases, but all are chinese, so i don't know what can be wrong there;/

Could someone share me 100% working (and english) those 3 databases?

Edit:
I have some idea... As I see, there are problems with reading MSSQL DB by setup checker... ODBC are fine. So, maybe i have wrong set MSSQL access (login and/or pass)? I have entered pass for sa on MSSQL install, but maybe it have been not saved.

Where or how can i check MSSQL DB password?

P.S.
As I remember, MSSQL should use my system's password, but where can i check, does it use them?

 

[Ashran]

MSSQL should'nt use your system pass, you set it when you installed SQL??
Check if you followed the guides!

 

[crispous]

Hm probably yes, because there was no option to use only sql pass. But i have set the same passwords for system and sql.

 

[Ashran]

http://www.dreamscape-servers.co.uk/mir3/mssql6.html
Use mixed mode

 

[crispous]

http://www.dreamscape-servers.co.uk/mir3/mssql6.html
Use mixed mode

I have that... So, what else can be cause of problem?

P.S.
I can run server 3.38 on these databases but without crueldragon. I have problem only on running crueldragon. Even on version 3.38.

P.S.2.
I seen somewhere post, where is answer, how to fix problem with no-level seeing and cannot drop anything... But i'm searching and searching and can't find... Where was that?;/

 

[Amenovis]

mhh as you restored the CD3g DB did you also changed under options the right path ? as i remember it looks correctly but it was not copy the right path there also unimportant how it looks

ohh and check the colum names after restoring in std.items and monster db if there is really sc

i had that trouble also one time from restoring cause he renamed colum name to S_ and not SC

if you have that (what i not belive mostly the cd.exe see that and write it as error) write again it is easy to solve

 

[crispous]

mhh as you restored the CD3g DB did you also changed under options the right path ? as i remember it looks correctly but it was not copy the right path there also unimportant how it looks

Which path do You mean? This one?

If yes, yes i have changed that path to my own.

ohh and check the colum names after restoring in std.items and monster db if there is really sc

i had that trouble also one time from restoring cause he renamed colum name to S_ and not SC

if you have that (what i not belive mostly the cd.exe see that and write it as error) write again it is easy to solve

Here you can see structure of my HL_Stditems. There are no any columns SC, but Sac... Is that ok?

CruelDragon3GBaseData,dbo,HL_Stditems,Idx,1,NULL,No ,int,NULL,NULL,10,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Name,2,NULL,YES,varchar,30,30,NULL,NULL,NULL,NULL,NULL,NULL,cp936,NULL,NULL,Chinese_PRC_CI_AS,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Stdmode,3,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Shape,4,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Weight,5,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,CharLooks,6,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Anicount,7,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Source,8,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Reserved,9,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Throw,10,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Looks,11,NULL,YES,int,NULL,NULL,10,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,DuraMax,12,NULL,YES,int,NULL,NULL,10,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Ac,13,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Ac2,14,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Mac_Type,15,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Mac,16,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Mac2,17,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Dc,18,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Dc2,19,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Sac,20,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Sac2,21,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Mc_Type,22,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Mc,23,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Mc2,24,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Func_Type,25,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Func,26,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Amulet,27,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Need,28,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,NeedLevel,29,NULL,YES,smallint,NULL,NULL,5,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Price,30,NULL,YES,int,NULL,NULL,10,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,Stock,31,NULL,YES,int,NULL,NULL,10,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,DisappearTime,32,NULL,YES,int,NULL,NULL,10,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,NeedFame,33,NULL,YES,int,NULL,NULL,10,10,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
CruelDragon3GBaseData,dbo,HL_Stditems,OrgName,34,NULL,YES,varchar,30,30,NULL,NULL,NULL,NULL,NULL,NULL,cp936,NULL,NULL,Chinese_PRC_CI_AS,NULL,NULL,NULL

And HL_Monster:

CruelDragon3GBaseData dbo HL_Monster Name 1 NULL No varchar 18 18 NULL NULL NULL NULL NULL NULL cp936 NULL NULL Chinese_PRC_CI_AS NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Race 2 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster RaceImg 3 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Appr 4 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Lvl 5 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Undead 6 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Tameble 7 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Wz1 8 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster CoolEye 9 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster VenomDc 10 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Exp 11 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster HP 12 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster MP 13 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Wz2 14 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Wz3 15 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Ac 16 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster FireMAC 17 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster IceMAC 18 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster LightMAC 19 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster WindMAC 20 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster HolyMAC 21 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster DarkMAC 22 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster PhantomMAC 23 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Dc 24 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster DcMax 25 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster McType 26 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Mc 27 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster McMax 28 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Speed 29 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Hit 30 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster WALK_SPD 31 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster WalkWait 32 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster WalkStep 33 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster ATTACK_SPD 34 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Wz4 35 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster Wz5 36 NULL YES int NULL NULL 10 10 0 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster UnKnow 37 NULL YES varchar 78 78 NULL NULL NULL NULL NULL NULL cp936 NULL NULL Chinese_PRC_CI_AS NULL NULL NULL
CruelDragon3GBaseData dbo HL_Monster OrgName 38 NULL YES varchar 19 19 NULL NULL NULL NULL NULL NULL cp936 NULL NULL Chinese_PRC_CI_AS NULL NULL NULL

EDIT:
Problem solved. The problem was sql server name/address. In ODBC i have typed my computer's name/address, but should be "(local)" as in SQL. And the same in cruel's .ini

Now i can glory that it works (is run)... I'm fighting with some other problems, but i seen those problem on forum, so I try to solve it myself.

But, the only thing is... Where can i find english 3.56 server files and english crueldragon databases? On forum i found only few basic translations like part of cruel's .ini, etc.. But where to find english databases for 3.56?

 

[TheDayIDie]

---------- 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) ----------
Manage ODBC is connected successfully.
---------- Base Data Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Game Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- Hero Database (Direct) ----------
Network error IOException: Connection refused: connect
---------- SQL Checking Done ----------

i got this error whilst running the Kaori's Mir3 Checker, anybody know how to fix? much appreciated