Skip to Content
0

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

Jul 31, 2017 at 06:26 PM

51

avatar image
Former Member

The error message is:

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Luis Darui
Sep 19, 2017 at 02:19 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Oct 16, 2017 at 02:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded