Issue with ODBC on 64 bit machine while using SQLUINTEGER and SQLINTEGER

[faizan123]

hello freinds,
I have been facing problem while using SQLUINTEGER and SQLINTEGER on the 64  bit machine while the same code works fine on 32 bit machine is their any issue with unix odbc on 64 bit machines is their any way out tom solve this problem.please help me out .

regards,
Faizan
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

[Vivek Venugopal]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi Faizan,

Can you tell us what is the problem you facing?

 

Thanks,

Vivek

From: unixodbc-dev-bounces@... [mailto:unixodbc-dev-bounces@...] On Behalf Of qureshifaizan faiz
Sent: Thursday, March 27, 2008 10:55 AM
To: unixodbc-dev@...
Subject: [unixODBC-dev] Issue with ODBC on 64 bit machine while usingSQLUINTEGER and SQLINTEGER

 

hello freinds,
I have been facing problem while using SQLUINTEGER and SQLINTEGER on the 64  bit machine while the same code works fine on 32 bit machine is their any issue with unix odbc on 64 bit machines is their any way out tom solve this problem.please help me out .

regards,
Faizan

"This email and any files transmitted with it contain confidential, proprietary, 
privileged information of Symphony Services Corp (India) Pvt. Ltd. and are intended 
solely for the use of the recipient/s to whom it is addressed. Any unauthorized 
notifying, copying or distributing of this e-mail, directly or indirectly, and the 
contents therein in full or part is prohibited by any entity who is not a recipient. 
Any email received inadvertently or by mistake should be deleted by the entity who 
is not a recipient thereof. You may be pleased to notify the sender immediately by 
email and the email should be deleted from your system".

_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

[faizan123]

Hi Vivek,
Thanks for the reply.Take this simple example

"select ID from TEST_TABLE where TEST_VALUE = ?"

This query works fine in CLI using mysql 5.1.

But in the application when i EXECUTE this query iam unable to fetch the data using the SQLFetch and it returns DB_NO_DATA with a result code 100 or some times gives a junk value.
The procedure i have followed is as follows.

i have used SQLUINTEGER for the input parameter in case of SQLBindParameter.

SQLUINTEGER value;
SQLBindParameter(sthdl,1,SQL_PARAM_INPUT,SQL_C_ULONG,SQL_INTEGER,00,0,&value,00,00);

SQINTEGER indIdValue;
SQLUINTEGER idValue;
retCode = SQLBindCol(sthdl,1,SQL_C_ULONG,&idValue,sizeof(idValue),&indIdValue);
and same in the case of out put SQLBindCol

//steps followed are.
SQLPrepare
SQLBindParameter
SQLExecute
SQLBindCol
SQLFetch

Iam executing this on a 64 bit machine with mysql 5.1.

But the same code works fine on a 32 bit machine with mysql4.0.

Iam not getting clue what the problem is.I will be very grateful if you could help
me solve this problem

Regards
Faizan.

On Thu, Mar 27, 2008 at 11:50 AM, Vivek Venugopal <Vivek.Venugopal@...> wrote:

Hi Faizan,

Can you tell us what is the problem you facing?

 

Thanks,

Vivek

From: unixodbc-dev-bounces@... [mailto:unixodbc-dev-bounces@...] On Behalf Of qureshifaizan faiz
Sent: Thursday, March 27, 2008 10:55 AM
To: unixodbc-dev@...
Subject: [unixODBC-dev] Issue with ODBC on 64 bit machine while usingSQLUINTEGER and SQLINTEGER

 

hello freinds,
I have been facing problem while using SQLUINTEGER and SQLINTEGER on the 64  bit machine while the same code works fine on 32 bit machine is their any issue with unix odbc on 64 bit machines is their any way out tom solve this problem.please help me out .

regards,
Faizan

