dsn to postgres database.

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

Browse pgsql-general by date

  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?))