trouble connecting to mySQL database via DQB

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
jrioux
Posts: 50
Joined: Fri May 04, 2007 4:02 pm

trouble connecting to mySQL database via DQB

Post by jrioux » Thu Jun 26, 2008 4:25 pm

Forgive me if this is an obvious question, but I'm new to mySQL (using Revolution or anything else, for that matter).

I've created and populated an mySQL database on my hosting site (one service they offer) using the host's online administrator software. I've been able to identify the host name, database name, etc., but, when I enter this into Revolution's Database Query Builder and try to connect, I get an error (65). Any ideas?

Mark
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 5150
Joined: Thu Feb 23, 2006 9:24 pm
Contact:

Post by Mark » Thu Jun 26, 2008 5:05 pm

Hi jrioux,

First, use your favorite off-line MySQL client to connect to your on-line database, to make sure that you actually can access the database directly. There are hosts who simply don't allow this and force you to use PHP or other method to access the database.

If you can access your on-line database with an off-line client, you should be able to do the same with Revolution and you might want to post the syntax you are using to connect (without password of course).

Best,

Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode

Janschenkel
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 977
Joined: Sat Apr 08, 2006 7:47 am
Contact:

Post by Janschenkel » Fri Jun 27, 2008 1:08 pm

Maybe it expects the password to be in MySQL 4.1/5.x format. You have two options here:
1. Adapt your password, as explained in this tip: http://www.sonsothunder.com/devres/revo ... ata004.htm
2. Modify the password settings using MySQL Administrator:
- go to tab 'Options'
- use the combobox at the top to go to the 'Security' panel
- tick the checkbox 'Use old passwords'

Hope this helped,

Jan Schenkel.
Quartam Reports & PDF Library for LiveCode
www.quartam.com

Post Reply