Setting up SQL2005 with server files

[Peter12]

Found a thread to help. i'll edit this again if i get stuck lol >.<

 

[Peter12]

Backup complete.

Still can't load the DB. had no prob with sql 2000, pity it wasn't compatible with vista though.

I just get this.

Loaded client version information and server table...
Loading StdItem.DB...
[07/09/2008 20:15:58] StartTimer exception: Unspecified error

 

[Peter12]

This is getting ridiculous now, been trying to do this all day. I reckon the final problem is the ini. files. Can someone please pin point anywhere i've gone wrong and now to ammend this.

dbsrc.ini: -

[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mysql
SQLHost=JAMIE-PC\SQLEXPRESS\Databases\mir2
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword= (not inc. password in this copy and paste)
[Setup]
ServerName=Diamond
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=1
BackupTime=18000000

setup.txt.

[SQL]
UseSQL=TRUE
SQLHost=JAMIE-PC\SQLEXPRESS\Databases\mir2
SQLUsername=sa
SQLPassword= (Not included password in copy and paste)
SQLDatabase=mir2
SQLType=mysql
SQLPort=3306
SQLCharDatabase=mir2

Thanks in advance.

 

[NickMason2007]

make sure its like this :-

[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=JAMIE-PC\SQLEXPRESS
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=ur pass
[Setup]
ServerName=Diamond
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=1
BackupTime=18000000

setup.txt.

[SQL]
UseSQL=TRUE
SQLHost=JAMIE-PC\SQLEXPRESS
SQLUsername=sa
SQLPassword=ur password
SQLDatabase=mir2
SQLType=mssql
SQLPort=3306
SQLCharDatabase=mir2


that shld work

 

[Peter12]

Loaded client version information and server table...
Loading StdItem.DB...
[07/09/2008 20:49:53] StartTimer exception: OLE error 80040E4D

Thats what i get now.

Shouldn't it be mysql for 2005 not mssql (2000?)

edit. forgot to add pass on setup.ini hence the above error lol.

edit 2: right ok i've got onto the server screen now and when i go to make an account i get 'failed to create user account -1'

any ideas?

P.S. Thanks a lot nick!

 

[Killmaster]

[SQL]
SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=ur pass

change the SQLHost to localhost like above.. thats providing you are running the server files and the mssql databases off the same pc.

 

[Peter12]

[SQL]
SQLType=mssql
SQLHost=localhost
SQLPort=3306
SQLDatabase=mir2
SQLUsername=sa
SQLPassword=ur pass

change the SQLHost to localhost like above.. thats providing you are running the server files and the mssql databases off the same pc.

Changing SQLHost to localhost creates this error.

Loaded client version information and server table...
Loading StdItem.DB...
[07/09/2008 21:31:18] StartTimer exception: Unspecified error.

Also, i'm running everything off the same comp for now.
Reading the database now doesn't seem to be an issue, just making/saving an account.

 

[Dall]

How did you resolve the DB Issue ???

I've gone through this thread and changed everything to match as running the same setup yet I am still recieving the same error when loading m2server...

Cheers

 

[Mask]

honestly, dont use sql2005 it sucks. i read somewhere on here you can get 2000 to work with vista.
try searching.

 

[akacary2]

I use sql 2005 and havnt had 1 problem yet, *fingers staying crossed* :P