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


--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

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

--
Sent via pgsql-odbc mailing list (pgsql-odbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc