Message-ID: <4BAB54FA.1060806@otg-nc.com>
Date: Thu, 25 Mar 2010 08:20:10 -0400
From: Chander Ganesan <chander@otg-nc.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: Josef Springer <Josef.Springer@joops.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Can not access PostgreSQL 8.8 via ADO
References: <450FAE7A.9070408@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C6@algol.sollentuna.se>
	<450FC3E0.2030001@joops.com>
	<6BCB9D8A16AC4241919521715F4D8BCEA356C7@algol.sollentuna.se>
	<45A60D3E.1060700@joops.com> <45A61751.6040603@mailnetwork.co.uk>
	<4BAB20BC.3000908@joops.com>
In-Reply-To: <4BAB20BC.3000908@joops.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Josef Springer wrote:
> hello,
>
> we had installed 8.2 and used a database via ADO with the connectstring
> *Driver={PostgreSQL 
> Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Database=OfficeTalk"
> *
> Now we have installed 8.8 and try to use the database with the same 
> connectstring but get the ADO error *80004005.*
There is no PostgreSQL 8.8 - can you tell us what version you are really 
using (or, if you think it is 8.8, where you got it from?)

Can you connect to the database with the regular command line tools over 
the network (or a GUI tool such as PgAdmin III), or do you get an error 
there as well?

The problem may be that it's unable to connect due to a database 
configuration issue, not an ADO issue.  If you had a DSN that was 
working before, I wouldn't change it until you've verified that you're 
actually able to connect to the database properly.

Did you make sure that you made the appropriate changes to 
postgresql.conf and pg_hba.conf on the new system to ensure that users 
will be able to connect over the network?

-- 
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC  27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Ask me about out VIRTUAL LIVE training options for PostgreSQL - available globally!