Hey everyone,
I just completed installed the MySQL 3.23.36-1 package from http://pkg.nl.cobalt.com/ through the Cobalt RaQ 4i web-based admin package. Everything went find...the download, installation, setup, until I tried to connect to my newly created database.
I went to the parameters for the ASP settings, then logged onto my server again, then clicked on databases, then test on the newly created database. Here is what the screen showed:

Data Source Names

Name Driver
mysql MySQL 3.22.32-1 remove edit test

After clicking test, the message I got was as follows:

Test connection failed

Error: -2147418113
Description: Chili!ASP ADO control - build 3.4.1 Open call failed

These are my settings for the mysql server I tried to setup:

Edit Data Source Name

Data Source Name: mysql
Database type: MySQL 3.22.32-1
Description:
Driver: /home/chiliasp/odbc/opensource/lib/libmyodbc.so
Server: localhost
Port:
Database: mysql
User: *****
Password: *****
UseCursorLib: 1

If anyone has any suggestions, same problems, and solutions, please post a reply back up ASAP. Thanks Much.

Regards,
David Lisiecki

Try this

username: root
password: cobalt-mysql

Thanks Eagle,

After making the necessary changes to the username and password, I was able to get a connection to the MySQL database.

Regards,
David Lisiecki

np :D

don't forget to change the root password from the default!!!

David