RE: Writing Large Objects to Postgresql via ODBC using VB - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject RE: Writing Large Objects to Postgresql via ODBC using VB
Date
Msg-id EKEJJICOHDIEMGPNIFIJGEIPEEAA.Inoue@tpf.co.jp
Whole thread Raw
In response to Writing Large Objects to Postgresql via ODBC using VB  (Matthew Dormer <matt@infosource.com.au>)
Responses RE: Writing Large Objects to Postgresql via ODBC using VB
List pgsql-odbc
> -----Original Message-----
> From: Matthew Dormer
>
> I am having problems writing to a postgres database using ODBC.  Here are
> the steps I have taken:
>
> 1.  I have greated a lo type in the database
>
> create type lo (
> internallength=4, externallength=10,
> input=int4in, output=int4out,
> default='', passedbyvalue
> );
>
>
> 2.  I create a table in the database
>
> Create table matt ( matt_id integer not null unique primary key,
> matt_text
> lo );
>
> 3.  I have a simple form with 1 rich text box, RichTextBox1 and a command
> button Command 1  Here is the code on the form:
>

Hmm you are using RDO.
Are you setting rdoEnvironments.CursorDriver to rdUseOdbc ?

regards,
Hiroshi Inoue


pgsql-odbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: I saw a table that wasn't there
Next
From: "Tom.Bakken"
Date:
Subject: MS Access97 Postgres ODBC problems