Re: [cobalt-users] Cobalt Database Help

["Brian Curtis" <admin@xxxxxxxxxxx>]

----- Original Message -----
From: "David Allen" <dallen@xxxxxxxxxxxxx>


> In the raq 4 control panel you enter the dsn, server name (site that is
> using mysql) and name and a password then it ask to save, when I click
save
> it gives a button to push to test it, I click test and that's the error I
> get.  I can't connect through any sql clients either.
>
>
> David Allen <dallen@xxxxxxxxxxxxx> wrote:
> > Using MYSQL out of the box on the RAQ 4 this is my error, can anyone
help?
> > Test connecton failed
> >
> > Error: -2147467259
> > Description: Specified driver could not be loaded
>

OK, I haven't even seen a Raq 4 yet, so I'm taking a stab here with my
experiences and unixODBC which we use quite a bit.

DSN: Did you enter an already existing MySQL database, and does the database
have sufficient permissions?

Server Name: Try 'localhost' (w/o the quotes)

Username/Password: These should match the ones that you assigned to the
MySQL database user, who has sufficient permissions to access the database.

If you think you've entered everything correctly and it still doesn't work,
try MySQL's CLI with the same username and password.  Try the following mock
MySQL CLI session, replacing all <something> with the proper variables:

$> mysql -u <username> -p
Enter password: <enter user's password>

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 263063 to server version: 3.22.32

Type 'help' for help.

mysql> use <databasename>;
Database changed

mysql> show tables;
+--------------------------+
| Tables in <databasename> |
+--------------------------+
| table1                   |
| table2                   |
| table3                   |
| table4                   |
| table5                   |
+--------------------------+
5 rows in set (0.00 sec)

mysql> \q
Bye

$>

Use the same details that you were using for the ODBC connection setup.  If
the MySQL CLI session fails anywhere with a message like 'permission
denied', then your MySQL db and/or user permissions are not set properly
(feel free to post any errors back to the list if you'd like help resolving
them).

If you succeed w/o any error messages, then it sounds like the ODBC
middleware may be misconfigured.  In the latter case, this is far as I can
go with any help I can provide due to the lack of resources on hand.

HTH

--
BC