IBMDA400 Date Issues

1705 pts.
Tags:
AS/400
iSeries
ODBC
The IBMDA400 provider seems to convert dates to character values even when using keyword "Convert Date Time To Char=FALSE". This does not happen with the ODBC driver or IBMDASQL provider. I'd be okay with IBMDASQL except IBM states it only works the SQL statements. I'd be okay with ODBC driver except records can be doubled when using it with Windows 7 Pro 64 bit and Client Access 7.1. [1] Is there a way to convert dates to PC Date values with IBMDA400? [2] Is there a better provider that works with XP - Windows 7 PCs? [3] Is there a way to prevent the ODBC driver from doubling records in Windows 7?

Software/Hardware used:
Client Access, iSeries

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    Is there a way to convert dates to PC Date values with IBMDA400?   What is a "PC date value"? I'm not aware of such a thing.   Is there a way to prevent the ODBC driver from doubling records in Windows 7?   I've never heard of such a problem. If it exists as a problem, either install the appropriate service pack or have IBM fix it.   Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following