From Josef.Springer@joops.com Thu Mar  25 08:44:10 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 9F929632636
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 05:44:10 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 60575-03 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 08:43:55 +0000 (UTC)
X-Greylist: delayed 00:06:39.351385 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 8F75A63240A
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 05:43:59 -0300 (ADT)
X-PDA-ORIGIN: vserver0403.onit4u.de
Received: (qmail 28429 invoked from network); 25 Mar 2010 08:35:20 -0000
Received: by simscan 1.4.0 ppid: 28336, pid: 28350, t: 6.4541s
	scanners: clamav: 0.95.3/m:47/d:10621 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 08:35:14 -0000
Message-ID: <4BAB20BC.3000908@joops.com>
Date: Thu, 25 Mar 2010 09:37:16 +0100
From: Josef Springer <Josef.Springer@joops.com>
User-Agent: Thunderbird 2.0.0.24 (Windows/20100228)
MIME-Version: 1.0
CC: pgsql-admin@postgresql.org
Subject: 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>
In-Reply-To: <45A61751.6040603@mailnetwork.co.uk>
Content-Type: multipart/alternative;
	boundary="------------000704050100000001080902"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.108 tagged_above=-10 required=5
	tests=BAYES_40=-0.185, HTML_MESSAGE=0.001, MISSING_HEADERS=1.292
X-Spam-Level: *
X-Archive-Number: 201003/188
X-Sequence-Number: 33987

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

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.*

We tried different variants but nothing works.

Can anybody help us ?

Thanks for response,
Josef Springer

--------------000704050100000001080902
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">
hello,<br>
<br>
we had installed 8.2 and used a database via ADO with the connectstring<br>
<b>Driver={PostgreSQL
Unicode};Server=localhost;Uid=OfficeTalk;Pwd=OfficeTalk;Database=OfficeTalk"<br>
</b><br>
Now we have installed 8.8 and try to use the database with the same
connectstring but get the ADO error <b>80004005.</b><br>
<br>
We tried different variants but nothing works. <br>
<br>
Can anybody help us ?<br>
<br>
Thanks for response,<br>
Josef Springer<br>
</body>
</html>

--------------000704050100000001080902--



From chander@otg-nc.com Thu Mar  25 13:21:14 2010
Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 3413B632DAC
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 10:21:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 07234-06 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 13:20:55 +0000 (UTC)
X-Greylist: delayed 00:55:40.129981 by SQLgrey-1.7.6
Received: from mail-gw0-f46.google.com (mail-gw0-f46.google.com
 [74.125.83.46])
	by mail.postgresql.org (Postfix) with ESMTP id 83DB7632817
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 10:21:03 -0300 (ADT)
Received: by gwaa18 with SMTP id a18so2495041gwa.19
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 06:21:02 -0700 (PDT)
Received: by 10.101.5.2 with SMTP id h2mr8449637ani.73.1269519605918;
	Thu, 25 Mar 2010 05:20:05 -0700 (PDT)
Received: from [10.0.2.11] (voip-ext.otg-nc.com [74.223.168.194])
	by mx.google.com with ESMTPS id 16sm707970gxk.9.2010.03.25.05.20.03
	(version=SSLv3 cipher=RC4-MD5); Thu, 25 Mar 2010 05:20:04 -0700 (PDT)
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
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/191
X-Sequence-Number: 33990

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!




From Josef.Springer@joops.com Thu Mar  25 14:35:23 2010
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--



From ktm@rice.edu Thu Mar  25 14:39:19 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id BFBE7632CCD
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 11:39:19 -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 16636-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 14:39:08 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from is.rice.edu (is.rice.edu [128.42.42.24])
	by mail.postgresql.org (Postfix) with ESMTP id 6768F632815
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 11:39:09 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by is.rice.edu (Postfix) with ESMTP id 2699A4181C;
	Thu, 25 Mar 2010 09:42:45 -0500 (CDT)
