From: | Phil <phillip(dot)jobbins(at)image-centre(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | dsn to postgres database. |
Date: | 2000-10-28 01:32:52 |
Message-ID: | 39FA2CC4.82EA017F@image-centre.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | The Hermit Hacker | 2000-10-28 01:59:04 | Re: 7.1 release date ? |
Previous Message | Bruce Momjian | 2000-10-27 23:08:05 | Re: [HACKERS] Re:RPM dependencies (Was: 7.0 vs. 7.1 (was: latest version?)) |