Date: Thu, 17 Aug 2000 09:33:58 -0400
From: Robert Rothe <rrothe@mindspring.com>
Subject: Re: ODBC Example with VB5?
To: Ashley Clark <aclark@ghoti.org>
Cc: pgsql-interfaces@postgresql.org
Message-id: <399BE9C6.B14E1336@mindspring.com>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7bit
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