From: Josef Springer <Josef.Springer@joops.com>
To: Chander Ganesan <chander@otg-nc.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Can not access PostgreSQL 8.8 via ADO
Date: Thu, 25 Mar 2010 15:35:10 +0100
Message-ID: <4BAB749E.8060009@joops.com> (raw)
In-Reply-To: <4BAB54FA.1060806@otg-nc.com>
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>
<4BAB54FA.1060806@otg-nc.com>
Thanks for quick answer. Sorry, this was a misstype. We are using 8.4
not 8.8.
* We are using the OLEDB-Provider for ADO.
* On 8.2 the connectionstring works, on 8,4 it does not work.
* The database is local and accessed with localhost.
* An application, whitch acceses the database via an ODBC-driver
works. Only ADO does not work. (ADO error *80004005.* )
Joserf Springer
Chander Ganesan wrote:
> 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?
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Josef.Springer@joops.com, chander@otg-nc.com
Subject: Re: Can not access PostgreSQL 8.8 via ADO
In-Reply-To: <4BAB749E.8060009@joops.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox