IBMDA400 Provider & SQL 2008 select statement issue

45 pts.
Tags:
IBMDA400
SQL Server 2008 64-bit
Using IBMDA400 as a provider on SQL 2008 server then a link server object. In the studio when I ask it to create a select statement for a table the numeric columns are not included. I can do Select * and all fields are included and the query works fine or I can simply add the numeric fields to the select statment and it works. Where do I look for a solution to this problem

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: 8  Replies

 
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
  • Peteakers
    Is everyone to chicken to take a stab at this one.  Thanks 
    45 pointsBadges:
    report
  • philpl1jb

    This might/might not relate to your problem:

     

    http://connect.microsoft.com/SQLServer/feedback/details/277518/cannot-create-a-column-accessor-for-ole-db-provider-ibmda400-for-linked-server-servername

    IBM's answer to that problem was to use IBMDASQL insetead of IBMDA400.

    50,415 pointsBadges:
    report
  • philpl1jb

    And here:

    http://www-01.ibm.com/support/docview.wss?uid=nas1d7cd7e4509cc894c86257280005c65dc

    IBM says that " IBMDASQL OLE DB provider is the provider that should be used with Microsoft SQL Server linked servers. "

    50,415 pointsBadges:
    report
  • philpl1jb

    I’m more pidgen than chicken. 

    Don’t know whose statue I’m standing on but I can …

    50,415 pointsBadges:
    report
  • Peteakers
    I really didn't mean to insult any one. You are all a great bunch I am sure. I just want to push your buttons a little.  Thank you so much for your responses. I need a little time to go through them to see if one holds the answer to my prayers. 
    45 pointsBadges:
    report
  • philpl1jb

    I don't know if what I found is relevant. 

    I haven't worked with SQL Server 2008 ..

    50,415 pointsBadges:
    report
  • Peteakers
    Phil thank you for the response.  I am still working on this issue. I am thinking it is an issue with SQL Server 2008.  I have tried IBMDASQL & IBMDA400 and get basically the same results.  We have opened up a ticket with IBM on this also.  
    45 pointsBadges:
    report
  • philpl1jb

    Thanks for the feedback. 

    Good Luck

    50,415 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