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,
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:
Then get SP 5 and SP 6: