if you want you could contact me direct . [EMAIL PROTECTED] Hershel On Monday, October 18, 2004, at 04:41 PM, jbv wrote:
Hershel,
I actually tried every possible combination, but nothing works... I still get that error 61 (or 10061 on Windows)...
My problem is that I can't decide if it's a configuration problem on my server, or a Rev problem... Here's why : I was also trying to get a connection to MySQL with Rev-cgi linux (on the same server). And the right spelling (according to Rev documentation) for a DB that is listening on port 5432 is : localhost:5432 (instead of www.example.com:5432). But that doesn't work (same error). I finally managed to get that connection to MySQL with Rev-cgi by using : localhost (and dropping :5432).
It works, but I really don't understand why...
JB
What happens when you spell it out ?
on handler
put
revOpenDatabase("MySQL","www.example.com:5432","myDB","myUSR","myPWD", (m
ake sure the last comma)) into tR
answer tR
end handler
Hershel Fisch
On Monday, October 18, 2004, at 07:05 AM, jbv wrote:
Hi list,
Still fighting with databases connections...
I'm trying to open a connection to MySQL using revOpenDatabase in the IDE and I get this error :
Can't connect to MySQL server on 'www.example.com:5432' (61)
ALTHOUGH IT WORKS WITH the DB Query Builder (connection status : connected) !!!!
MySQL is configured on port 5432, which is open in the firewall. Here's the script I'm using :
on mouseUp put "root" into myUSR put "******" into myPWD revSetDatabaseDriverPath "/Macintosh HD/Desktop Folder/Revolution 2.5/components/global environment/database_drivers/MacOSX/dbmysql/Contents/MacOS/dbmysql" get revOpenDatabase("MySQL","www.example.com:5432","myDB",myUSR,myPWD)
put it end mouseUp
In the archives, I found a msg from someone saying that "root" isn't accepted by MySQL as user on a distant machine, but in that case why does it work in the DB Quary Builder ?
What am I missing or doing wrong ?
Thanks, JB
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
