From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | 'Hiroshi Inoue' <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: psqlODBC ODBC3.0/Column Names |
Date: | 2002-03-30 20:45:55 |
Message-ID: | FED2B709E3270E4B903EB0175A49BCB1293332@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> Sent: 29 March 2002 16:29
> To: Dave Page
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: RE: [ODBC] psqlODBC ODBC3.0/Column Names
>
>
> > -----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);
Strange, That works perfectly, thanks. I put it after the following line
which is:
dsDB.Tables[0].AcceptChanges();
Obviously that doesn't do quote what I thought.
Thanks again,
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Eric March | 2002-03-30 22:49:22 | WIN Connection -> ODBC -> Linux Slackware |
Previous Message | Hiroshi Inoue | 2002-03-30 09:01:00 | Re: ODBCdirect and MsAccess97 |