Connecting to Postgres via ADO/Data Environment in VB6
| От | Jeremy Yager |
|---|---|
| Тема | Connecting to Postgres via ADO/Data Environment in VB6 |
| Дата | |
| Msg-id | 001401c57838$f48b03a0$6400a8c0@aeolus обсуждение исходный текст |
| Ответ на | Localization ("Pradeepkumar, Pyatalo (IE10)" <Pradeepkumar.Pyatalo@honeywell.com>) |
| Список | pgsql-novice |
Hi 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
В списке pgsql-novice по дате отправления: