[unixODBC-support] problems with 64 bit SQLBindParameter()

Nick Gorham nick.gorham at easysoft.com
Mon Nov 20 09:51:36 GMT 2006


Hu, Ming (Ivan) wrote:

>Hi,Nick,
>
>Thanks for your response.
>
>But unfortunately, my application is setting up two ODBC connections to two
>different DB at the same time, one is postgresql, 
>the other is TimesTen.
>
>For TimesTen, it has to be be REAL 64 bit mode (when I tried with non REAL
>64 bit mode, core dump occured), for Postgresql, 
>SQLBindParameter() can not work if REAL 64 bit mode. Seems what's the
>handling of two drivers are totally different.
>
>Could you pls have some recommendations how to figure it out.
>
>Thanks
>Ivan
>
>-----Original Message-----
>From: unixodbc-support-bounces at easysoft.com
>[mailto:unixodbc-support-bounces at easysoft.com]On Behalf Of Nick Gorham
>Sent: 2006?11?19? 9:21 PM
>To: Support for the unixODBC project
>Subject: Re: [unixODBC-support] problems with 64 bit SQLBindParameter()
>
>
>Hu, Ming (Ivan) wrote:
>
>  
>
>>Hi, 
>>
>>I am pretty new to unixODBC, but currently, meet a headache with
>>SQLBindParameter() calling, pls help me.
>>
>>I am working on solaris, using unixODBC to set up connection to postgresql,
>>and on truly 64 bit enviroment.
>>
>>In sql.h, I am seeing a macro BUILD_REAL_64_BIT_MODE is defined for truly
>>    
>>
>64
>  
>
>>bit application.
>>For my application, I defined the macro BUILD_REAL_64_BIT_MODE  to make
>>SQLLEN as long.
>>But when calling SQLBindParameter() for SQL_CHAR or SQL_BINARY, the data
>>could not be binded correctly.
>>The SQLBindParameter() don't return error, but when executing the
>>    
>>
>statement,
>  
>
>>seems the data is null.
>>
>>Because my application is working in 64 bit enviroment, and using unixODBC
>>to connect another DB, for 64 bit, 
>>It has to define long as SQLLEN. Then how can I make it work with
>>SQLBindParameter() for postgresql.
>>
>>Could you pls help me on it, Thanks in advance.
>> 
>>    
>>
Ok, it may need the postgres driver modifying to handle that. Which PG 
driver are you using?

-- 
Nick Gorham
Easysoft Limited
http://www.easysoft.com, http://www.unixODBC.org




More information about the unixODBC-support mailing list