[cobalt-users] Cannot connect DSN to PostgreSQL

[jasong@xxxxxxxxxxxxx]

Hi Everyone

I am trying to get ASP working on my new Cobalt Raq XTR and I am having the 
following problems. I am normally a Microsoft man myself but after a slew of 
recent security issues I have moved to the Sun product. I am therefore a total 
newbie at this so please forgive me!

OK, so how do I get a site to work on the XTR with PostgreSQL. I have figured 
out this much...

I have logged in via telnet, changed my user to postgres (via root as I don't 
know what the password for user postgres is, can anyone tell me?) and changed 
the line in the pg_hba.conf file to say: "local all trust". I couldn't seem to 
even create a database without this...

I have created a test database, and in that assigned a user "dbuser" with the 
password "dbuser", then granted this user SELECT access to a table I have 
created and populated. I then tested access via this user and I could do a 
SELECT on the table.

I then went into the GUI and created a DSN, selecting Postgre as the driver, 
using localhost as the server, dbuser as the username and password and 5432 as 
the port (which I got from netstat -na). Finally I setup an ASP application for 
a file I created called test.asp.

Now when I test the DSN I get:

>Error: -2147418113
>Can not load ODBC Driver.

And when I test a page I have written I get:

>ADODB.Connection.1 error '80004005' 
>
>SQLState: S1000
>Native Error Code: 101
>Could not connect to the server;
>Could not connect to remote socket.
>
>
>/test.asp, line 15

I should note that this Raq is straight out of the box with default software 
installed.

I have tried using no DSN to connect to the database, I have tried just using a 
DSN, and using a DSN but also supplying the username and password again in my 
connection string. Nothing seems to work.

My questions are this:
1. What am I missing here?
2. Is there any problem with using the line "local all trust" long term? Will 
it introduce security issues? What can I do about that and is there a batter 
configuration?

Thanks in advance, I would really appreciate a resolution to this.

Cheers
Jason Goodridge