The Daily Click ::. Forums ::. Klik Coding Help ::. ODBC MySQL Connection Problems
 

Post Reply  Post Oekaki 
 

Posted By Message

Haris Ahmed



Registered
  14/06/2006
Points
  237
8th July, 2006 at 21:41:45 -

I am using the ODBC object so I can connect to a MySQL database and send registration information a user enters to the database. I am having problems getting the ODBC object to connect to the MySQL database server. Any suggestion?

 
Pokemon Online: pokemonol.net

David Newton (DavidN)

Invisible

Registered
  27/10/2002
Points
  8322

Honored Admin Alumnus
9th July, 2006 at 08:58:46 -

The trouble with using the OBDC object to directly access a MySQL database is that, as I discovered when I tried to do it myself, many MySQL servers will block queries from anywhere but the server itself. Passing the data to a PHP page first via Moosock (or anything capable of opening a browser) is how I'm doing it in my current project, but if anyone has a more direct way to do it, I'd be happy to hear it as well.

 
http://www.davidn.co.nr - Games, music, living in America

Haris Ahmed



Registered
  14/06/2006
Points
  237
9th July, 2006 at 09:20:24 -

Do you have example files of how to do this that you could give me? You must have, if you are doing it in your project.

 
Pokemon Online: pokemonol.net

David Newton (DavidN)

Invisible

Registered
  27/10/2002
Points
  8322

Honored Admin Alumnus
9th July, 2006 at 15:23:07 -

Yes, I'd give you an example, but my hard drive's at the bottom of a suitcase at the moment. Have a look at the articles - I think Klikmaster has one on online high score tables that works on pretty much the same idea.

 
http://www.davidn.co.nr - Games, music, living in America

Klikmaster

Master of all things Klik

Registered
  08/07/2002
Points
  2599

Has Donated, Thank You!You've Been Circy'd!VIP MemberPS3 Owner
9th July, 2006 at 15:55:12 -

Omg, someone who notices me

 
n/a

David Newton (DavidN)

Invisible

Registered
  27/10/2002
Points
  8322

Honored Admin Alumnus
10th July, 2006 at 15:55:11 -

I will be (temporarily) on Thursday, I hope. Permanent Americanness only comes next month.

 
http://www.davidn.co.nr - Games, music, living in America
   

Post Reply



 



Advertisement

Worth A Click