SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-16-2008, 02:00 AM
| ||||
| ||||
 DescribParam When I call SQLDescribeParam using PostgreSQL ODBC Driver psqlodbc-08_02_0002 SQL_ERROR is the return code. What I am trying to do with this call is determine the buffer size needed to allocate a buffer so I can call SQLBindParameter with a big enough buffer. I have tried defaulting this to a number > 255, but this causes some other drivers, like MS Access to choke. MS SQL Server and others return the correct parameter size. My only thought was to provide an override for this in my library to force the parameter size when the driver does not return it. Does anyone have a better workaround for this? Glenn Lawler www.incodesystems.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
|
04-16-2008, 02:00 AM
| |||
| |||
| Re: DescribParam > When I call SQLDescribeParam using PostgreSQL ODBC Driver > psqlodbc-08_02_0002 SQL_ERROR is the return code. This API has never been supported. Why do you use it when psqlODBC returns info that it doesn't support SQLDescribeParam? > What I am trying to do with this call is determine the buffer size > needed to allocate a buffer so I can call SQLBindParameter with > a big enough buffer. There is the problem that PgSQL backend doesn't support it before execution (I haven't found another information yet). > My only thought was to provide an override for this in my library > to force the parameter size when the driver does not return it. Maybe you may depend on other information like PostgreSQL driver, ... > Does anyone have a better workaround for this? Sorry, I don't have one. Regards, Luf ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match |
|
04-16-2008, 02:00 AM
| ||||
| ||||
| Re: DescribParam Glenn B. Lawler wrote: > When I call SQLDescribeParam using PostgreSQL ODBC Driver psqlodbc-08_02_0002 > SQL_ERROR is the return code. Are you checking the 7.4+ Protocol option ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings |
Linear Mode
