Re: [cobalt-users] MySQL / ChiliASP woes

["Ian" <cobalt@xxxxxxxxxxxxx>]

On 19 Jun 2003 at 17:18, Phil Jones wrote:

> Hi all
> 
> Having trouble with a brand spanking new RAQ4.
> Came with ChiliASP already installed, but no
> MySQL. Installed the MySQL .pkg v. 3.23.54 and
> all appeared to go well.
> 
> But ASP refuses to connect to MySQL - keep getting
> 'specified driver could not be loaded...'
> 
> I'm sure I've come across this situation before,
> but for the life of me I can't recall how we 
> resolved it. Have a vague memory that it involved
> reinstalling ChiliASP.
> 
> Incidentally, is there an easy way of determining 
> which version of ChiliASP is installed (my brain
> is not up to speed today...)
> 
> Phil

Hi Phil,

To get the version, run this from a shell:

/home/chiliasp/asp-apache-3000/caspctrl version

If you are running 3.5.2.xx I strongly recommend upgrading to the 3.6 
version ( can be found as a free package on the chiliasp website 
somewhere ).

The mysql drivers for chiliasp is actually the MyODBC driver from the 
mysql site ( version 2.50.28 I think )

I had a similar problem with drivers on one Raq, which I resolved by 
installing MyODBC then linking the new driver to the old.

The chiliasp driver is in:

/home/chiliasp/odbc/opensource/lib

I then did a

ln -l /usr/local/lib/libmyodbc.so libmyodbc.so
	[new driver]                       [old driver]

from the above directory.

Make sure you back things up before you make any changes !


The paths and folders may be different on your system, depending on 
the version you are running.

Regards

Ian
--