Re: REALbasic and MySQL-database

[Jerry Hamlet <jerry at hamletzone dot com>]

On 7/29/02 3:50 AM, "Luc Bressinck" <bressinck dot luc at PI dot BE> wrote:

> Hello,
> 
> I have the plugin MySQL Plugin version 1.0.3.
> I want to connect to an mysql-database (in OS X, I have Mysql installed) but
> there is no OPEN function for mysql (there is one e.g. For OpenBase:
> OpenOpenBaseDatabase).
> How do I open the database?
> 

First create an instance of the MySQLDatabase
    Dim db As MySQLDatabase
    db = new MySQLDatabase

Second, set the parameters for your particular database:
    db.Host = "localhost"
    db.DatabaseName = "Database"
    db.UserName = "John"
    db.Password = "Hancock"

Finally, connect to your database with the Connect method, checking the
return value for an error:

  if NOT db.Connect() then
    MsgBox "Couldn't connect to database: " + db.ErrorMessage
    Quit
  end if


-jerry

+---------------------------------------------------------------------+
|                                                                     |
|                         H a m l e t z o n e                         |
|                                                                     |
|              w e b  d e s I g n  &  p r o g r a m m i n g           |
|                                                                     |
|                 w w w . h a m l e t z o n e . c o m                 |
|                                                                     |
|                         jerry at hamletzone dot com                        |
|                                                                     |
+---------------------------------------------------------------------+