[DM2] Db server Problem

[Omen_lom]

Db server Problem :S

Here is the problem

NOTE: This screenshot was taken before i changed mir2 into mir23 in the dbserver text :P

Here is My DBServer Folder

And Here is the dbserv text

[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=lom2_chardb
SQLUsername=mir23
SQLPassword= Sensored :)
[Setup]
ServerName=Test
ServerAddr=127.0.0.1
ServerPor=6000
MapFile=c:\mirserver\Mir200\Envir\MapInfo.txt
ViewHackMsg=1
GateAddr=127.0.0.1
GatePort=5100
DynamicIPMode=0
BackupClearData=0
ShowItemName=1
DBName=HeroDB
[Server]
IDSAddr=127.0.0.1
IDSPort=5600
[DBClear]
Interval=1000
Level1=1
Level2=7
Level3=14
Day1=7
Day2=62
Day3=124
Month1=0
Month2=0
Month3=0
[DB]
Dir=c:\Mirserver\DBServer\FDB\
IdDir=c:\Mirserver\DBServer\FDB\
HumDir=c:\Mirserver\DBServer\FDB\
FeeDir=c:\Mirserver\DBServer\FDB\
BackupDir=c:\Mirserver\DBServer\Backup\
ConnectDir=c:\Mirserver\DBServer\Connection\
LogDir=c:\Mirserver\DBServer\Log\
[Backup]
AutoBackup=0
BackupTime=18000000

Here are the tables in enterprise manager

 

[Fire]

Re: Db server Problem :S

try using the sa login username

 

[Omen_lom]

Re: Db server Problem :S

Used sa as login name. This is what the gate gives me :S

Server Started...
-- SQL KeepAlive
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_KEEPALIVE'
-- --> Error Keeping Query Alive!
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TBL_KEEPALIVE'
-- --> Error Keeping QueryCommand Alive!
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'False' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted
[CharList] Error inserting char:OMG
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'False' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted
[CharInfo] Error inserting char:OMG
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_StatusArray'
[StatusArray] Error inserting char:OMG
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'False' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted
[CharList] Error inserting char:rgkokf
[Microsoft][ODBC SQL Server Driver][SQL Server]The name 'False' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted
[CharInfo] Error inserting char:rgkokf
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Tbl_StatusArray'
[StatusArray] Error inserting char:rgkokf

 

[Fire]

Re: Db server Problem :S

use the database and instructions provided by shunt

 

[Omen_lom]

Re: Db server Problem :S

And that is where?

i cant seem to find it

 

[Dave85]

Go here http://forum.ragezone.com/f62/ and look at the sticky threads, it explains how to setup SQL. looks to me the same as what fire said, its todo with the username which should be sa

i'd reinstall SQL following the guide and then make sure that in !setup.txt that MSSQL is set to true and that the username is set to sa, i forget if that was the only one you need to edit, its been a while >.< lol

goodluck buddeh

 

[Omen_lom]

lol thanks. i recently reinstalled MSSQL so i know that is configured correctly....

Oh ye, thanks for the link dave

Edit: Which guide did you use to get pongo online ?

 

[Omen_lom]

Ive noticed a few things about the guides that are out at the moment.

1. They arent Very good (joking lol but they arent)
2. They tell you to restore Lomchar.bak or somethin and that cant be right because there are a small amount of tables.
3. They arent well arranged. Ill make a guide myself as soon as i figure the whole thing out

Omen/

 

[Omen_lom]

ok. i managed to get it right (no thanks to the guides :P)

ill write my own up soon :P should make it easier for other ppl