Hi,
Im trying to access a postgres database on a Raq3 through a DSN in
chilisoft asp.
I have 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.
Chilisofts sample databases (with sample dsn's that work ok) are in
./home/chilisoft/odbc/internaldb/data/base/xxwhateverxx
My question is, how do i create a database using the psql program, that
a chilisoft dsn can find?
And how do i run queries on the databases in the chilisoft directories
through the psql program?
Cheers,
Phil Jobbins