(2012/07/16 1:40), Lionel Elie Mamane wrote:
> On Mon, Jul 16, 2012 at 12:50:40AM +0900, Hiroshi Inoue wrote:
>> (2012/07/15 14:02), Lionel Elie Mamane wrote:
>>> On Sun, Jul 15, 2012 at 06:50:27AM +0900, Hiroshi Inoue wrote:
>>>> (2012/07/10 23:27), Lionel Elie Mamane wrote:
>
>>>>> Also, the ultimate reason for this "strange thing" is that
>
>>>>> SQLColAttribute( (SQLHANDLE) 0x1ec7850,
>>>>> (SQLUSMALLINT) 1,
>>>>> (SQLUSMALLINT) 15,
>>>>> (SQLPOINTER) 0x1eb2640,
>>>>> 128,
>>>>> (SQLSMALLINT *) 0x7fffffff97de,
>>>>> NULL);
>
>>>>> where 15 == SQL_DESC_TABLE_NAME == SQL_COLUMN_TABLE_NAME
>>>>> returns (writes at 0x1eb2640) an empty string for this query:
>
>>>>> SELECT "Num" "Numero", "data" FROM "foo"."Table1"
>
>>>> What is your environment e.g. the version of your PG server
>>>> or the version of your psqlodbc?
>
>>> On Debian GNU/Linux amd64, Debian packages.
>
>>> Client:
>>> unixodbc 2.2.14p2-5
>>> psqlodbc 09.01.0100
>>> libpq5 9.1.3
>>> Server:
>>> postgresql 9.0.6
>
>> SQLColattribute returns non null string here under Windows environment.
>> Well how are you setting odbc.ini?
>
> [PgSQL tst]
> Description = PostgreSQL test
> Driver = PostgreSQL Unicode
> Trace = No
> TraceFile =
> Database = lobugs
> Servername = pgsql.localdomain
> Username =
> Password =
> Port = 5432
> Protocol = 6.4
> ReadOnly = No
> RowVersioning = No
> ShowSystemTables = No
> ShowOidColumn = No
> FakeOidIndex = No
> ConnSettings =
Please set the following.
Protocol = 7.4
Setting
UseServerSidePrepare = 1
is also recommended.
regards,
Hiroshi Inoue