ODBC Ver 6 - 64bit vs 32bit with Division

[mcohen]

I have the following query which causes the 64 bit application to crash.
select
IC_WAREHOUSE_ITM.ITEM_NUM
, IC_WAREHOUSE_ITM.WAREHOUSE
, IC_WAREHOUSE_ITM.ON_HAND
, (IC_WAREHOUSE_ITM.ON_HAND / 1 ) AS 'TEST'
from
IC_WAREHOUSE_ITM

I have installed 2 different 64 bit applications for testing purposes. I have also deployed a 32 bit application for testing purposes.
It works with the 32 bit driver V6.0 and V6.10, but not the 64 bit driver.
I have gone through the motions of validating both the client and server match for version number.
If I remove the /1 then it works in both cases.
Thoughts are appreciated.

[Devon Austen]

I just tried this here and I do not get any crash. I get back the correct response for the query.

I am testing with one of my own files. Could it be that your file has some odd data in it that it triggering the problem?

I would suggest you create a helpdesk ticket if you want PVX Plus to look further into the crash issue.

[mcohen]

Since this is working in your data and not mine, and it is working for me with 32 bit, I will ask if it is possible that your data is missing two possible situations.
One where the data is "0", and the other where the data is "NULL"?

The other question I should ask.
Are you using a client/server licensed scenario or are you going direct?

[Devon Austen]

OK that was the reason I didn't reproduce the issue.

I tried with a table with 0 in the field and got the crash as described.

This is a bug in the ODBC driver and you will need to create a help desk ticket (http://helpdesk.pvxplus.com/) so we can track and resolve the issue.