Connecting to Postgres via ADO/Data Environment in VB6

From: "Jeremy Yager" <jayager(at)carolina(dot)rr(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: Connecting to Postgres via ADO/Data Environment in VB6
Date: 2005-06-23 21:17:25
Message-ID: 001401c57838$f48b03a0$6400a8c0@aeolus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

LocalizationHi everyone

I am trying to use VB6/ADO with Data Environment to manage a very simple postgreSQL 8.0.3 database, after long experience with MS SQL Server and Jet databases. Has anyone ever used the provided Data Environment system with a postgreSQL DB?

I can generate a successful connection test (through the 'Test Connection' dialog) but I cannot get any information back--I get an 'unspecified error' when I try to connect to the DB once out of the setup dialog. (Kinda helpful, isn't it?)

I want this to happen linklessly, for portability.

The view I want to get to tests successfully in pgAdmin under the same account.

Here is the ADO connection string:
Provider=PostgreSQL.1;Password=[correctpw];User ID=postgres;Data Source=localhost;Location=TestDB;Extended Properties=""

Any ideas? I figure it is probably something dumb, or DE just doesn't like non M$ RDB's.

--Jeremy

In response to

  • Localization at 2005-06-23 10:01:32 from Pradeepkumar, Pyatalo (IE10)

Browse pgsql-novice by date

  From Date Subject
Next Message Joshua N Pritikin 2005-06-24 04:56:49 unpacking composite values
Previous Message Tom Lane 2005-06-23 17:18:20 Re: Grouped item in a subquery