Re: psqlodbc-08.04.0200 unicode

I managed to find out where the problem is.
This should be fixed in the repository, so please go ahead.

1. configure wrongly assumed that unixODBC was using SQL_WCHART_CONVERT
and it was generating a wrong config.h

/* Define to use wchar_t as SQLWCHAR in unixODBC */
#define SQL_WCHART_CONVERT

2. Function SQLExtendedFetch should be fixed to allow SQLULEN as parameter for unixODBC.

RETCODE SQL_API
SQLExtendedFetch(
HSTMT hstmt,
SQLUSMALLINT fFetchType,
SQLLEN irow,
#ifdef WITH_UNIXODBC
SQLULEN /*SQLROWSETSIZE*/ *pcrow, <-- SQLROWSETSIZE is wrong
#else
SQLULEN *pcrow,
#endif /* WITH_UNIXODBC */
SQLUSMALLINT *rgfRowStatus)

Thanks,
Marian

On Thu, Mar 25, 2010 at 10:27:05AM +0200, Marian Popeanga wrote:
>
>
>
> Hi,
>
> I am not able to connect to server 8.3 using this version psqlodbc-08.04.0200 of the driver, build with unixodbc 2.2.15( or 2.2.12).
> Both iusql and custom applications fail to connect using the unicode driver.
> isql, wich uses the ansi version works to connect.
>
> iusql ...
> [unixODBC]c
> [ISQL]ERROR: Could not SQLDriverConnect
>
> This is the unixodbc log :
>
> [ODBC][30330][SQLDriverConnectW.c][246]
> Entry:
> Connection = 0x182cd30
> Window Hdl = (nil)
> Str In = [DSN=jal;UID=marian;PWD=*******][length = 30 (SQL_NTS)]
> Str Out = (nil)
> Str Out Max = 0
> Str Out Ptr = (nil)
> Completion = 0
> UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'
>
> [ODBC][30330][SQLDriverConnectW.c][591]
> Exit:[SQL_ERROR]
> [ODBC][30330][SQLErrorW.c][317]
> Entry:
> Connection = 0x182cd30
> SQLState = 0x7fff7e6b11f0
> Native = 0x7fff7e6b1208
> Message Text = 0x7fff7e6b0e00
> Buffer Length = 500
> Text Len Ptr = 0x7fff7e6b120e
> [ODBC][30330][SQLErrorW.c][358]
>
>
> Is this a known issue?
>
>
> Thanks,
> Marian
>
>
> --
> Sent via pgsql-odbc mailing list (pgsql-odbc(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc