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
