Re: psqlODBC ODBC3.0/Column Names - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: psqlODBC ODBC3.0/Column Names
Date
Msg-id EKEJJICOHDIEMGPNIFIJIEKGHEAA.Inoue@tpf.co.jp
Whole thread Raw
In response to psqlODBC ODBC3.0/Column Names  (Dave Page <dpage@vale-housing.co.uk>)
List pgsql-odbc
> I'm in the process of learning C#/.NET and whilst trying to persuade an
> OdbcCommandBuilder to work as documented, thought I'd try the
> (development)
> ODBC3 version of the driver to see if that was the problem.
>
> I still haven't go the OdbcCommandBuilder to work, but I did find
> that with
> the v3 driver, the columns appear to have lost their names. The following
> code returned the names as expected with the v2.5 driver, but Column1,
> Column2... with the v3:

Could you send me the MyLog output ?

>     foreach(DataColumn dcDB in dsDB.Tables[0].Columns)
>       Console.WriteLine("{0} ({1})", dcDB.ColumnName, dcDB.DataType);
>
> I also found that the table name isn't returned for either
> driver,

Probably you can see the table name if you check the *Parse
Statement* option. The *Parse Statement* is the only option
that could give us the table name or the base column name
(if the column has an alias). The other options(Premature
execution or Disallow Premature) couldn't give us the infos.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Dave Page
Date:
Subject: .NET ODBC Data Provider
Next
From: Dave Page
Date:
Subject: Re: psqlODBC ODBC3.0/Column Names