Hi Don,

Only the professional license allows Rev to connect to MySQL databases. Is that what you have?
Since you can connect using other programming tools, the SQL stuff must be installed correctly and you must be using the correct user name, address, password etc.


I use a script like this to make the initial connection:
on mouseUp
  put fld "db user" into dbUser
  put fld "db password" into dbPass
  put fld "db path" into dbName
  put fld "db address" into dbAddr
  if dbAddr is empty then put "localhost" into dbAddr

  put revdb_connect("MySQL",dbAddr,dbName,dbUser,dbPass) into dbresult
  if dbresult is a number then
    put dbresult into fld "db ID"
  else
    answer dbResult
  end if
end mouseUp

Try this and see if you can get a connection ID number back. I have only connected to databases installed on my own computer rather than over a network, but it should work much the same. I use OS X and haven't tried any of this under OS 9.

Cheers,
Sarah
[EMAIL PROTECTED]
http://www.troz.net/Rev/


On Tuesday, March 25, 2003, at 06:26 am, Don Pederson wrote:


Cannot connect to my existing mySQL databases. They do work with Flash and
Realbasic, but I have not been able to connect to them with Revolution
1.1.1. What is required? The download site for drivers listed in the
Revolution documentation does not get found by the url given.


Any help would be greatly appreciated.
--
Dr. Donald Pederson
School of Music
University of Tennessee
1741 Volunteer Blvd.
Knoxville, TN  37996
[EMAIL PROTECTED]
(865)  974-7550

_______________________________________________
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

Reply via email to