Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-odbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group