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

Re: psqlodbc-08.04.0200 unicode

From: Marian Popeanga <marian(at)byteanywhere(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: psqlodbc-08.04.0200 unicode
Date: 2010-03-29 15:29:53
Message-ID: 20100329152952.GA27099@byteanywhere.com (view raw or flat)
Thread:
Lists: pgsql-odbc

    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

In response to

pgsql-odbc by date

Next:From: raja agireddyDate: 2010-03-30 16:56:38
Subject: iodbctest: fatal: relocation error
Previous:From: Tom LaneDate: 2010-03-25 19:59:32
Subject: Re: configuring psqlodbc 08.04.0200 with openssl

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