Received: from is.rice.edu ([127.0.0.1])
	by localhost (it.is.rice.edu [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id 19247-05; Thu, 25 Mar 2010 09:42:39 -0500 (CDT)
Received: by is.rice.edu (Postfix, from userid 18612)
	id EA5B641819; Thu, 25 Mar 2010 09:42:38 -0500 (CDT)
Date: Thu, 25 Mar 2010 09:42:38 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: Josef Springer <Josef.Springer@joops.com>
Cc: Chander Ganesan <chander@otg-nc.com>, pgsql-admin@postgresql.org
Subject: Re: Can not access PostgreSQL 8.8 via ADO
Message-ID: <20100325144238.GC1218@it.is.rice.edu>
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>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4BAB749E.8060009@joops.com>
User-Agent: Mutt/1.5.16 (2007-06-09)
X-Virus-Scanned: by amavis-2.2.1 at is.rice.edu
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/199
X-Sequence-Number: 33998

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



From richard.broersma@gmail.com Thu Mar  25 14:43:15 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7EC66632815
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 11:43:15 -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 17200-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 14:43:04 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.153])
	by mail.postgresql.org (Postfix) with ESMTP id D7497632805
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 11:43:04 -0300 (ADT)
Received: by fg-out-1718.google.com with SMTP id 19so1998249fgg.1
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 07:43:02 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:received:message-id:subject:from:to:cc:content-type;
	bh=9jA9gXFTIzeEOyEb50uR4saBFw+Jte/KwNH4avJelBk=;
	b=INVifrFthgH6lK+GMRYf6eci7U2nTyCs7CKU38Ii+pQQu39FPKQxHafEMqmafxY+4P
	zuYXekwSYO0MOf34wAbocxH5SPBONDF9VkJfHh+NwRhHXfb/C/t/Zjd5IsS7e3ZR/T5I
	xlu5Y4Youp33+531YULQMMfN7BrsgUJJ+Jxvk=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=uI0GLsh6hpyRET+ajcHVRlsJuB2MDGXJlaRPZN/IM/EAnnlkDF2pO3aw3tUo1z8dzL
	/mYyUdL0mA3XnZgUX2kZwAU8wvwUjwrFLxmFgDFPLndLoA47ftz4TySqZHQo4YI8PTOV
	3u/qnaVaAdJfEzq6WNqD4apko9HMhump+kKP8=
MIME-Version: 1.0
Received: by 10.86.2.16 with HTTP; Thu, 25 Mar 2010 07:43:02 -0700 (PDT)
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>
Date: Thu, 25 Mar 2010 07:43:02 -0700
Received: by 10.87.62.1 with SMTP id p1mr2059910fgk.42.1269528182507; Thu, 25
	Mar 2010 07:43:02 -0700 (PDT)
Message-ID: <396486431003250743u76fb2a3fqc3c501597f932f55@mail.gmail.com>
Subject: Re: Can not access PostgreSQL 8.8 via ADO
From: Richard Broersma <richard.broersma@gmail.com>
To: Josef Springer <Josef.Springer@joops.com>
Cc: Chander Ganesan <chander@otg-nc.com>, pgsql-admin@postgresql.org
Content-Type: text/plain; charset=ISO-8859-1
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/200
X-Sequence-Number: 33999

On Thu, Mar 25, 2010 at 7:35 AM, Josef Springer
<Josef.Springer@joops.com> 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.* )


If you notice the oledb driver is still marked beta and is not
production ready.  It also looks like it was last updated 4 years ago.

http://pgfoundry.org/projects/oledb/

You should probably use the odbc driver since it is production ready
and actively supported.

http://www.postgresql.org/ftp/odbc/versions/msi/

-- 
Regards,
Richard Broersma Jr.

Visit the Los Angeles PostgreSQL Users Group (LAPUG)
http://pugs.postgresql.org/lapug



From glynastill@yahoo.co.uk Thu Mar  25 15:13:57 2010
Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 7714D633892
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 12:13:57 -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 22968-02 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 25 Mar 2010 15:13:47 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from web23605.mail.ird.yahoo.com (web23605.mail.ird.yahoo.com
	[87.248.115.48])
	by mail.postgresql.org (Postfix) with SMTP id E8765632517
	for <pgsql-admin@postgresql.org>; Thu, 25 Mar 2010 12:13:15 -0300 (ADT)
