Login Server sql error

[DemDem]

http://www.putfile.com/pic.php?img=5158484

Thats the error, I am annoyed and haven't slept all night. I followed Heavensent's guide. Got ingame but I wasn't admin and I had added myself to the admin table. Most probably because I ran it normal, not as an SQL server with Login Server SQL and all the things with SQL true and db name etc on.

My database name is diamondm2
And this is how I have it set out.
[SQL]
UseSQL=TRUE
SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=diamondm2
SQLUsername=sa
SQLPassword=********** (Not actual password but I don't think I should post it o.0)

Is that right? Or not? lol

I have it in....
C:\Lomcn_m2\Trunk\Release\LoginSrvSQL\!dbsetup.txt
C:\Lomcn_m2\Trunk\Release\DBServer\Dbsrc.ini
C:\Lomcn_m2\Trunk\Release\M2Server\!Setup.txt

This is what the top of my setup looks like, it looks funny so I thought I would post see if it is right.

[SQL]
UseSQL=TRUE
SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=diamondm2
SQLUsername=sa
SQLPassword=********** (Not actual password but I don't think I should post it o.0)

[Setup]
SQLPort=3306
ItemNumber=744405
ItemNumberEx=1073741824
ClientFile1=mir.exe
ClientFile2=mir2.exe
ClientFile3=mir3.exe
MonUpLvNeedKillBase=100
MonUpLvRate=16

I am using the files provided in Heavensents thread. So can anyone tell me what the hell I am doing wrong lol?

 

[DemDem]

Ok I think I have got the thing right in !setup.txt because this is what I have

Right at the bottom:

Dragon9=
[SQL]
UseSQL=True
SQLHost=127.0.0.1
SQLPort=3306
SQLUsername=sa
SQLPassword=**********
SQLDatabase=diamondm2
SQLType=mysql


Ok and now I get this error message on my m2server so It must be doing something.

http://www.putfile.com/pic.php?img=5158595

Please help lol, this is rather annoying.

 

[koni]

thats correct, iam asuming you have imported the database into sql from the previous format (access) i believe ?

 

[DemDem]

thats correct, iam asuming you have imported the database into sql from the previous format (access) i believe ?

Yes sir, first thing I did.

Also how do I delete entries in the SQL tables..There are like 10 different Admins and I want to delete all of them and make 2 more. I made 2 more, but when I scroll all the admins for try one a t a time it comes up with an error saying it can't delete them beause it will effect too many other rows? o.0

But I don't care about that atm, I just want server running with SQL.

Any other ideas?

 

[jasper]

to delete rows from sql, here is how i do it, there may be quicker or more correct ways, but hey ho.
open up enterprise manager, expand the tree to show your database
click tables, so that all that database tables are shown in the right pane
find tbl_admin
right click on it, and then from drop down box "open table" and return all rows
this then opens up the selected table, and rows can be deleted the same as they would in excel
right click on the left border (where the arrow is and *) and then delete that line, or lines

 

[Xx69xX]

Ok I think I have got the thing right in !setup.txt because this is what I have

Right at the bottom:

Dragon9=
[SQL]
UseSQL=True
SQLHost=127.0.0.1
SQLPort=3306
SQLUsername=sa
SQLPassword=**********
SQLDatabase=diamondm2
SQLType=mysql


Ok and now I get this error message on my m2server so It must be doing something.

http://www.putfile.com/pic.php?img=5158595

Please help lol, this is rather annoying.

i just got online with the files u sent me

ill walk you throught it when u bk

i hope im still online when ur bk coz i got work tomoz