Skip to Content
avatar image
Former Member

Why is Crystal 2016 throwing an error when connecting to datasource?

The error message is:

Database Connector Error: '07009:[Microsoft][SQL Server Native Client 11.0]Invalid Descriptor Index'

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 19, 2017 at 02:19 PM

    Hi Wendy, did you find out how to resolve this?

    This error usually comes when your procedure or function return columns in the following Order: A, B, C, D, E, and crystal is expecting something like E, B, A, D, C. So check the order of the columns you're expecting vs the order of columns you're actually receiving from SQL Server.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2017 at 02:22 PM

    I didn't find out how to resolve this but will try your suggestion. Will let you know.

    Add comment
    10|10000 characters needed characters exceeded