cancel
Showing results for 
Search instead for 
Did you mean: 

Invalid Descriptor Index

Former Member
0 Kudos

Dear SAP Experts,

I created a query using many temp tables. When I run the query in SQL it works fine. However, when I bring the query into Crystal Reports XI, I receive the following error message:

Database Connector Error: '07009': [Microsoft][ODBC SQL Server Driver] Invalid Descriptor Index'

Has anyone ever come across this error or know how to fix it?

Thank in advance,

Zack H.

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

When you test the SQL directly against the MS SQL server are you sure that you are using the ODBC driver?

Which version of the MS SQL server are you accessing?

Regards,

Stratos

Answers (2)

Answers (2)

Former Member
0 Kudos

There were some field names that were the same. Once I made each field unique, the invalid descriptor index error was not produced any longer.

0 Kudos

Ah... that would do it also... Thank you for updating the post with your solution.

0 Kudos

Hi Zack,

Have you installed any patches for CR XI?

When you say you are bringing them into CR how are you doing that? Are you using a Command Object or trying to run the SQL Query directly? CR doesn't support "queries" in that context. What it can do though is use a Stored Procedure. So create a SP and copy your query into it. Also note CR only see's the last SELECT statement in the SP so if you use more than one it's the last one CR can see.

Depending on how you wrote your query it may work as is, be sure to use a Cursor also, CR requires a cursor to be able to read the data set.

If you search our knowledge base system you'll find examples of how to write a SP so CR can see and use it.

And if you are using MS SQL Server 2008 you will need to upgrade to CR XI R2, for free, so it is supported.

I suggest you upgrade to XI R2 anyways, use your XI keycode when you install.

This is the link to get the full vuild:

https://smpdl.sap-ag.de/~sapidp/012002523100011802732008E/crxir2_sp4_full_build.exe

Then get SP 5 and SP 6:

https://smpdl.sap-ag.de/~sapidp/012002523100013876392008E/crxir2win_sp5.exe

https://smpdl.sap-ag.de/~sapidp/012002523100015859952009E/crxir2win_sp6.exe

Thank you

Don