MSSQL - Help

[CandyMan]

Hi. Well i think its MSSQL thats the problem. Im most likely to be wrong though.
Heres what happend:
-------------------

I formatted my PC, Saving my 2.3 files on my D:/ + my DB
I put them back onto the computer, re-downloaded mssql 2000
Restored my database, Ran the gates as normal. under ip addr 127.0.0.1

It lets me logg into my account, But it wont show my character, or let me create a new character.
Any ideas?

 

[littletommy]

that is something to do with your select gate/gamegate are you sure that u have set up SQL properly ??

 

[CandyMan]

Yeah its all correct, Passwords etc are all correct. I've re-installed it to make sure.

Now the Dbserver is giving me an error

"TFrmDBSrv.starttimer"

Any ideas?

 

[littletommy]

thats 3 of you i no who are getting that error i think it is the exe that you have used try useing a brand new DB file ill will relese 1 to you if u want a decnt 1, it should work


only if u need 1 tho

 

[CandyMan]

Okay, ive got a new dbserver, and still no luck.
Im on windows vista ultimate.

Ive installed mssql 2000 + 2005,
Done something with sync center which normally makes it work but im having no luck.

Any ideas??

 

[jasper]

it still isnt connecting to the sql server with that error,, when you open up sql server2005 what is the server name you connect to on the connect to server window,, use that name for the for the sqlhost in dbsrv.ini ect.

SQLType=mssql
SQLHost=jasper-pc
SQLPort=3306
SQLDatabase=lom2
SQLUsername=sa
SQLPassword=********

 

[Hazuki]

In SQL Server 2005 the host name is set out as follows:

COMPUTERNAME\SQLINSTANCENAME

Computername: Being your computer name
SQLInstance: Being what you set when setting up SQL Server 2005. SQL 2000 sets this to default by default, im not sure what 2005 sets it to.

Try adding this as your host .

/Haz

-edit-
On another note, your port is wrong for mssql, 3306 is the mysql port. The default port for mssql is 1433.