psqlODBC ODBC3.0/Column Names

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'pgsql-odbc(at)postgresql(dot)org'" <pgsql-odbc(at)postgresql(dot)org>
Subject: psqlODBC ODBC3.0/Column Names
Date: 2002-03-26 16:37:03
Message-ID: FED2B709E3270E4B903EB0175A49BCB1293304@dogbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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:

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, but that
may just be .NET not figuring it out correctly.

Regards, Dave.

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Dave Page 2002-03-26 21:19:20 .NET ODBC Data Provider
Previous Message Hiroshi Inoue 2002-03-26 00:49:36 Re: Warnings