Server has trouble checking that the character exists.

Cataclysmic · **Joined:** Tue Jun 22, 2010 8:15 am **Posts:** 7

I am using a modified version of goremania. I removed the multiple character system and it worked fine. I ported it to an off site windows server (2008) and hooked it into the database. Everything worked fine. Now all of a sudden this is giving me trouble.

load_user

Code:

    

    'Retrieve the user from the database
    DB_RS.Open "SELECT * FROM users WHERE `name`='" & UserName & "'", DB_Conn, adOpenStatic, adLockOptimistic

    'Make sure the character exists
    If DB_RS.EOF Then
        DB_RS.Close
        Exit Sub
    End If

Is this a database problem or a code problem?

paxtenus · **Joined:** Tue Mar 17, 2009 3:48 pm **Posts:** 238

Which line is the error on, and what is the error?

Cataclysmic · **Joined:** Tue Jun 22, 2010 8:15 am **Posts:** 7

Its this line:
If DB_RS.EOF Then

It equals true when I debug it. "Data provider or other service returned an E_FAIL status."
I also get this application error from the windows server logs: "Faulting application GameServer.exe, version 1.0.0.14, time stamp 0x4c369da0, faulting module GOREsockServer.ocx, version 1.0.0.12, time stamp 0x471299dc, exception code 0xc0000005, fault offset 0x0000750b, process id 0xac0, application start time 0x01cb260d32a06c48."

paxtenus · **Joined:** Tue Mar 17, 2009 3:48 pm **Posts:** 238

That's not a GOREsock error. DB_RS.EOF means the loop has reached the end of the database. I'll see if I can figure it out later.

Richardf · **Joined:** Sun Jul 30, 2006 4:00 pm **Posts:** 1230

Is the database hosted on the same computer as the server?

Cataclysmic · **Joined:** Tue Jun 22, 2010 8:15 am **Posts:** 7

Thanks for your reply but I figured out the problem about a month ago. vbGORE does not like mySQL default values.

Richardf · **Joined:** Sun Jul 30, 2006 4:00 pm **Posts:** 1230

Ah ok. Sorry about the delayed posting. I was busy getting moved from one hell hole to my new place.

vbGore Free Online RPG Engine

Server has trouble checking that the character exists.