Re: mysql oddities
On Jun 24, 2005, at 12:55 AM, Howard Freeman wrote:
I've been using rev to link up to MySQL for a while but I've just
changed my web space supplier and I can't connect to MySQL. I
thought that this was their problem but it's stranger than that.
If I use the database query builder then the connection is made and
I can see the tables and fields and can query the database. When I
try to do the same thing in my own stack - and those of other
people who use MySQL - I get connection errors. What I'd really
like to do is get inside the database query builder to find out
what commands it is using to connect to my database.
The query builder uses the revdb library to connect so it isn't doing
anything special. If you can connect using the query builder but not
in your own code then I would check that you have the parameters in
the right place and the right order. What kind of error are you
getting?
Alternatively, can someone provide some tips about the port
variable in the revopendatabase function? I'm just putting the port
number as a colon and number immediately after the host url and I'm
sure this is right, eg :3337. Is there any other way to write it?
That is what revOpenDatabase is expecting so that shouldn't be the
problem. I'm assuming you are passing it like this:
put revOpenDatabase("mysql", "db.myhost.com:3306", "myDBName",
"USERNAME", "PASSWORD", true)
Also, I don't want to use the database query manager all the time
because I intend to distribute this as a standalone to users of the
MySQL database.
--
Trevor DeVore
Blue Mango Multimedia
[EMAIL PROTECTED]
___
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
RE: mysql oddities
Be sure to eliminate password/version issues. There was a change from 16-characters to 40-characters. Your new service provider may have a different version installed. You can check the on-line MySQL manual under "old passwords". -- Harvey -- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Howard Freeman Sent: Friday, June 24, 2005 12:55 AM To: use-revolution@lists.runrev.com Subject: mysql oddities I've been using rev to link up to MySQL for a while but I've just changed my web space supplier and I can't connect to MySQL. I thought that this was their problem but it's stranger than that. If I use the database query builder then the connection is made and I can see the tables and fields and can query the database. When I try to do the same thing in my own stack - and those of other people who use MySQL - I get connection errors. What I'd really like to do is get inside the database query builder to find out what commands it is using to connect to my database. Alternatively, can someone provide some tips about the port variable in the revopendatabase function? I'm just putting the port number as a colon and number immediately after the host url and I'm sure this is right, eg :3337. Is there any other way to write it? Also, I don't want to use the database query manager all the time because I intend to distribute this as a standalone to users of the MySQL database. Thanks Howard ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
mysql oddities
I've been using rev to link up to MySQL for a while but I've just changed my web space supplier and I can't connect to MySQL. I thought that this was their problem but it's stranger than that. If I use the database query builder then the connection is made and I can see the tables and fields and can query the database. When I try to do the same thing in my own stack - and those of other people who use MySQL - I get connection errors. What I'd really like to do is get inside the database query builder to find out what commands it is using to connect to my database. Alternatively, can someone provide some tips about the port variable in the revopendatabase function? I'm just putting the port number as a colon and number immediately after the host url and I'm sure this is right, eg :3337. Is there any other way to write it? Also, I don't want to use the database query manager all the time because I intend to distribute this as a standalone to users of the MySQL database. Thanks Howard ___ use-revolution mailing list use-revolution@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-revolution
