[cobalt-users] [Raq3] chilisoft postgres database

[Phil <phillip.jobbins@xxxxxxxxxxxxxxxx>]

Hi, 
Im trying to access a postgres database through a DSN in chilisoft asp.
Using cobalts directions, i created a database called test, in
the ./home/pgsql/base/test directory. 
I can log in as 'myuserid', and run queries on the database inside the
psql monitor. 

But when i try to make a dsn in chilisoft with these settings:
DSN mydsnname
Driver PostgreSQL  
Host localhost
Port 1025  
User ID  myuserid
Password  mypassword
Database  test
it says:
Error: 1000 - The database does not exist on the server or user
authentication failed. 

I think its because chilisoft keeps its databases in
./home/chilisoft/odbc/internaldb/data/base/xxwhateverxx
because there are some chilisoft sample databases and DSN's that work
ok.

My question is, how do i create a database in the chilisoft directory
using the psql program, or, how do i get the chilisoft dsn to find my
'test' database?
And how do i run queries on the databases in the chilisoft directories
through the psql program?

Cheers, 
Phil Jobbins