Re: psqlODBC ODBC3.0/Column Names

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: psqlODBC ODBC3.0/Column Names
Date: 2002-03-29 16:29:07
Message-ID: EKEJJICOHDIEMGPNIFIJGEBEHFAA.Inoue@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

> -----Original Message-----
> From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
> > > > You seem to be forgetting to call DataAdapter.Update method.
> > >
> > > Yes, thanks. Unfortunately though, both my problems remain.
> > >
> > > - The ODBC3 driver returns 'Column1','Column2' etc as the column
> > > names (the
> > > 2.5 driver is fine).
> >
> > Hmm I see neither here.
> > Please try the latest driver at
> > http://w2422.nsk.ne.jp/~inoue/ . No explicit
> > OdbcCommandBuilder is needed.
>
> Aha. The unicode enabled v3 driver is returning the column names
> correctly.
> Thanks.
>
> I'm still not getting update/insert/delete commands though, either with or
> without the OdbcCommandBuilder. I must admit confused by you
> saying I don't
> need it though, I thought the whole point was that the
> DataAdaptor *didn't*
> spend time figuring out the queries & their parameters unless explicitly
> told to (from the Microsoft docs):

Sorry the statement
OdbcCommandBuilder cbDB = new OdbcCommandBuilder(adDB);
seems to be needed.
I can add a row by adding the statement
adDB.Update(dsDB);
after the statement
dsDB.Tables[0].Rows.Add(rwDB);

regards,
Hiroshi Inoue

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Hiroshi Inoue 2002-03-29 16:29:13 Re: 'infinity'::timestamp not translated correctly using ODBCv7.01.00.10 ?
Previous Message DI Hasenöhrl 2002-03-29 10:29:59 ODBCdirect and MsAccess97