From: Robert Rothe <rrothe@mindspring.com>
To: Ashley Clark <aclark@ghoti.org>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: ODBC Example with VB5?
Date: Thu, 17 Aug 2000 09:33:58 -0400
Message-ID: <399BE9C6.B14E1336@mindspring.com> (raw)
References: <399B3C8D.D2FB7E92@mindspring.com>
<20000816211201.D15065@ghoti.org>
I've verified the ODBC configuration options. I've tried a variety of
combinations -- each of them with R/O off in both the Driver and
Advanced dialogs.
I suspect my problem is more with VB than with Postgres. Although I did
have a similiar issue when trying to access PG databases via Access.
Do you, or anyone else, have a few lines of code that maybe do this:
a) Open database
b) Read a record set via select into a ListBox
c) Add a record
That would be all I need. With this working code, I could debug any
ODBC issues better.
Thanks,
Rob
Ashley Clark wrote:
>
> * Robert Rothe in "[INTERFACES] ODBC Example with VB5?" dated
> * 2000/08/16 21:14 wrote:
>
> > Can anyone point me to an example of using the postgresql ODBC driver
> > with Visual Basic 5.0? I've tried several suggestions from this
> > list, but still experience read-only errors. I'm not even sure I'm
> > using the DAO/RDO/R2D2 calling methods.
>
> Have you configured your ODBC Data Source correctly?
>
> Under Driver Options, uncheck ReadOnly.
> Under Advanced Options, uncheck ReadOnly.
>
> > I'm currently using the 6.50 version of the ODBC driver.
>
> Good luck, it should work out ok.
>
> --
> shaky caller
>
> ------------------------------------------------------------------------
> Part 1.2Type: application/pgp-signature
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rrothe@mindspring.com, aclark@ghoti.org
Subject: Re: ODBC Example with VB5?
In-Reply-To: <399BE9C6.B14E1336@mindspring.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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