Trying to set up an online high score database...

Hey, folks!

I'm trying to set up an online high score database for a game. I'm using Jeff Vance's "Easy Online Score" tutorial and an internal test server.

While trying to use his example MMF file, I find I can't connect to my server (while I know I have with other MMF applications). I wonder if this may be because my server is using SQL Server 2005 instead of mySQL (as described in his tutorial).

Would there be a difference in which database application his example would work with?

Thanks for the input!



Most graciously...

RGBreality

His database application is on his webserver, and I'm not sure but I'd say SQL Server 2005 is not web based?

Hey, RickyRombo!

I think I understand... While I did change the server URL to point to my internal server, the MMF application cannot access the database because SQL Server 2005 is not Web based (meaning, it cannot be referenced online).

So, can MySQL Server and SQL Server 2005 run on the same computer without interfering with one another?



RGBreality

MySQL usually runs on a webhost.

See byethost.com for example

Hey, RickyRombo!

I wonder if I've run into another problem in setting up an online high-score database...

Jeff Vance uses PHP scripting, which is outside the scope of MMF2. It seems I would need to install PHP on my computer which is hosting the database. After reading a few tutorials online on how to do so (then get it set up with Internet Information Services), I've had no success.

I wonder if there are any other ways to set up an online high-score database which don't require PHP scripting? (His example LOOKED easy, but it seems he must have already had PHP installed on the computer which was hosting the SQL database).

(Since I'm doing this for my office, I don't have authorization to invest in a new Web service provider.)

Thank you for your feedback!



Most graciously...

RGBreality

If you use IIS (the Microsoft Web Server Based), then you can use ASP pages for contacting/parsing/establishing some actions TO the SQL SERVER, i think no?

You could put something together with the new Lacewing Webserver object. Maybe I (or someone) should make a high score example using that..

That would be great Jamie.

Marv

That online score tutorial by DavidN is brilliant! It's what got me interested in SQL.

Hey, folks!

That indeed would be great! I'm afraid coding ASP.NET is beyond my skill sets, so I wouldn't be able to do it myself. It would be interesting if the Lacewing object had something built into it to do that.


RGBreality

There's already a Lacewing Webserver Object...

Hey, LB!

What I meant to say is that it would be cool if that Lacewing Web server object had high scoring capability built into it.


RGBreality

Then that would defeat the whole purpose of the object... Sure it'd be cool, but not reasonable ;)