Re: psqlODBC ODBC3.0/Column Names

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> Sent: 28 March 2002 04:26
> To: Dave Page
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] psqlODBC ODBC3.0/Column Names
>
>
> Dave Page wrote:
> >
> > > -----Original Message-----
> > > From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> > > Sent: 27 March 2002 20:37
> > > 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]
> > > > > -----Original Message-----
> > > > > From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> > > > >
> > > > > Hmm I couldn't find so many info in it unfortunately.
> Could you
> > > > > send me the above(or simpler) .NET example ? Probably
> I would be
> > > > > able to touch a .NET environemnt.
> > > >
> > > > Hmm, I thought it was in the .zip with the logs. I've
> attached it
> > > > again anyway.
> > >
> > > Oops I overlooked it sorry.
> > >
> > > > I can also do an SQL Trace if that would help?
> > >
> >
> > Attached. This represents a complete run of the program
> using the v3
> > driver. I have changed the references to the column names in the
> > program to Column1 etc. just to stop it erroring.
>
> 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).

- DataAdapter.Update won't work (yet) because the OdbcCommandBuilder won't
generate the insert/update/delete queries *I assume* because the driver
doesn't give it all the info it needs (the errors in the logs?). Manually
building the queries and their associated parameters is possible (but a
*lot* of work) assuming you have knowledge of the database at design time.
Of course, with something like pgAdmin this is not possible.

Regards, Dave.