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
unixodbc2.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-odbc