Обсуждение: psqlodbc-08.04.0200 unicode

      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=glugacn][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

    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