Gunz 1.5 Database. Out of memory? | 1.5 MatchServer runtime error

[Dante77]

Ok, so I made a new database using Emisand's 1.5 databases but when I try to execute it, it says "Query complete with errors" at the bottom, but I can't see any errors. Then the second time I execute it, it says this:

Cannot execute script

Additional information:

Insufficient memory to continue the execution of the program. (mscorlib)

How can I fix this?

EDIT: I'm also getting a runtime error when trying to run the MatchServer.exe (1.5 server files)

log:

gameguard not running
Load XML from memory : strings.xml(0x0037) - SUCCESS
Load XML from memory : cserror.xml(0x0037) - SUCCESS
[03/25/12 12:35:23] DBMS connected


[03/25/12 12:35:23]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateServerInfo (1000, 'MatchServer1', 1)} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spUpdateServerInfo'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

[03/25/12 12:35:23] Command registeration completed


[03/25/12 12:35:23]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spGetGambleItemList} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spGetGambleItemList'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

init gamble machine fail.

[03/25/12 12:35:24]  MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spGetSurvivalGroupRanking} ), ErrCode( -1 )
ErrMsg - Could not find stored procedure 'spGetSurvivalGroupRanking'.
State:37000,Native:2812,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

Anyone?

someone please help??

[MentaL]

[Forean]

your runtime errors are due to

ErrMsg - Could not find stored procedure 'spGetGambleItemList

ErrMsg - Could not find stored procedure 'spGetSurvivalGroupRanking'


Edit :


http://www.bigresource.com/Tracker/T..._sql-OT5O9QU7/

[Dante77]

It says I have to apply SQL Server 2005 Service Pack 2. Where do I get that?

Also, I'm using SQL Server 2008, so I don't think that's the problem? Aaaand I have Service Pack 3 in my PC.

[Dante77]

Come on... this database has to work for someone...

[Forean]

The DB worked for me, never had any issues, but then again, i was using the 2005 MSSQL

[Dante77]

Damnit. Does that mean I have to redo the whole server?

[SandOfTime]

the memory is bad. try using .bak for 2005.

ErrMsg - Could not find stored procedure 'spGetGambleItemList
ErrMsg - Could not find stored procedure 'spGetSurvivalGroupRanking'
If the db restore successfull then don't have error.

[Dante77]

But the topic says that .bak files only work in 2008 R2. Should I still remove SQL 2008 and install 2005 instead?

[SandOfTime]

If you use sql 2005 try it
GunzDB.bak for 2005 by SandOfTime.rar
it is emisand's db but i patched it.

[Wucas]

Just use emisands db and then apply the patches yourself?
Posted via Mobile Device

[Dante77]

how do i open that .bak file in sql 2005? if i change the format to .sql the program can't open it.

[SandOfTime]

Restore it !!!

[Gun[Lengend]]

If is a bak file for 2005.
Create new database.
Right click in "nameofyoudata" and choose Task
Then choose Restore. Choose you location file and wait few minute.

[Dante77]

I'm getting an error when doing that.

System.Data.SqlClient.SqlError: The backup set holds a backup of a database other than the existing 'GunzDB' database. (Microsoft.SqlServer.Express.Smo)

O_O

EDIT: Nevermind, I think I fixed it. For anyone having the same problem:

When restoring the database, click on the Options button on the left side of the window and make sure the checkbox that says "Overwrite existing database" is checked.

Also, just to make sure. Is this the 1.5 database?


DAMN. Now I'm getting ANOTHER runtime error >:(

Says "Can't connect to DBMS"

[SandOfTime]

check pass sa

[Dante77]

I did type the pass correctly in server.ini and locator.ini.

Do I have to put anything in the GunzServer\Database folder?

[SandOfTime]

created odbc ?

[Dante77]

Thanks! It worked :)

AAAAAAAWWW D: NOW I CANT SEE THE SERVER IN THE LOGIN SCREEN!! T_T

If you know how to fix this check out my other topic. Thanks!