Skip site navigation (1) Skip section navigation (2)

SQLDescribeParam not defined: any workaround?

From: John Lawler <postgresql(dot)org(at)tgice(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: SQLDescribeParam not defined: any workaround?
Date: 2005-08-23 19:51:50
Message-ID: 430B7E56.7060305@tgice.com (view raw or flat)
Thread:
Lists: pgsql-odbc
 From what I've read about the win32 (and perhaps all platforms) 
Postgres ODBC driver, SQLDescribeParam is not implemented.  I discovered 
this while running some software that tries to use it.  It got back the:

   Driver does not support this function (SQLSTATE: IM001)

message, of course.

The reason my software was calling this function was to determine the 
scale and data type of the parameters to a function before issuing a 
prepared statement to that function.

Is anyone aware of a workaround via the existing (official) ODBC drivers 
whereby I could interrogate the function I'm about to call to get more 
detailed information about each parameter?

If not, what strategies do others employ to handle this?  Right now, my 
best shot is to just define my local buffers to 255 bytes or so and go 
from there, but clearly that's not flexible or elegant.

Thanks,

jl

pgsql-odbc by date

Next:From: Nathan PflugerDate: 2005-08-23 21:51:47
Subject: ODBC driver: Rows Affected
Previous:From: YLDate: 2005-08-23 16:37:04
Subject: Problems found when compare pgsql odbc 8.0 and myodbc 3.5 using EOModeler

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group