Mark,

Thanks. I don't know why but I always thought I had to supply the
username and pw if the database was password protected even if the
datasource had the information. Oh well learn something new everyday.

Dave



--- In speckcms@yahoogroups.com, Mark Woods <mwoods@...> wrote:
>
> Hi Dave,
>
> > If I want to setup the Hellospeck app using a MySQL or MSSQL db I
know
> > I have to specify the database type in the hellospeck.app file,
but
> > where do I supply the database username and password?
>
> You'd normally just do this when setting up the datasource in the
cf
> administrator. If for some reason you can't do that, you can add
the
> username and password to a database section in the application
> configuration, e.g.
>
> [database]
> username = dbusername
> password = dbpassword
>
> Add this at the end of your config file, after all other settings.
>
> The database section of the application configuration file is
optional
> and is only used override system wide settings for your DBMS (for
> example to force a character string data type other than simply
> character varying) or provide a username and password to connect to
the
> database (if you can't provide it as part of the datasource).
>
>
> Mark
>