[cobalt-users] PostgresSQL DSN and ASP

["Jason Goodridge" <jason@xxxxxxxxxxxxxxx>]

Hi Everyone

I am trying to setup a DSN to access a Postgres database from an ASP
page. So far I

1. have created a database (using "createdb") called "axv4" using the
"postgres" user.
2. created another user (using "createuser") called "dbuser" with the
password "dbuser" 
3. added tables using a CREATE TABLE query and while using "psql" logged
in as the "postgres" user
4. granted "all" to "dbuser" on the table I created
5. quit psql and re-opened it using "psql axv4 dbuser"
6. ran a test query logged in as "dbuser" and verified that it all
worked

Then I setup a DSN and tested it, no matter what I tried I could not get
the connection to work. I tried using no server name and port, using
localhost and 5432, I tried having the username and password in there
and not in there and every combination thereof.

Always the same message:

Test connecton failed

Error: -2147418113
Description: Can not load OBDC driver 

I have tried editing the pg_hba.conf to allow tcp/ip access along with
setting the "-I" option for postmaster. I am at my wits end with this. I
have looked at so many posts and nobody seems to have an answer of how
to do this properly from start to finish.

Can someone please tell me where to go or what to do in order to

1. make sure that my database has the correct permissions and that I
have created it properly
2. make sure that I can access this database from a DSN setup in the
Cobalt GUI with a username/password of my choice using local ports

Thanks
Jason

PS: I have noticed the following things and I'm not sure if they are
relevant:
1. There seems to be two installations of Postgres, I have run both
versions of psql and they both seem to point to the same databases? Is
this correct? Why is this?
2. Does the owner of the database have to be the user that logs in to
read it on the DSN, even if I have assigned access to another user?
(i.e. should I have created the user first and given that user create
access and then created the database with that user?

Any help appreciated...