From: Kenneth Marshall <ktm@rice.edu>
To: Josef Springer <Josef.Springer@joops.com>
Cc: 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 09:42:38 -0500
Message-ID: <20100325144238.GC1218@it.is.rice.edu> (raw)
In-Reply-To: <4BAB749E.8060009@joops.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>
<4BAB749E.8060009@joops.com>
Hi Joserf,
Does your ADO accept a version 8.4 reply from the database. It
may not be supported. In that case, you will need to update your
ADO software.
Cheers,
Ken
On Thu, Mar 25, 2010 at 03:35:10PM +0100, Josef Springer wrote:
> 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: ktm@rice.edu, Josef.Springer@joops.com, chander@otg-nc.com
Subject: Re: Can not access PostgreSQL 8.8 via ADO
In-Reply-To: <20100325144238.GC1218@it.is.rice.edu>
* 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