pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCan not access PostgreSQL 8.8 via ADO
6+ messages / 5 participants
[nested] [flat]
* Can not access PostgreSQL 8.8 via ADO
@ 2010-03-25 08:37 Josef Springer <Josef.Springer@joops.com>
0 siblings, 1 reply; 6+ messages in thread
From: Josef Springer @ 2010-03-25 08:37 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can not access PostgreSQL 8.8 via ADO
@ 2010-03-25 12:20 Chander Ganesan <chander@otg-nc.com>
parent: Josef Springer <Josef.Springer@joops.com>
0 siblings, 1 reply; 6+ messages in thread
From: Chander Ganesan @ 2010-03-25 12:20 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; +Cc: pgsql-admin
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!
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can not access PostgreSQL 8.8 via ADO
@ 2010-03-25 14:35 Josef Springer <Josef.Springer@joops.com>
parent: Chander Ganesan <chander@otg-nc.com>
0 siblings, 2 replies; 6+ messages in thread
From: Josef Springer @ 2010-03-25 14:35 UTC (permalink / raw)
To: Chander Ganesan <chander@otg-nc.com>; +Cc: pgsql-admin
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?
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can not access PostgreSQL 8.8 via ADO
@ 2010-03-25 14:42 Kenneth Marshall <ktm@rice.edu>
parent: Josef Springer <Josef.Springer@joops.com>
1 sibling, 0 replies; 6+ messages in thread
From: Kenneth Marshall @ 2010-03-25 14:42 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; +Cc: Chander Ganesan <chander@otg-nc.com>; pgsql-admin
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?
>>
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can not access PostgreSQL 8.8 via ADO
@ 2010-03-25 14:43 Richard Broersma <richard.broersma@gmail.com>
parent: Josef Springer <Josef.Springer@joops.com>
1 sibling, 1 reply; 6+ messages in thread
From: Richard Broersma @ 2010-03-25 14:43 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; +Cc: Chander Ganesan <chander@otg-nc.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Can not access PostgreSQL 8.8 via ADO
@ 2010-03-25 15:13 Glyn Astill <glynastill@yahoo.co.uk>
parent: Richard Broersma <richard.broersma@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Glyn Astill @ 2010-03-25 15:13 UTC (permalink / raw)
To: Josef Springer <Josef.Springer@joops.com>; Richard Broersma <richard.broersma@gmail.com>; +Cc: Chander Ganesan <chander@otg-nc.com>; pgsql-admin
--- On Thu, 25/3/10, Richard Broersma <richard.broersma@gmail.com> wrote:
> 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/
>
Or try PGNP http://www.pgoledb.com/
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2010-03-25 15:13 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-25 08:37 Can not access PostgreSQL 8.8 via ADO Josef Springer <Josef.Springer@joops.com>
2010-03-25 12:20 ` Chander Ganesan <chander@otg-nc.com>
2010-03-25 14:35 ` Josef Springer <Josef.Springer@joops.com>
2010-03-25 14:42 ` Kenneth Marshall <ktm@rice.edu>
2010-03-25 14:43 ` Richard Broersma <richard.broersma@gmail.com>
2010-03-25 15:13 ` Glyn Astill <glynastill@yahoo.co.uk>
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