Re: [cobalt-users] Database on Cobalt RAQ - Grrr! Any Other Solutions.

["dhbolton" <dhbolton@xxxxxxxxxxx>]

Nikolae
It may be different but on my RAQ, Mysql was supplied pre configured with No
remote access to the mysql database and I had to SSH into the box, reset the
root password, create a new database and grant myself access remotely. (You
can specify which IP addresses can connect). After that, an App running on
my windows box was successfully able to put data into a table in the
database.

For all aspects of MySql, I recommend the Koffler book - excellent. It
explained how the security works etc. I use MySQL with Delphi and there are
excellent libraries for that. I don't know Ultradev but you should be able
to install MyOdbc and connect via na Odbc connection.

David


<<I did research and came to these solutions:

- Use myODBC (mySQL-ODBC) on your Windows
machine and connect to the remote mySQL site start
coding.  When time is to publish I haven't gotten there yet.

I connect fine, and / but I am having issues with UltraDEV
not keeping the "connection" in the "recordset"
I tested the connection, before I was getting denied but
not I get "Connection Successful" but when click okay
UltraDev seems to not keep the connection active or
in memory in order to start working with Tables and
Queries.

- mm.mysql driver.  JDBC or Java driver.  I noticed
that I don't have that on my RAQ and doesn't support
Java drivers based on the ChilliSoft display.
So that's out of the question.