Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 3598A631B0A
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 11:35:23 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 15963-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 14:35:12 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from vserver0403.onit4u.de (vserver0403.onit4u.de [213.133.112.9])
	by mail.postgresql.org (Postfix) with SMTP id 47881632805
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 11:35:11 -0300 (ADT)
X-PDA-ORIGIN: vserver0403.onit4u.de
Received: (qmail 4406 invoked from network); 25 Mar 2010 14:33:11 -0000
Received: by simscan 1.4.0 ppid: 4329, pid: 4340, t: 4.4561s
	scanners: clamav: 0.95.3/m:47/d:10622 spam: 3.3.0
Received: from unknown (HELO ?192.168.10.101?) (josefspa@92.74.60.140)
	by vserver0403.onit4u.de with SMTP; 25 Mar 2010 14:33:07 -0000
Message-ID: <4BAB749E.8060009@joops.com>
Date: Thu, 25 Mar 2010 15:35:10 +0100
From: Josef Springer <Josef.Springer@joops.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
To: Chander Ganesan <chander@otg-nc.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> <4BAB54FA.1060806@otg-nc.com>
In-Reply-To: <4BAB54FA.1060806@otg-nc.com>
Content-Type: multipart/alternative;
	boundary="------------080009020702040504090109"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.598 tagged_above=-10 required=5
	tests=BAYES_00=-2.599, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201003/198
X-Sequence-Number: 33997

This is a multi-part message in MIME format.
--------------080009020702040504090109
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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?
>



--------------080009020702040504090109
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks for quick answer. Sorry, this was a misstype. We are using 8.4
not 8.8.<br>
<ul>
  <li>We are using the OLEDB-Provider for ADO. </li>
  <li>On 8.2 the connectionstring works, on 8,4 it does not work.</li>
  <li>The database is local and accessed with localhost.</li>
  <li>An application, whitch acceses the database via an ODBC-driver
works. Only ADO does not work. (ADO error *80004005.*
)<br>
  </li>
</ul>
Joserf Springer<br>
<br>
<br>
Chander Ganesan wrote:
<blockquote cite="mid:4BAB54FA.1060806@otg-nc.com" type="cite">Josef
Springer wrote:
  <br>
  <blockquote type="cite">hello,
    <br>
    <br>
we had installed 8.2 and used a database via ADO with the connectstring
    <br>
*Driver={PostgreSQL
Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Database=OfficeTalk"
    <br>
*
    <br>
Now we have installed 8.8 and try to use the database with the same
connectstring but get the ADO error *80004005.*
    <br>
  </blockquote>
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?)
  <br>
  <br>
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?
  <br>
  <br>
The problem may be that it's unable to connect due to a database
configuration issue, not an ADO issue.&nbsp; 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.
  <br>
  <br>
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?
  <br>
  <br>
</blockquote>
<br>
<br>
</body>
</html>

--------------080009020702040504090109--