[2.3] DBSERVER Error

[Xx69xX]

Hi all,

just messing around with some files and i have come across an error which is normally quite an easy fix, the only problem is, im using SQL 2000 rather than SQL 2005.

MY DBServer keeps

'Gate disconnected
Gate connected
Gate disconnected
Gate connected
Gate disconnected'

I realise the error is in the dbsrc file, im just not really sure what to change, from reading around i have found that it is usually to do with the SQLHost=.
Only problem is im not sure what im supposed to change it to.. i realise with SQL2005 it would be SQLHost=DAN_PC\SQLEXPRESS but with 2000 iv tried all these things + the basic (local) + 127.0.0.1

so does any1 know what im doing wrong???

Heres my DBSRC file

[Reg]
Key=0123456789
ServerAddr=127.0.0.1
ServerPort=60320
[SQL]
SQLType=mssql
SQLHost=DAN-PC\SQLEXPRESS
SQLPort=3306
SQLDatabase=lom2
SQLUsername=sa
SQLPassword=sa
[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

Thanks in advance

Dan

---------- Post Merged at 08:17 PM ---------- Previous Post was at 05:53 PM ----------

Iv been trying loads of different things for the past 3 hours and cant find a solution!!!

Any help out there????

iv got the correct ips in all the correct places, the passwords are correct! im just stuck, i know i once had this problem before but i cannot find the fix anywhere! iv tried reinstalling my DB and no luck!

---------- Post Merged at 09:33 PM ---------- Previous Post was at 05:53 PM ----------

Bump

Still stuck

 

[Tom27]

Check that your DB is linked up correctly with SQL, and the passwords/DB Names are the same which link them both up (including in the ini files).
This is often the problem.