From: | Robert Rothe <rrothe(at)mindspring(dot)com> |
---|---|
To: | Ashley Clark <aclark(at)ghoti(dot)org> |
Cc: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Re: ODBC Example with VB5? |
Date: | 2000-08-17 13:33:58 |
Message-ID: | 399BE9C6.B14E1336@mindspring.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2000-08-17 15:58:35 | Re: ODBC Example with VB5? |
Previous Message | Igor N. Avtaev | 2000-08-17 11:28:46 | Truble with version 1.9.0 of pgsql_perl5 |