"This email and any files transmitted with it contain confidential, proprietary, 
privileged information of Symphony Services Corp (India) Pvt. Ltd. and are intended 
solely for the use of the recipient/s to whom it is addressed. Any unauthorized 
notifying, copying or distributing of this e-mail, directly or indirectly, and the 
contents therein in full or part is prohibited by any entity who is not a recipient. 
Any email received inadvertently or by mistake should be deleted by the entity who 
is not a recipient thereof. You may be pleased to notify the sender immediately by 
email and the email should be deleted from your system".

_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

[faizan123]

Hi Vivek,
Thanks for the reply.Take this simple example

"select ID from TEST_TABLE where TEST_VALUE = ?"

This query works fine in CLI using mysql 5.1.

But in the application when i EXECUTE this query iam unable to fetch the data using the SQLFetch and it returns DB_NO_DATA with a result code 100 or some times gives a junk value.
The procedure i have followed is as follows.

i have used SQLUINTEGER for the input parameter in case of SQLBindParameter.

SQLUINTEGER value;
SQLBindParameter(sthdl,1,SQL_PARAM_INPUT,SQL_C_ULONG,SQL_INTEGER,00,0,&value,00,00);

SQINTEGER indIdValue;
SQLUINTEGER idValue;
retCode = SQLBindCol(sthdl,1,SQL_C_ULONG,&idValue,sizeof(idValue),&indIdValue);
and same in the case of out put SQLBindCol

//steps followed are.
SQLPrepare
SQLBindParameter
SQLExecute
SQLBindCol
SQLFetch

Iam executing this on a 64 bit machine with mysql 5.1.

But the same code works fine on a 32 bit machine with mysql4.0.

Iam not getting clue what the problem is.I will be very grateful if you could help
me solve this problem

Regards
Faizan.

On Thu, Mar 27, 2008 at 11:50 AM, Vivek Venugopal <Vivek.Venugopal@...> wrote:

Hi Faizan,

Can you tell us what is the problem you facing?

 

Thanks,

Vivek

From: unixodbc-dev-bounces@... [mailto:unixodbc-dev-bounces@...] On Behalf Of qureshifaizan faiz
Sent: Thursday, March 27, 2008 10:55 AM
To: unixodbc-dev@...
Subject: [unixODBC-dev] Issue with ODBC on 64 bit machine while usingSQLUINTEGER and SQLINTEGER

 

hello freinds,
I have been facing problem while using SQLUINTEGER and SQLINTEGER on the 64  bit machine while the same code works fine on 32 bit machine is their any issue with unix odbc on 64 bit machines is their any way out tom solve this problem.please help me out .

regards,
Faizan

"This email and any files transmitted with it contain confidential, proprietary, 
privileged information of Symphony Services Corp (India) Pvt. Ltd. and are intended 
solely for the use of the recipient/s to whom it is addressed. Any unauthorized 
notifying, copying or distributing of this e-mail, directly or indirectly, and the 
contents therein in full or part is prohibited by any entity who is not a recipient. 
Any email received inadvertently or by mistake should be deleted by the entity who 
is not a recipient thereof. You may be pleased to notify the sender immediately by 
email and the email should be deleted from your system".

_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev

[Nick Gorham-2]

qureshifaizan faiz wrote:

> hello freinds,
> I have been facing problem while using SQLUINTEGER and SQLINTEGER on
> the 64  bit machine while the same code works fine on 32 bit machine
> is their any issue with unix odbc on 64 bit machines is their any way
> out tom solve this problem.please help me out .
>
> regards,
> Faizan
>
>------------------------------------------------------------------------
>
>_______________________________________________
>unixODBC-dev mailing list
>unixODBC-dev@...
>http://mail.easysoft.com/mailman/listinfo/unixodbc-dev
>  
>

How are you defining the value you are fetcing into?

--
Nick
_______________________________________________
unixODBC-dev mailing list
unixODBC-dev@...
http://mail.easysoft.com/mailman/listinfo/unixodbc-dev