Received: (qmail 21937 invoked by uid 60001); 25 Mar 2010 15:13:14 -0000
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s1024;
	t=1269529994; bh=U7t96xiTE08ZRG6PonoPTSEiesa/VG6QB0qjYXWShNw=;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=CMxYt/HVneh1J9S5yAcSpFguEG8Cxs9nOHqsxAWjb4fACcrRDkWSvDBX79SUz1kgZghMeIeCF3WANvJy6H+/qhPB1ntNAeM6hZ7EqpUghnOTUDdMA6Kn8T+GwsG0i8NXPlSwU2US2g5EjrAu/XRJEulDWHxZZasb5NwrE0+4qIQ=
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.uk;
	h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
	b=17g59A8FhM/cRoSUGsWM/aO6TxBmn70VKtILHnnWxaXL+Mc8rokWodPjS83sjRpW3Hevlelabd1jklyjXTZNgwU3rj3j67GKmwq+tPFAiIkjanHyshhCuLQNjGQSfj4+MyzVg+kV8qvxLnuI8Z/NLyH0Kkr5RpaADqRFCskb/7o=;
Message-ID: <103515.21137.qm@web23605.mail.ird.yahoo.com>
X-YMail-OSG: 0RpInFEVM1nCdG3iFtUo2GPM5tUIROcjp8TfPYnLTjKornP
	246OtTql6WmO77cJDnG4cQ3kddS8KE.eC48gaKN.8XR6eejrHAyWKzJsHne8
	u4XazR7R9nEJN5ea5ML2lArMS3UNeDDZi7HZV37Bz9JBGtfh616A1jfaCaXp
	z8lY1oMJyU5Mg8aMvAs5kOHgbJI11kzkdv2e.uIdqDqDOe8vQLHh3sgNRKDI
	qC_u4Dozsz5abpyHkG13YPzkPVjDBevNgfn9UB6oremrFIfYLryB1pkTUBNS
	475TDJLAwS2AgOa2jlfMi_68-
Received: from [83.100.146.195] by web23605.mail.ird.yahoo.com via HTTP;
	Thu, 25 Mar 2010 15:13:13 GMT
X-Mailer: YahooMailClassic/10.0.8 YahooMailWebService/0.8.100.260964
Date: Thu, 25 Mar 2010 15:13:13 +0000 (GMT)
From: Glyn Astill <glynastill@yahoo.co.uk>
Subject: Re: Can not access PostgreSQL 8.8 via ADO
To: Josef Springer <Josef.Springer@joops.com>,
	Richard Broersma <richard.broersma@gmail.com>
Cc: Chander Ganesan <chander@otg-nc.com>, pgsql-admin@postgresql.org
In-Reply-To: <396486431003250743u76fb2a3fqc3c501597f932f55@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5
	tests=BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201003/201
X-Sequence-Number: 34000

=0A=0A--- On Thu, 25/3/10, Richard Broersma <richard.broersma@gmail.com> wr=
ote:=0A> wrote:=0A> > Thanks for quick answer. Sorry, this was a misstype.=
=0A> We are using 8.4 not=0A> > 8.8.=0A> >=0A> > We are using the OLEDB-Pro=
vider for ADO.=0A> > On 8.2 the connectionstring works, on 8,4 it does not=
=0A> work.=0A> > The database is local and accessed with localhost.=0A> > A=
n application, whitch acceses the database via an=0A> ODBC-driver works. On=
ly=0A> > ADO does not work. (ADO error *80004005.* )=0A> =0A> =0A> If you n=
otice the oledb driver is still marked beta and is=0A> not=0A> production r=
eady.=A0 It also looks like it was last=0A> updated 4 years ago.=0A> =0A> h=
ttp://pgfoundry.org/projects/oledb/=0A> =0A> You should probably use the od=
bc driver since it is=0A> production ready=0A> and actively supported.=0A> =
=0A> http://www.postgresql.org/ftp/odbc/versions/msi/=0A> =0A=0A=0AOr try P=
GNP http://www.pgoledb.com/=0A=0A=0A=0A